To: AspClassicAnyQuestionIsOk@yahoogroups.com
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
: AspClassicAnyQuestionIsOk@yahoogroups.com
[mailto:[EMAIL PROTECTED] On
Behalf Of Dan
Powderhill
Sent: 11 July 2005 09:08
To: AspClassicAnyQuestionIsOk@yahoogroups.com
Subject: RE: [AspClassicAnyQuestionIsOk] Date save in MS Access through
ASP Code.
Couple of things here. First
:16
To: AspClassicAnyQuestionIsOk@yahoogroups.com
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
Of ENGRAZE
Sent: 09 July 2005 12:16
To: AspClassicAnyQuestionIsOk@yahoogroups.com
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
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
Engraze,
Check the format of date in the table.It should be shortdate format bcos,
value of date will return in mm/dd/yy format.
If it isnot working u send me the complete error message u have
received, o that I can get where u might have gone wrong.
All the Best
--
Balaji V
Yahoo!
I have trouble saving the date in MS Access (field is short date), through asp
code, but got the always the error message in different ways.
My code is
% Dim AHConn, AHrst, SQLQ
Dim vDate, vTime
vDate = date
vTime = time
vDate = cstr(FormatDateTime(date, vbshortDate))
set AHConn =
Engraze,
What are the errors u r encountering??
After seeing the error I can help u out.
--
Balaji V
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