B
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
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