[thelist] Update Quantity in Shopping Cart

Darren Darren at imart.co.uk
Sat Apr 7 06:22:49 CDT 2001


5:18:09 PM, Friday, April 06, 2001, Michele <michele at wordpro.on.ca> wrote:

'Ello....

MF>       BuildSQL = "SET Quantity = " & varQuantity & " WHERE OrderDetailID = "
MF> & varOrderDetailID & ""
MF>       SqlString = "UPDATE ItemsOrdered " & BuildSQL & ""

why are you concatenating an empty string on the end??  you should be
able to lose the '& ""' bit at the end of the lines.

you want to do a:
    response.write SqlString

here to make sure that both your parameters have been inserted
correctly (basically what the error is saying).

hth,

darren

-- 
http://www.imart.co.uk






More information about the thelist mailing list