This is the output:
CALL sp_test(1111111111111111);
And for this its:
CALL sp_test('1111111111111111')
> mysqlpp::Query query2 = con->query();
> query2 << "CALL sp_test(%0:xxx)";
> query2.parse();
> query2.def["xxx"] = "'1111111111111111'";
> TRACE_SQL(query2.preview());
> query2.execute();
But the sql commandline works:
mysql> CALL sp_test(1111111111111111);
Query OK, 0 rows affected (0.00 sec)
mysql> CALL sp_test('1111111111111111');
Query OK, 0 rows affected (0.01 sec)
-----Original Message-----
From: Warren Young [mailto:mysqlpp@stripped]
Sent: Tuesday, March 06, 2007 6:03 PM
To: MySQL++ Mailing List
Subject: Re: Mysqlpp 2.2.1 template problem
Urscheler, Roger (COM Chantry CA) wrote:
>
> Does not work:
> mysqlpp::Query query2 = con->query();
> query2 << "CALL sp_test(%0:xxx)";
> query2.parse();
> query2.def["xxx"] = "1111111111111111";
> TRACE_SQL(query2.preview());
> query2.execute();
What do you get in your TRACE_SQL log for this case? Knowing what exactly
was built vs. what was supposed to be built will help.
--
MySQL++ Mailing List
For list archives: http://lists.mysql.com/plusplus
To unsubscribe:
http://lists.mysql.com/plusplus?unsub=1
