michael
|
| Posted: 02/18/2002, 1:32 AM |
|
I try to calculate a total base on shoppingcart example, however I keep getting error. Here is my SQL statement. Could anyone tell the problem?
In Form property --> SQL I entered,
select sum(qtys*up) as total1 from ifq_detail where ifq_id="& GetParam("ifq_id")& "
I get the error message is:
Invalid SQL Query. Error:[TCX][MyODBC]you have an error in your SQL syntax near "ifq_id")&" at line 1
|
|
|
 |
Henry Miller
|
| Posted: 02/18/2002, 5:40 AM |
|
May be ifq_id is a string and you should surround it with quotes
|
|
|
|
|
