Recordset DTC SQL Statement

[slink9]

I have set up a Recordset DTC in VI6. I have passed a variable from one web page to this one and would like to use that variable in the SQL statement. I can not figure out how to tell it to see the variable within the SQL editor window. I have defined another variable and converted it to the CINT of the first and that is not helpful. Below see the code that I put into the SQL Statement window.

select Orders.OrderID, Customers.CompanyName, Orders.ShippedDate from Orders, Customers where Orders.CustomerID = Customers.CustomerID and Orders.OrderID = 'OID2'

 

[newtoASP]

I don't use design time controls, but did you try to put a question mark in for the parameter ("...where order =?&quot and add the parameter to the parameters tab on the recordset DTC properties tab? There is a value field that you could enter request.form("orderID&quot.

 

[slink9]

Thanks. That was it.