and use code like:
http://ww.learnasp.com/learn/debug2.asp
which wil display all errors and SQL when things do not work out.
On 7/11/05, 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 <[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
>
>
> Visit your group "AspClassicAnyQuestionIsOk" on the web.
>
> To unsubscribe from this group, send an email to:
> [EMAIL PROTECTED]
>
> Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
>
> ________________________________
>
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/
