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 = server.CreateObject ("ADODB.Connection")
set AHrst = server.CreateObject("ADODB.RecordSet")
AHConn.open "Provider=Microsoft.Jet.OLEDB.4.0;" _
& "Data Source=C:\Inetpub\wwwroot\DataBase\ah.mdb;" _
& "Mode=ReadWrite;" _
& "Persist Security Info=False"
SQLQ = "INSERT INTO sug (name, class, type, sug, dt) VALUES ('" _
& Request.QueryString("Name") & "','" _
& Request.QueryString("Class") & "','" _
& Request.QueryString("RSug") & "','" _
& Request.QueryString("SugComment") & _
& vDate & _
"')"
set AHrst = AHConn.Execute(cstr(SQLQ)) 'AHrst.close
set AHrst = nothing %>
I want execute that code on tntranet and get the users comments. also guide to
me how can i can save the user computer name and ip address but client side. I
know all servervariables.
Please any one guide to me what can i correct this code and save the
information.
Engraze.
---------------------------------
Do you Yahoo!?
Make Yahoo! your home page
[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/
