Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2003
    Posts
    1

    Unanswered: error on update sql for asp. please help.

    sqlString = "UPDATE assessor SET " &_
    "assessorName='" & fixQuotes( fname ) & "', " &_
    "email='" & fixQuotes( email ) & "', " &_
    "role='" & fixQuotes( role ) & "', " &_
    "password='" & fixQuotes( password ) & "' " &_
    "WHERE userid=" &session("assessorUserid")

    above is query it shows this error.

    Error Type:
    Microsoft OLE DB Provider for ODBC Drivers (0x80040E10)
    [Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1.
    /hope/form/updateassessorform2.asp, line 133

  2. #2
    Join Date
    Jan 2003
    Location
    Midwest
    Posts
    138
    do a response.write on your sql string and see what parameters are being passed into it.

Posting Permissions

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