|
Hey Thuy Dinh ,
You need server-side intervention to keep track of visitors and clientside JavaScript alone cannot achieve this trick. Perhaps if you do not have access to serverside scripts and can use only static html pages, check out
http://www.thefreesite.com/
(Webmaster Freebies section) and there are lot of cobranded counters/site stat services, that can help you).
Deepak Kumar Vasudevan
http://deepak.portland.co.uk/
|
|
|
|
|
Thank you very much for your help. I'll find what I want now.
Thuydinh,
|
|
|
|
|
I am suffering from a lot of pain doing this. And I have decided to bring this to you genius - with the belief that someone on this planet will safe me further trauma debuggin this script.
Here's what i have on my ASP script:
'Connecting to Microsoft SQL Server:
oConn.ConnectionString = "Provider=sqloledb; Data Source=(local); Initial Catalog='dummyDB'; User ID=sa; Password=sa"
oConn.Open
'Update profile through stored procedure "sproc_ChangeProfile":
Set oCmd = Server.CreateObject("ADODB.Command")
With oCmd
.ActiveConnection = oConn
.CommandText = "dbo.sproc_ChangeProfile"
.CommandType = adCmdStoredProc
.Parameters.Append .CreateParameter("@old_login", adChar, adParamInput, 15, Request.Form("txtOldLogin") )
.Parameters.Append .CreateParameter("@login", adChar, adParamInput, 15, Request.Form("txtLogin") )
.Parameters.Append .CreateParameter("@password", adChar, adParamInput, 15, Request.Form("txtPasswd") )
.Parameters.Append .CreateParameter("@first_name", adChar, adParamInput, 50, Request.Form("first_name") )
.Parameters.Append .CreateParameter("@middle_name", adChar, adParamInput, 50, Request.Form("middle_name") )
.Parameters.Append .CreateParameter("@last_name", adChar, adParamInput, 50, Request.Form("last_name") )
.Parameters.Append .CreateParameter("@email1", adChar, adParamInput, 50, Request.Form("email1") )
.Parameters.Append .CreateParameter("@email2", adChar, adParamInput, 50, Request.Form("email2") )
.Parameters.Append .CreateParameter("@tel_home", adChar, adParamInput, 30, Request.Form("tel_home") )
.Parameters.Append .CreateParameter("@tel_office", adChar, adParamInput, 30, Request.Form("tel_office") )
.Parameters.Append .CreateParameter("@tel_fax", adChar, adParamInput, 30, Request.Form("tel_fax") )
.Parameters.Append .CreateParameter("@tel_cell", adChar, adParamInput, 30, Request.Form("tel_cell") )
.Parameters.Append .CreateParameter("@tel_pager", adChar, adParamInput, 30, Request.Form("tel_pager") )
.Parameters.Append .CreateParameter("@title", adChar, adParamInput, 100, Request.Form("title") )
.Parameters.Append .CreateParameter("@association", adChar, adParamInput, 50, Request.Form("association") )
.Parameters.Append .CreateParameter("@address_unit_num", adChar, adParamInput, 15, Request.Form("address_unit_num") )
.Parameters.Append .CreateParameter("@address_bldg_name", adChar, adParamInput, 50, Request.Form("address_bldg_name") )
.Parameters.Append .CreateParameter("@address_street_num", adChar, adParamInput, 15, Request.Form("address_street_num") )
.Parameters.Append .CreateParameter("@address_street", adChar, adParamInput, 100, Request.Form("address_street") )
.Parameters.Append .CreateParameter("@address_city", adChar, adParamInput, 100, Request.Form("address_city") )
.Parameters.Append .CreateParameter("@address_province", adChar, adParamInput, 100, Request.Form("address_province") )
.Parameters.Append .CreateParameter("@address_country", adChar, adParamInput, 100, Request.Form("address_country") )
.Parameters.Append .CreateParameter("@address_zipcode", adChar, adParamInput, 100, Request.Form("address_zipcode") )
.Parameters.Append .CreateParameter("@update_target", adInteger, adParamInput, 4, Request.Form("update_target"))
.Parameters.Append .CreateParameter("@error_status", adInteger, adParamOutput, 4, 0) 'OUTPUT: error status.
'Execute the stored procedure:
.Execute
End With
'Check return status:
If oCmd.Parameters("@error_status")=0 Then
'No error.
Else
'exception handling - please refer to stored procedure for error code interpretation.
bstatuscode=oCmd.Parameters("@error_status")
End If
Here's the declaration of the stored procedure in question:
CREATE PROCEDURE dbo.sproc_ChangeProfile(
@old_login char(15) =NULL,
@login char(15) =NULL,
@password char(15) =NULL,
@first_name char(50) =NULL,
@middle_name char(50) =NULL,
@last_name char(50) =NULL,
@email1 char(50) =NULL,
@email2 char(50) =NULL,
@tel_home char(30) =NULL,
@tel_office char(30) =NULL,
@tel_fax char(30) =NULL,
@tel_cell char(30) =NULL,
@tel_pager char(30) =NULL,
@title char(100) =NULL,
@association char(50) =NULL,
@address_unit_num char(15) =NULL,
@address_bldg_name char(50) =NULL,
@address_street_num char(15) =NULL,
@address_street char(100) =NULL,
@address_city char(100) =NULL,
@address_province char(100) =NULL,
@address_country char(100) =NULL,
@address_zipcode char(100) =NULL,
@update_target int=0,
@error_status int OUTPUT
)
I have checked and cross referenced many times. The types and parameters between the ASP and SQL script matches exactly. I have NO idea why I keep getting this following message when this script is executed:
ADODB.Command error '800a0bb9'
Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another.
/submit_changed_profile.asp, line 39
Help!
norm
|
|
|
|
|
Line 39 where the error occurs, which one is it?
Philip Patrick
Web-site: www.stpworks.com
"Two beer or not two beer?" Shakesbeer
|
|
|
|
|
Thanks Philips, I've found it!
I fogot to include:
My mistake, and i sufferred from it for the whole nite!
norm
|
|
|
|
|
Lol, happend once to me too  Good luck
Philip Patrick
Web-site: www.stpworks.com
"Two beer or not two beer?" Shakesbeer
|
|
|
|
|
Thanks though, I guess the hard work pays off 
norm
|
|
|
|
|
How can i make my site to be resizeable depending on the visitors screen size/resolution????
Challenge everything
www.programers-g.tk
|
|
|
|
|
Depends on how complex of a site you have ...
If you want to maximize the browser window and have your content fit it regardless of the size you can use javascript to resize the window:
window.resizeTo(screen.availWidth,screen.availHeight);
window.moveTo(0,0);
And then in you HTML you could use tables that have 100% for the width to take up the entire width of the screen ...
That's just a suggestion ... depends on what you want to do ...
Wally Atkins
Newport News, VA, USA
|
|
|
|
|
i have built an html/asp menu:
<table>
<tr OnMouseOver="bgColor='AliceBlue' OnMouseOut="bgColor='White' .... >
<td>menu item 1</td>
<tr>
<tr OnMouseOver="bgColor='AliceBlue' OnMouseOut="bgColor='White' .... >
<td>menu item 2</td>
<tr>
<tr OnMouseOver="bgColor='AliceBlue' OnMouseOut="bgColor='White' .... >
<td>menu item 3</td>
<tr>
<tr OnMouseOver="bgColor='AliceBlue' OnMouseOut="bgColor='White' .... >
<td>menu item 4</td>
<tr>
</table>
Question is, how can you set the icon for the cursor when mouse over?
norm
|
|
|
|
|
<br />
<tr style ="CURSOR: hand"onmouseover="bgColor='AliceBlue' onmouseout=" bgColor='White' ....><br />
<td>menu item 1</td><br />
<tr><br />
|
|
|
|
|
How can I enforce a margin to a web document, I am using CSS for formating documents (I only use XML with a CMS that generates HTML, because I use both Windows and Linux  :P). I have tried left-margin ... and it hasn't worked. My teacher is strick about margins. Also how can I prevent a header from being placed on the first page?
-Steven
CP Addict
By reading this message you are held fully responsible for any of the mispelln's or grammer, issues, found on, codeproject.com.
For those who were wondering, actual (Linux) Penguins were harmed in creating this message.
|
|
|
|
|
have you tried:
<body topmargin="0" leftmargin="0">
Works in IE ... hope it works in others 
Wally Atkins
Newport News, VA, USA
|
|
|
|
|
Add this to your CSS page:
body
{
margin-left:5;
margin-top:5;
margin-right:5;
margin-bottom:5;
}
Change the values as per your requirements.
HTH.
Regards,
Rohit Sinha
Character is like a tree, and reputation like its shadow. The shadow is what we think of it; the tree is the real thing.
- Abraham Lincoln
The whole world steps aside for the man who knows where he is going.
- Anonymous
|
|
|
|
|
Hi all,
I'm not sure if this is the right place to post, but...
Is there any way to control the WSDL produced in a VS.NET C# Web Services Project? I'm guessing it might be something involving attributes.
Basically, I'm using SOAP to return subsets of a database, and I think DataSet et. al. may be a little to heavy-weight for what I need. An example of what I want is a SOAP function GetAuthorInfo( UINT id ) that returns an author's details as XML, conforming to a predefined Schema. I'd like to be able to specify this Schema in my WSDL file.
I'm new to the whole SOAP/XML/Web Service thing, so I'm not sure if this is a really naive way to implemnt this kind of functionality, so any comments and suggestions are most welcome.
TIA,
Pete
|
|
|
|
|
hello,
i'd like to use a file input field where the user can select a
file. if the filename is entered manually or by browsing i
can access the filename by the value property. but i also
like to set the value to different default values by
clicking on different buttons. but setting the value with
File1.value = "TEST"; during runtime does not work. the
field stays empty.
how can i change the value of the file input field? 
thanks
enrico
|
|
|
|
|
The MSDN docs state that the file *path* is only available (i.e., can't set but can get) to machines in the Local Machine zone, but only the file *name* is available to machines outside said zone.
This is for security reasons. Computers on the Internet (besides your own) shouldn't be able to know anything about your system other than what you tell them. Knowing your file paths is information no one else really needs to know. Also, imagine what would happen if a web site could *set* the "value" attribute: all I'd have to do is set "style='display:none;'" on the input box and I could upload any of *your* files I wanted to without you knowing, like your personal or machine registry hives or other files for which I know the common paths.
Reminiscent of my younger years...
10 LOAD "SCISSORS"
20 RUN
|
|
|
|
|
I have an inline frame on my webpage of which the contents and height change according to different buttons the user might push. The problem is that I that when I use the following code:
<iframe class = "tab" id = "child" FRAMEBORDER = "0" width = "90%" align = "center" onload = "ChangeChild('features.html')">
</iframe>
the web page loads but keeps loading 10 times a second and my computer keeps clicking and clicking as if I was repeatedly clicking on a link. The function ChangeChild is as such:
function ChangeChild(txt)
{
document.getElementById("child").src = txt;
document.getElementById("child").height = (window.screen.availHeight * .7);
}
Does anyone see what might be wrong with my code? I am using Internet Explorer 6.0.
|
|
|
|
|
georgiek50 wrote:
document.getElementById("child").src = txt;
Changing the .src attribute value of any html tag produces additional loads, hence what you see.
What you want to do is unclear, but from what I see I suggest to avoid to call "child" the iframe tag itself.
In addition, changing the .height attribute dynamically can produce blinking and other unwanted scrolling effects. That's always best to let the browser decide itself the height of an html container.
|
|
|
|
|
Well, I guess I should have explained what I wanted to do in the first place. I have an inline frame which is supposed to change every time I push buttons on top of the page, simulating a tab control. Now the height of the frame I want it to change to accomodate the content of the different pages that load so the vertical scroll bar doesn't appear. It is no problem since I use onclick = "ChangeChild()"...but if the user reloads the page (from explorer with the refresh button) then the inline frame takes the value that was first given to it when the home page was loaded and the vertical scroll bar appears. I hope I haven't confused you. Do you have any suggestions for me/strategy to avoid this?
|
|
|
|
|
georgiek50 wrote:
but if the user reloads the page (from explorer with the refresh button) then the inline frame takes the value that was first given to it when the home page was loaded
Yes, isn't that what the Refresh button is for ?
A possible way to change the support of Refresh is to not provide a .src value at all.
|
|
|
|
|
Hi, having some touble with ADODB.command
Here's the ASP code snippet:
...
...
...
Set oCmd = Server.CreateObject("ADODB.Command")
With oCmd
.ActiveConnection = oConn
.CommandText = "sproc_AddUser"
.CommandType = adCmdStoredProc
.Parameters.Append .CreateParameter("@login", adChar, adParamInput, 15, Request.Form("txtLogin") )
.Parameters.Append .CreateParameter("@password", adChar, adParamInput, 15, Request.Form("txtPasswd") )
.Parameters.Append .CreateParameter("@first_name", adChar, adParamInput, 50, Request.Form("first_name") )
.Parameters.Append .CreateParameter("@cust_service_level", adInteger, adParamInput, 5, CInt(Request.Form("cust_service_level")) )
...
... a whole bunch of other parameters ...
...
If Request.Form("user_category")="0" Then
.Parameters.Append .CreateParameter("@bClientStatus", adInteger, adParamInput, 4, 1)
Else
.Parameters.Append .CreateParameter("@bClientStatus", adInteger, adParamInput, 4, 0) ****** LINE_1 *****
End If
.Parameters.Append .CreateParameter("@error_status", adInteger, adParamOutput, 4, 0) ***** LINE_2 *****
'Execute the stored procedure:
.Execute
End With
ERROR MESSAGE:
"Microsoft OLE DB Provider for SQL Server error '80040e14'
Formal parameter '@bClientStatus' was defined as OUTPUT but the actual parameter not declared OUTPUT.
/registration.asp, line 227"
QUESTION 1:
Objection!@@!! Can you see that "bClientStatus" was explicitly defined to be "adParamInput" in the code snippet above (LINE_1)? The funny thing is, if I remove LINE_2, the code executed with no error!??
QUESTION 2: How can you extract return value?
Thanks a bunch!
norm
|
|
|
|
|
In regards to ERROR MESSAGE:
"Microsoft OLE DB Provider for SQL Server error '80040e14' Formal parameter '@bClientStatus' was defined as OUTPUT but the actual parameter not declared OUTPUT. /registration.asp, line 227"
I forgot to mention that bClientStatus is defined as an INPUT parameter:
CREATE PROC dbo.sproc_AddUser
...
...
... a whole bunch of parameters...
...
...
@bClientStatus int=0, SEE, it's an INPUT!
@error_status int OUTPUT This is the only OUTPUT.
WITH RECOMPILE
AS
...
... body ...
...
norm
|
|
|
|
|
Hi, I have this simple script:
<%
'Send the password:
msg_recipient = "someone@someaplace.com"
msg_sender = "sender@anotherplace.com"
msg_subject = "Testing AA"
msg_body = "Testing AA"
Dim NewMailObj
Set NewMailObj = CreateObject("CDONTS.NewMail")
NewMailObj.To = msg_recipient
NewMailObj.From = msg_sender
NewMailObj.Subject = msg_subject
NewMailObj.Body = msg_body
NewMailObj.Send
Set NewMailObj = Nothing
%>
<% Response.write "Done" %>
"NO" error. But no mail has been sent out (I've checked the mailbox)... I am sure that I have SMTP on the Windows2000 box - I can find it in >"Computer Management" applet>"Services and Applications">"Services". I can find the mailroot folders and sub-folders. BUT I "canNOT" find it under IIS - as instructed: http://www.skybuilders.com/users/jesse/docs/howToSMTP.html
As far as I know ASPEmail need SMTP service also isnt that right?
The above script executed with no error - so that leaves me with one possibility - SMTP wasn't properly configured?? Thanks.
norm
norm
|
|
|
|
|
Hi norm,
The asp page having the mailobject covers only 50% of the mail sending problem. The other 50% consitutes how the webserver (IIS) deals with the mail request that is being submitted.
(*)Make sure you have the SMTP Server Configured Properly. You need to have proper DNS settings if you want your IIS SMTP (Microsoft SMTP Service) itself to deliver mails to the hosts. Or you can configure the SmartHost to which your Microsoft SMTP Service will handover mails and take rest.
If you do have SMTP configuration in your IIS, it might have not been installed while installing the same. Are you using Windows 2000/XP. In that case, you would find SMTP in Windows Components (Internet Information Services Setup).
If you want a FREE SMTP Server itself, try http://www.jana-server.com/, which comes for free. But then, you can not use CDONTS, since I am afraid, we might not be able to configure CDONTS to use a specific mail server. Is'nt it? You then need to use a third party mailing component like Persits ASP Email, available for free from http://www.persits.com/
Deepak Kumar Vasudevan
http://deepak.portland.co.uk/
|
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
