Using vbscript w/ MsAccess, I am trying to update a column that is a
numeric data type, where i have one sql statement in my script that
works perfectly:
''''''''
dim strSQL,rsPoll, SQLco,rsCo
strSQL="UPDATE FLO set answer1 = " & Request.Form("txtOption") & " + 1
WHERE ID = " & ID
SET rsPoll=adoCon.execute(strSQL)
''''''''
SQLco = "update FLO set auxx = " & request.Form("qco")) &" + 1 WHERE
ID=" & ID & ""
SET rsCo=adoCon.execute(SQLco)

both answer1 and auxx columns are number types, default value set at
0. The answer1 column gets its updated value no problem, but auxx ONLY
shows a zero (0) when the update statement runs, does NOT get its new
numeric value.

??
chumley

You are using two different recordset objects -- rsPoll and rsCo -- to
update the same table -- FLO. Try using the same recordset object --
the one which appears to work correctly -- rsPoll.

Additionally, if you are updating these fields on the same button click
- you should combine the updates

Update FLO Set Anser1 = " & ... & ", auxx = " & ... " Where ID = " & ID

Lastly, you end one statement like this: Where ID = " & ID

and the sencond statement like this: Where ID = " & ID & ""

You should end it like the first statement as I am guessing ID is an int
field and does not require delimiting.

Rich

*** Sent via Developersdex http://www.developersdex.com ***