I'd like to access a row in a table. The primary key column is named
"id". I'd like to use a query which passes the specific id as a
variable. It appears that I can do this:
int iID = 1000;
query << "SELECT * FROM table WHERE id = " << iID;
By executing this query could I get the row corresponding to id = 1000?
Can anyone point me to where I can find information about how I would
pass other types of variables - such as a double, string or a date
etc. Didn't find anything in the examples or in the manual.