SQL error

Results 1 to 4 of 4

Thread: SQL error

  1. #1
    Join Date
    Dec 1969

    Default SQL error

    when i try to use my code below....i got this error <BR>"Microsoft VBScript runtime error &#039;800a01a8&#039; <BR><BR>Object required: &#039;SELECT * FROM produc&#039; <BR>" how do I solve it?<BR><BR>Dim rsProduct,sSQL3<BR>Set rsProduct = Server.CreateObject("ADODB.Recordset") <BR> For Each Item in Request.Cookies<BR> Set rsProduct = Server.CreateObject("ADODB.Recordset") <BR> sSQL3 = "SELECT * FROM product p WHERE p.pid=&#039;" & Item & "&#039;"<BR> rsProduct.open sSQL3, conn, adOpenStatic, adlockpessimistic, adcmdtext<BR> <BR> rsProduct("stock") = Cint(rsProduct("stock"))-Cint(Request(Item))<BR> rsProduct.update<BR> sSQL3.close<BR> next

  2. #2
    AA Guest

    Default RE: SQL error

    The result set of the following code is coming as null<BR>sSQL3 = "SELECT * FROM product p WHERE p.pid=&#039;" & Item & "&#039;"<BR>So use error handler to solve this problem..<BR><BR>

  3. #3
    Flureo Guest

    Default Update?

    how to update a field in a table?<BR>I am using the <BR><BR>conn.BeginTrans<BR>"code to update the table"<BR>conn.CommitTrans

  4. #4
    AA Guest

    Default RE: Update?

    U can the the code like this <BR><BR>sqlu=&#039;update sql <BR>conn.execute (sqlu) <BR>

Posting Permissions

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