List:MySQL++« Previous MessageNext Message »
From:Roger (COM Chantry CA) Urscheler Date:March 6 2007 11:22pm
Subject:RE: Mysqlpp 2.2.1 template problem
View as plain text  
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
Thread
Mysqlpp 2.2.1 template problemCOM Chantry CA)6 Mar
RE: Mysqlpp 2.2.1 template problemJim Wallace6 Mar
RE: Mysqlpp 2.2.1 template problemCOM Chantry CA)6 Mar
  • Re: Mysqlpp 2.2.1 template problemWarren Young6 Mar
RE: Mysqlpp 2.2.1 template problemCOM Chantry CA)7 Mar
  • Re: Mysqlpp 2.2.1 template problemWarren Young7 Mar
RE: Mysqlpp 2.2.1 template problemCOM Chantry CA)9 Mar
  • Re: Mysqlpp 2.2.1 template problemWarren Young16 Mar
Re: Mysqlpp 2.2.1 template problemWarren Young17 Mar