How to replace variable by using IN operator?
880104Aug 3 2011 — edited Aug 4 2011Hi,
I'm creating a Forms where the user selects in the checkbox which products he wants to see. After the choice I should show all sales of that product, but the select doesn't recognize the variable after the IN operator, by example:
SELECT product, price, quantity
FROM sales
WHERE product IN (vcProducts);
Can anyone help me?
Cris