Got the quotes around the wrong way (not enough coffee yet ;-) ).
This'll work though :-
SQLQ = "INSERT INTO sug (name, class, type, sug, dt) VALUES ('" _
& Request.QueryString("Name") & "','" _
& Request.QueryString("Class") & "','" _
& Request.QueryString("RSug") & "','" _
& Request.QueryString("SugComment") & "', " _
& "#" & date & "#" & _
")"
Dan
________________________________
From: [email protected]
[mailto:[EMAIL PROTECTED] On Behalf Of Dan
Powderhill
Sent: 11 July 2005 09:08
To: [email protected]
Subject: RE: [AspClassicAnyQuestionIsOk] Date save in MS Access through
ASP Code.
Couple of things here. First of all, turn off friendly error messages in
internet explorer so that you get the actual error message. Secondly,
you need to delimit your date with hashes (#) like so:-
SQLQ = "INSERT INTO sug (name, class, type, sug, dt) VALUES ('" _
& Request.QueryString("Name") & "','" _
& Request.QueryString("Class") & "','" _
& Request.QueryString("RSug") & "','" _
& Request.QueryString("SugComment") & _
& "#" & date & "#" & _
"')"
Dan
________________________________
From: [email protected]
[mailto:[EMAIL PROTECTED] On Behalf Of ENGRAZE
Sent: 09 July 2005 12:16
To: [email protected]
Subject: Re: [AspClassicAnyQuestionIsOk] Date save in MS Access through
ASP Code.
Hello,
Errors on Page with this code
SQLQ = "INSERT INTO sug (name, class, type, sug, dt) VALUES ('" _
& Request.QueryString("Name") & "','" _
& Request.QueryString("Class") & "','" _
& Request.QueryString("RSug") & "','" _
& Request.QueryString("SugComment") & _
& date & _
"')"
HTTP 500 - Internal server error
Internet Explorer
But without date work normal and save all data normal in MS Access.
SQLQ = "INSERT INTO sug (name, class, type, sug) VALUES ('" _
& Request.QueryString("Name") & "','" _
& Request.QueryString("Class") & "','" _
& Request.QueryString("RSug") & "','" _
& Request.QueryString("SugComment") & _
"')"
Balaji vishnubhotla <[EMAIL PROTECTED]> wrote:
Engraze,
What are the errors u r encountering??
After seeing the error I can help u out.
--
Balaji V
Yahoo! Groups Links
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
[Non-text portions of this message have been removed]
________________________________
YAHOO! GROUPS LINKS
* Visit your group "AspClassicAnyQuestionIsOk
<http://groups.yahoo.com/group/AspClassicAnyQuestionIsOk> " on the web.
* To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<mailto:[EMAIL PROTECTED]
subscribe>
* Your use of Yahoo! Groups is subject to the Yahoo! Terms of
Service <http://docs.yahoo.com/info/terms/> .
________________________________
[Non-text portions of this message have been removed]
________________________________
YAHOO! GROUPS LINKS
* Visit your group "AspClassicAnyQuestionIsOk
<http://groups.yahoo.com/group/AspClassicAnyQuestionIsOk> " on the web.
* To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<mailto:[EMAIL PROTECTED]
subscribe>
* Your use of Yahoo! Groups is subject to the Yahoo! Terms of
Service <http://docs.yahoo.com/info/terms/> .
________________________________
[Non-text portions of this message have been removed]
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/AspClassicAnyQuestionIsOk/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
