conditional sql statements

[Bill]

I have a shopping cart that I want to load items in that come from a
huge scrolling form. In other words, when someone clicks on a category
in our site, it scrolls out all the items in that category, maybe 30
or more. I have text boxes next to each item so somone can enter a
number, then press submit form button at the bottom of the form, and
send those slections to the shopping cart.

The problem is, many of the text boxes are empty, yet they are still
being sent to the shopping cart as a quatity of 0. Is there a way for
sql to ignore a value if the variable is zero, or only get the sql
statement to run if a variable is > 0?

Thanks,

Bill

 

[Ray at]

Post your code. [empty] <> 0 unless you cint() it, or unless in your DB,
you have a default value of 0. I don't know how your building your query,
but it sounds like you may want to change it so that it only inserts values
for columns that values were sent for from your form.

Ray at work