Re: Mysql++ && printf

On Sun, Apr 10, 2005 at 07:47:52PM -0700, timothy johnson wrote:
> What about using vars in the query line?
> 
> query << "SELECT * FROM table WHERE id=" . var;
> this way didnt work
> 
> sprintf(query. "SELECT * FROM table WHERE id=%i". var);
> nor did this way work.

This is C++, not PHP or perl.

query << "SELECT * FROM table WHERE id=" << var;

If you're building SQL from scratch, make sure you quote properly as well.
Going from memory, I think you use the quote manipulator like this,
but I could be wrong, I don't use it regularly:

query << "SELECT * FROM table WHERE id=" << quote << var;

- Chris


-- 
MySQL++ Mailing List
For list archives: http://lists.mysql.com/plusplus
To unsubscribe:    
http://lists.mysql.com/plusplus?unsub=gcdmc-plusplus@xxxxxxxxxxx