Re: I want to add up in a select Statement

2002-08-17 Thread Chris Knipe
> sqlst = "update sfproducts set projectdonations = projectdonations + > &testvalue WHERE prodID = '" & sProdID & "'" ^^ $sqlst = "update sfproducts set projectdonations = projectdomains + " . $testvalue . "WHERE prodID = '" . $sProdID . "'"; $sqlstr then looks like this: update sfproducts

I want to add up in a select Statement

2002-08-17 Thread John Berman
Hi If I do this and projectdonations is say 5 sqlst = "update sfproducts set projectdonations = projectdonations + 1 WHERE prodID = '" & sProdID & "'" projectdonations then = 6 - great however the number I want to add is in a variable called test value and if I do this and say testvalue is 6