------=_NextPart_000_0016_01C5C41A.BF276130
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: 7bit



I would like to use some of the built-in functions available with MySQL such
as NOW(). How do I call them when using MySQL++?



This is an example of what I am trying to do. Unfortunately it fails, what
am I doing wrong?



User row(0, Name, Address, Phone, NOW() );

Query query = con->query();

query.insert(row);

query.execute();







Craig Snyder

Chief Software Architect

<http://www.inclue.com>

inclue! ...the internet on your terms.




------=_NextPart_000_0016_01C5C41A.BF276130--

Craig Snyder wrote:
Currently, you have no choice but to create your own SQL statements.

An item for this exists on the Wishlist already. Patches thoughtfully
considered.

--
MySQL++ Mailing List
For list archives: http://lists.mysql.com/plusplus
To unsubscribe: http://lists.mysql.com/plusplus?unsu...ie.nctu.edu.tw

Craig,

I think you should try a different approach:
Query query;
query << "insert into users(name,address,phone,timestamp) values (%0q,
%1q, %2q, now() )";
query.parse();
query.store(Name, Address, Phone);

Regards,
Ovidiu

Craig Snyder wrote:


--
MySQL++ Mailing List
For list archives: http://lists.mysql.com/plusplus
To unsubscribe: http://lists.mysql.com/plusplus?unsu...ie.nctu.edu.tw