ADO - SELECT statment

[antonaras]

Hi buddies i have a relativly simple question i whant to exececute a select statment in c++ but for the WHERE part of the statment i want to read it from a variable of type string Let me be more precise. string token; token="SomeName" pCommand->CommandText = "SELECT * FROM Table1 WHERE Name=?";//WHERE Name=token Any ideas pls help Thanks again

[sathish s]

Like this pCommand->CommandText = "SELECT * FROM Table1 WHERE Name='" & token & "'" ;//WHERE Name=token

[sathish s]

string strsql; sprintf(strsql, "SELECT * FROM Table1 WHERE Name='%s'", token); pCommand->CommandText =strsql;