Results 1 to 5 of 5
  1. #1
    Join Date
    Oct 2004
    Posts
    9

    Unanswered: MYSQL - update query works on Windows OS and not on MAC??

    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

  2. #2
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    could you please display the sql after it has been assembled by whatever programming language that is
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  3. #3
    Join Date
    Oct 2004
    Posts
    9

    query..

    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'

  4. #4
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    there's no error there
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  5. #5
    Join Date
    Oct 2004
    Posts
    9

    ???

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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •