Using a variable in a SQL statement
Posted on 2001-09-06
This should be quite easy.
I have a recordset with a SQL statement defining the data that I get. I am passing a variable from another web page and need to use it in the SQL statement.
The book I am working from has errors and the link to the fix is dead (and, of course, I can't talk to someone who has half an idea of what to do). How can I use a variable in this SQL statement?
select Orders.OrderID, Customers.CompanyName, Orders.ShippedDate from Orders, Customers where Orders.CustomerID = Customers.CustomerID and Orders.OrderID = OID
OID is the variable name!!