|
I need to update a database table with the time the user logs out of my site/when their session ends.
I've been using a global.asa file with the following Session_OnEnd code, but it doesnt seem to be working for me........ can anybody help?
Sub Session_OnEnd
set conn = Server.CreateObject("ADODB.Connection")
conn.Open "DSN=....."
query = "UPDATE User_LogTime SET Logout_Time = "now()" WHERE SID="&Session.SessionID&"
conn.Execute(query)
conn.Close
set conn = Nothing
End Sub
|
|
|
|
|
I suspect that you need to create a command object to do this..
"Your village called -
They're missing their idiot."
|
|
|
|
|
Thanks Roger but I'm new to this whole .asa thing. Could you explain what you mean ???
Thanks
|
|
|
|
|
An ADO Command object returns a recordset when you call its Execute method. Since you're new at this (as I am) I suppose you could use some resources. One of my favorites is W3Schools.com[^], where you'll find free tutorials on just about anything web related.
Reviewing the code, it may not be the best answer to use a Command for this; your approach, while new to me, looks like it should work fine. You may have to reformat the result of Now() though. What database are you using?
"Your village called -
They're missing their idiot."
|
|
|
|
|
Hi, I am pretty new to this too. But are actually doing the same as you do (maybe), but in C#. Sorry I don't get this to work either.
What I have explored, is that.. the sesion-variables seems to be cleared _before_ the end-session-event is ran...Anybody correct me is this is wrong.
What I did to solve the problem were making a object that I put into the session-variables and that writes info to the database when it terminates. This seems to work at me.
One last thing. It may take 20 minutes before the session ends, depending on the timeout configurations. Default is that 20 minutes. So session-end seems not to be executed right after quitting the browser..
= = = = = = = = = = = = =
Kim Amunsen
Norwegean University of Technology & Science
Major: Artificial Intelligence
|
|
|
|
|
Well, i wrote a parser for my logs in apache, and this error has occured over 3000 times in the past 2 weeks:
No directory () for Hostname www.thekeegster.com
does anyone know what this means? I've been googling, but i haven't found anything. Its clogging up my errorlog, its amazing how many occurences there are of it.
I'm runnin apache 1.3 on Linux
*.*
cin >> knowledge;
|
|
|
|
|
Is there possible to make a compiled .exe to be executed when a user enter my webpage.
Of course it is possible, but what is the best way?
I know about ActiveX but don’t want to recode my dialogproject to such a component.
I’ve read a little about making CAB files but don’t know where to start.
APe
|
|
|
|
|
Why do you want to do this? Just curious.
As for the how. If you are not willing to use ActiveX then you have to first get the EXE downloaded to the clients machine. After that, you cannot activate it yourself, you have to isntruct the user to do so themselves (this is for obvious security reasons e.g. format c: /s).
regards,
Paul Watson
Bluegrass
South Africa
Brian Welsch wrote:
"blah blah blah, maybe a potato?" while translating my Afrikaans.
Crikey! ain't life grand?
Einstein says...
|
|
|
|
|
For your curious.... 
I'm developing a program that my clients need to see, (during my "development process"). Until now I've send the .exe and yeah it work but it would bee easier for him/them to just tape in my www-url in a browser and get the last version I've published.
I've thought about creating an ActiveX that calls my exe with for e.g. ShellExecute(...)..... ???
He sure will trust my ActiveX in his browser. 
The problen is to (inside my ActiveX) upload my exe to the client and make it run......
Realy thanks for your comments
.....and justice for all
APe
|
|
|
|
|
ahh ok, you should look into the technologies which Microsoft and others have provided for automatic updating of apps. e.g. In MSN Messenger it polls a website to see if there are any EXE updates, if there is then it alerts you, downloads the update and installs it.
I *think* the MS tech is called BITS.
regards,
Paul Watson
Bluegrass
South Africa
Brian Welsch wrote:
"blah blah blah, maybe a potato?" while translating my Afrikaans.
Crikey! ain't life grand?
Einstein says...
|
|
|
|
|
Paul Watson wrote:
I *think* the MS tech is called BITS.
Good thinking! And here's the instructions[^] for implementing it. It only works on XP, and requires VS.Net to develop custom apps using it, but it's freely available.
"Another day done - All targets met; all systems fully operational; all customers satisfied; all staff keen and well motivated; all pigs fed and ready to fly" - Jennie A.
|
|
|
|
|
I have a very small question (a very big question for me though) about Server Side VBScript in ASP pages.
To fetch information from a HTML input textfield like the
( in a VBScript line, will return the error "Object required" (which clearly indicates my existing limitations in VBScript).
What is the VBScript syntax for this?
(there are tons of good java examples out there, but with VBScript...) 
Best regards,
Emelian
|
|
|
|
|
Given a form:
<FORM NAME=Form1 ACTION="MyScript.asp" METHOD="POST">
<INPUT NAME=Test TYPE="TEXT">
<INPUT TYPE="SUBMIT" Value="Submit">
</FORM>
to retrieve the value typed into the textbox after pressing the Submit button use
<%
strTestInfo = Request.Form("Test")
%>
in the page named MyScript.asp.
[EDIT]
An excellent book, "Beginning Active Server Pages 3.0" from Wrox Press is still available, though Wrox went belly up before I could purchase its Advanced volume. It presents the subject very clearly and uses VBScript throughout - it's been an invaluable aid to me.
[/EDIT]
"Your village called - <BR>They're missing their idiot."
|
|
|
|
|
Thanks for your help, Roger!
I read some time ago about the "Request.Form(), but I'll guess the beers I had between now and then, probably wiped it all out from my mind. 
Your suggestion doesn't work for me, because I'm using the "onClick" to call a small script before posting to the next page. I need to read the "Value" from the very same page that it is entered on. 
.
.
.
.
In a page, it is possible to have several forms which actually can contain the same names of the "
|
|
|
|
|
I realised that using Request.Form(), will only fetch data from a post on a previous page (and from that particular posted form). That sorts out the later part in my last reply.
And about fetching values in "input text fields" on the current page by using serverside scripts, probably is a question of travelling between two parallel universes (server-side & client-side).
But the question remains... Is it possible to make the server-side script able to fetch values on an existing page before executing a post to the next page? 
Regards,
Emelian
|
|
|
|
|
Emelian wrote:
Is it possible to make the serverside script to fetch values on an existing page before executing a post to the next page?
Probably, but I haven't had a need for it yet. Stick around - someone smarter than me is bound to show up.
"Your village called -
They're missing their idiot."
|
|
|
|
|
Solved the problem by forcing the page to post the data into same page, when I press the "Submit" -button. But not a very nice way to solve a simple data handling, is it? 
But the challange is still on, to find a solution that does it without making a "post". 
Any suggestion or contribution is most welcome!
Regards,
Emelian 
BTW... Thanks Roger, for spending your time and effort on this! ![Rose | [Rose]](https://codeproject.global.ssl.fastly.net/script/Forums/Images/rose.gif)
|
|
|
|
|
Create a file from inside ASP page ?
My current code
Dim fso
Dim streamfile
Set fso = Server.CreateObject("Scripting.FileSystemObject")
Set streamfile = fso.CreateTextFile("blahblah.asp",True)
But there is no file created at all..
Anyone can help ?
"Courage choose who will follow, Fate choose who will lead" - Lord Gunner, Septerra Core
"Press any key to continue, where's the ANY key ?" - Homer Simpsons
Drinking gives me amazing powers of insight. I can solve all the worlds problems when drunk, but can never remember the solutions in the morning. - Michael P Butler to Paul Watson on 12/08/03
|
|
|
|
|
When you specify the file to create you have to specify the full path, otherwise the default directory will be used, which is probably in some temp directory somewhere. Do it like this:
Set streamfile = fso.CreateTextFile(server.mappath("blahblah.asp"),True)
NATHAN RIDLEY
Web Application Developer
email: nathan @ netlab.com.au
[remove the spaces before and after the @ symbol]
|
|
|
|
|
Yes.. that's what I forget, Server.MapPath
Many thanks
"Courage choose who will follow, Fate choose who will lead" - Lord Gunner, Septerra Core
"Press any key to continue, where's the ANY key ?" - Homer Simpsons
Drinking gives me amazing powers of insight. I can solve all the worlds problems when drunk, but can never remember the solutions in the morning. - Michael P Butler to Paul Watson on 12/08/03
|
|
|
|
|
I have seen websites where all the pages have the suffix
.asp and I have seen websites where all the pages have
the suffix .htm. Is there a difference between the two
files?
What really bothers me is I have a site where everything
is .asp and when I send this robot to crawl the site and
find all links, it only finds the first page. I want
google and other search engines to crawl all the pages
(and subpages of the site) and the .asp suffix seems to
hinder it.
Am I just imagining this or is something really different
between those suffixes?
Please, any response any one can give me will be greatly
appreciated.
Sincerely,
Danielle (an overworked graduate student)
|
|
|
|
|
The suffix is a clue as to what inline scripting language the site uses (e.g. .asp, .php, .shtml, etc.), but is by no means definitive (the web server can be configured map any suffix to any handler). .htm is usually just plain HTML, but on a platform with historical roots to three-character file extensions (e.g., Windows).
I doubt the .asp extension is hindering the web crawler, unless it is poorly designed. However, there are lots of reasons why a web crawler for a search engine (such as Google) may not completely cover your site. Are all of your internal links of the form "blah.asp?something"? If so, the crawler is probably avoiding following the link since it suggests that the link is dynamic and the bot designers don't want the bot to waste server resources by triggerring a potentially intensive query. Also, a robots.txt file may be instructing the bot to specifically ignore certain sections.
- Mike
|
|
|
|
|
the extension tells the server what type of processing it must do to the file before it sends it to your browser. HTML and HTM files require no server-side processing and are simply sent as-they-are to your browser. ASP files use the VBScript or JScript server-side scripting language, and the server will look through these files for any script code and process it first before sending the resultant HTML to your browser. PHP files are the same idea, but use a different language.
Search engines are not a straight-forward technology. There are entire business devoted to optimising people's sites to please the search engines. What have you used to build the site? Search engines can't navigate flash files in general, and if you use a cryptic method to link to your subpages they may also have trouble. Do you use frames? These can cause problems also. What's the URL of your website? If we can have a look, you might get some better help.
NATHAN RIDLEY
Web Application Developer
email: nathan @ netlab.com.au
[remove the spaces before and after the @ symbol]
|
|
|
|
|
Hi there!
I'm most certain this topic has been discussed previously hundreds of times, yet I have a little problem with this which probably deserves a new thread:
I built a few days ago a regular expression email verification (actually copy-pasted it from some place I can't remember now :-P) to be used to filter email input in a web-page I'm working on.
Yesterday my boss called very angry because one of his clients wasn't able to enter his email. Obviously the client's email was a valid one and my function was rejecting it, so I have to correcti it. The problem was my regexp wasn't allowing the address to start with a digit (doh!):
^[a-zA-Z][\w\.-]*[a-zA-Z0-9]@[a-zA-Z0-9][\w\.-]*[a-zA-Z0-9]\.[a-zA-Z][a-zA-Z\.]*[a-zA-Z]$
Ok, solving this is most easy, but my boss was so damn angry, he told me to be absolutely sure all valid email addresses will be accepted when I fix it... so I made my homework... I ran into RFC2821 and RFC821 to check out SMTP rules, and found something weird:
According to RFC821 (http://www.faqs.org/rfcs/rfc821.html), the syntax for the email address is as follows (check the original RFC821 for a complete explanation, I'm filtering out a lot of stuff here):
<mailbox> ::= <local-part> "@" <domain>
<local-part> ::= <dot-string> | <quoted-string>
<dot-string> ::= <string> | <string> "." <dot-string>
<string> ::= <char> | <char> <string>
<char> ::= <c> | "\" <x>
<c> ::= any one of the 128 ASCII characters, but not any <special> or <SP>
<x> ::= any one of the 128 ASCII characters (no exceptions)
<SP> ::= the space character (ASCII code 32)
<special> ::= "<" | ">" | "(" | ")" | "[" | "]" | "\" | "." | "," | ";" | ":" | "@" """ | the control characters (ASCII codes 0 through 31 inclusive and 127)
The logic to understand the previous is rather simple: <mailbox> is composed of <local-part> AND "@" AND <domain>. Then <local-part> is composed of <dot-string> OR <quoted-string>, and so on. I left <quoted-string> and <domain> out of this because the quoted-string is a more complex notation for the same thing, and domain suffers of the same problem I'll explain now:
If you check the ASCII table, and filter out the INVALID characters according to the previous rules (not taking in count that quoting a char with backslash -i.e. \% - allows to enter ANY character), the valid set of characters for an email address is (values in parenthesis are ASCII codes):
letters: a - z AND A - Z
digits : 0 - 9
extras : ! (33), # (35), $ (36), % (37), & (38), ' (39), * (42), + (43), - (45), / (47), = (61), ? (63), \ (92), ^ (94), _ (95), { (123), | (124), } (125), ~ (126)
Now let's review this: letters, no problem... digits, no problem... but hey!!... what happened with the extra symbols?? I'm not complaining about 45, 95 (which are very common in email addresses) but the remaining are ALSO VALID?? Could this be possible?
Now, I can build a regexp to accept all this "extra" symbols, but my question here is ARE THEY ACTUALLY VALID? most of all ARE THEY VALID ANYWHERE IN THE SYNTAX?
I hope someone has the patience to read all this and give any comments about this.
Bundy
|
|
|
|
|
I think yes, they are allowed. Just as a sample, Lotus Notes often generates e-mails using:
! (33), # (35), $ (36), % (37), & (38), / (47)
Although I never saw the others, what's the problem with this? If it's allowed by the RFC, then it should be only a matter of using them on your regex.
BTW, do you know about RegexLib.com? You have a good probability of finding the regex you need there.
Trying to make bits uncopyable is like trying to make water not wet.
-- Bruce Schneier
By the way, dog_spawn isn't a nickname - it is my name with an underscore instead of a space. -- dog_spawn
|
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
