SQL server error

Results 1 to 2 of 2

Thread: SQL server error

  1. #1
    Join Date
    Dec 1969

    Default SQL server error

    I am trying to update a database table for a shopping cart application, some of the selections gets updated to the table perfectly, and for some selections I get a strange error like this!! Can any one tell what could be wrong?<BR><BR><BR>Microsoft OLE DB Provider for ODBC Drivers error &#039 80040e14&#039 <BR><BR>[Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax near &#039s&#039. <BR><BR>/EShop/AddBasket.asp, line 35 <BR><BR><BR>

  2. #2
    Join Date
    Dec 1969

    Default RE: SQL server error

    Add a line of code to output your SQL statement *right before* the rs.Open method (or whatever method you&#039re using).<BR><BR>Then, when you get the error again, post the SQL output to the board here, and we will be able to help. Right now, your query is too vague.<BR><BR>Perhaps it has to do with an apostrophe? Are you updating a text field with a user-inputed value that contains an apostrophe? If so, you need to fix that. See:<BR><BR>How to Deal with Apostrophes in your SQL String<BR>http://www.4guysfromrolla.com/webtech/051899-1.shtml<BR><BR>Happy Programming!

Posting Permissions

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