Results 1 to 2 of 2

Thread: Syntax Error

  1. #1
    Join Date
    Dec 2002
    Location
    KY
    Posts
    56

    Exclamation Unanswered: Syntax Error

    Microsoft OLE DB Provider for SQL Server error '80040e14'

    Line 1: Incorrect syntax near '789'.

    /boilers/Blr_inspector_process.asp, line 63


    This is the section that I have a problem with, but the line that's giving me the erroe has Badge_No in it:

    ' #### Update the HBC_Inspector record
    strSQL = strSQL & "UPDATE HBC_Inspector SET "
    strSQL = strSQL & "Contact_ID = " & Request.Form("contact_id") & ", "
    strSQL = strSQL & "Inspector_EmployerDef_ID = " & Request.Form("inspector_employerdef_id") & ", "
    strSQL = strSQL & "badge_no = '" & Replace(Request.Form("badge_no"), "'", "''")& "' "
    strSQL = strSQL & " Where ID = " & Request.Form("ID")
    ObjConn.Execute(strSQL)

  2. #2
    Join Date
    Feb 2003
    Posts
    18
    Check whether single quotes are added for the char type fields and not for int type fields.
    Error is for number 789. Check it is int or char type field.

Posting Permissions

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