Hello,
I had checked that code(code the # sign) but did not got the correction on that
code display the quary error with line number.
In MSDN Library discuss that code use for constant values and save in date
format from constant value.
Engraze.
Dan Powderhill <[EMAIL PROTECTED]> wrote:
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 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
" on the web.
* To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
subscribe>
* Your use of Yahoo! Groups is subject to the Yahoo! Terms of
Service .
________________________________
[Non-text portions of this message have been removed]
________________________________
YAHOO! GROUPS LINKS
* Visit your group "AspClassicAnyQuestionIsOk
" on the web.
* To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
subscribe>
* Your use of Yahoo! Groups is subject to the Yahoo! Terms of
Service .
________________________________
[Non-text portions of this message have been removed]
Yahoo! Groups Links
---------------------------------
Do you Yahoo!?
Read only the mail you want - Yahoo! Mail SpamGuard.
[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/
