SQL string bug

Results 1 to 6 of 6

Thread: SQL string bug

  1. #1
    Kentium Guest

    Default SQL string bug

    I&#039;m getting an error near "="<BR><BR>strSQL = "UPDATE ufiles SET " & ColumnToEdit1 & "=&#039;" & FileName &"&#039; AND " & ColumnToEdit2 & "=&#039; AND " & fileTitle &"&#039;" & ColumnToEdit3 & "=&#039;" & catagory &"&#039; AND " & ColumnToEdit4 & "=&#039;" & whoupload &"&#039; WHERE record=" & docid &""<BR><BR>I&#039;m confused...anyone see what my damage is?<BR><BR>Thanks for the extra eyeballs.

  2. #2
    Join Date
    Dec 1969
    Posts
    1,431

    Default RE: SQL string bug

    ColumnToEdit2 & "=&#039; AND " & fileTitle &"&#039;" & ColumnToEdit3 <BR><BR>should be <BR>ColumnToEdit2 & "=&#039;" & fileTitle & "&#039; And " & ColumnToEdit3 <BR><BR>

  3. #3
    Kentium Guest

    Default RE: SQL string bug

    Ok..tried that, and now i get vbscript commented out<BR><BR>strSQL = "UPDATE ufiles SET " & ColumnToEdit1 & "=&#039;" & FileName &"&#039; AND " & ColumnToEdit2 & "=&#039;" & fileTitle & "&#039; & ColumnToEdit3 & "=&#039;" & catagory &"&#039; AND " & ColumnToEdit4 & "=&#039;" & whoupload &"&#039; WHERE record=" & docid &""<BR><BR>here-<BR><BR>&#039;" & catagory &"&#039; AND " & ColumnToEdit4 & "=&#039;" & whoupload &"&#039; WHERE record=" & docid &""

  4. #4
    Join Date
    Dec 1969
    Posts
    1,431

    Default RE: SQL string bug

    Do<BR><BR>strSQL = "UPDATE ufiles SET " & ColumnToEdit1 & "=&#039;" & FileName &"&#039; AND " & ColumnToEdit2 & "=&#039;" & fileTitle & "&#039; AND " & ColumnToEdit3 & "=&#039;" & catagory &"&#039; AND " & ColumnToEdit4 & "=&#039;" & whoupload &"&#039; WHERE record=" & docid


  5. #5
    Kentium Guest

    Default Thanks Krank! (eom)

    x

  6. #6
    Kentium Guest

    Default still buggy

    Gettin&#039; that syntax error near "=" again.<BR><BR>Ugh.

Posting Permissions

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