Unanswered: MYSQL - update query works on Windows OS and not on MAC??
Can anyone help me with dis error....i'm getting dis error on MAC..and not Windows. its a update query which is getting executed on line 78.
sQuery = "Update Certificates Set "
z = 1
For Each Item In Request.form("QID")
sQuery = sQuery & "Q" & z & "=" & Item & ", "
z = z + 1
If Len(sQuery) > 25 Then
sQuery = Left(sQuery, Len(sQuery) - 2)
sQuery = sQuery & " Where Certificate = '" & Cert & "'"
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
[MySQL][ODBC 3.51 Driver][mysqld-4.0.12-nt]You have an error in your SQL
syntax. Check the manual that corresponds to your MySQL server version for
the right syntax to use near '' at line 1