Hi
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
Next
If Len(sQuery) > 25 Then
sQuery = Left(sQuery, Len(sQuery) - 2)
sQuery = sQuery & " Where Certificate = '" & Cert & "'"
End If
objConnEvalOther.Execute sQuery

err....

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

/standards/x_log_TC.asp, line 78

let me knw soon :-s
bye
ty

could you please display the sql after it has been assembled by whatever programming language that is

hie..
dis was da query ..

Update Certificates Set Q1=1012, Q2=1021, Q3=1077, Q4=1078, Q5=1079, Q6=1080, Q7=1115, Q8=1141, Q9=1145, Q10=1155, Q11=1721, Q12=1722, Q13=1727, Q14=6100, Q15=6101 Where Certificate = 'abc'

there's no error there

even i knw dat man..
but den y it has to give err...on mac...and not on windows