final = tocnt - a



Next time, please post the error message and code you are receiving.



Cheers

Ken



~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

From: "Handy" <handymulia@h...>

Subject: [asp_databases] simple SQL query ...





: Hi guys, I need help with this

:

: Set temprec=conn.execute("SELECT stock FROM Product where name = 'asd' ")

:     totcnt = temprec("stock")       'no syntax error here'

:          a = CInt(qty)              'no syntax error here'

:     final = "&  totcnt - a  &"      'no syntax error here'

:

:

:

: conn.Execute("Update Product Set stock = "&final&"' where name = 'asd' ")

:

: The program needs to do substraction  -->  totcnt - a

: and I have checked that there is no syntax error until before the

: execution of SQL query.

:

: The error is here  ==>  Set stock = "& final &"



~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

Too many single quotes..

conn.Execute("Update Product Set stock =3D " & final & " where name =3D

'asd' ")



-----Original Message-----

From: Handy [mailto:handymulia@h...]

Sent: Friday, March 08, 2002 1:46 AM

To: ASP Databases

Subject: [asp_databases] simple SQL query ...





Hi guys, I need help with this :





Set temprec=3Dconn.execute("SELECT stock FROM Product where name =3D 

'asd'

")

    totcnt =3D temprec("stock")       'no syntax error here'

         a =3D CInt(qty)              'no syntax error here'

    final =3D "&  totcnt - a  &"      'no syntax error here'



           



conn.Execute("Update Product Set stock =3D "&final&"' where name =3D 

'asd'

")







The program needs to do substraction  -->  totcnt - a

and I have checked that there is no syntax error until before the

execution of SQL query.



The error is here  =3D=3D>  Set stock =3D "& final &"





Does anybody know how to solve it ?





Thanks alot !






$subst('Email.Unsub').

Hi guys, I need help with this :





Set temprec=conn.execute("SELECT stock FROM Product where name = 'asd' ") 

    totcnt = temprec("stock")       'no syntax error here'

         a = CInt(qty)              'no syntax error here'

    final = "&  totcnt - a  &"      'no syntax error here'



            



conn.Execute("Update Product Set stock = "&final&"' where name = 'asd' ")







The program needs to do substraction  -->  totcnt - a

and I have checked that there is no syntax error until before the 

execution of SQL query.



The error is here  ==>  Set stock = "& final &"





Does anybody know how to solve it ?





Thanks alot !