SQL Insert date/time & acquired value in JavaScript

Question

I am trying to insert current date/time and a value that was redirected to this errorpage into an access database. So far the only issue is coming from when i add the redirected value into the insert statement. Here is my code.

errnum = Request.QueryString("errnum")
prevPageTitle = request.querystring("pagetitle")

Function AccessDateTime (dateandtime)
Dim myDay
Dim myMonth
Dim myYear

myDay = Day(dateandtime)
If Len(myDay)=1 Then myDay="0" & myDay

myMonth = Month(dateandtime)
If Len(myMonth)=1 Then myMonth="0" & myMonth

myYear = Year(dateandtime)

AccessDateTime = myYear & "-" & myMonth & "-" & myDay & " " & Time()
End Function

Dim connection
Dim SQL, sConnString

SQL="INSERT INTO ErrorTable (ErrorTime, ErrorPage) VALUES (#" & AccessDateTime(NOW()) & "#, #" & prevPageTitle & "#)"   
//////This is where the issue is, ErrorPage column isn't updated with prevPageTitle acquired information. 

(Error Type:
Microsoft JET Database Engine (0x80040E07)
Syntax error in date in query expression '#Pre-ErrorPage.asp#'.//////

sConnString="PROVIDER=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=" & Server.MapPath("ErrorTimeLog.mdb")
Set connection = Server.CreateObject("ADODB.Connection")
connection.Open(sConnString)
connection.execute(SQL)

Connection.Close
Set Connection = Nothing

Ryan Castillo · Accepted Answer · 2011-05-21 06:01:01Z

1

Just in case anyone needs an answer to a similar question. The issue was in the syntax of my SQL statement.

SQL="INSERT INTO ErrorTable (ErrorTime,ErrorPage,ErrorNumber) VALUES (#" & AccessDateTime(NOW()) & "#, '" & prevPageTitle & "', '" & errnum & "')"

Single quotes were needed around the acquired variables.

edited May 21, 2011 at 6:01

Ryan Castillo

1,12510 silver badges22 bronze badges

answered May 20, 2011 at 14:31

P424

134 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

SQL Insert date/time & acquired value in JavaScript

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related