ok i'm sorry, i supposed the bug was only in the def object. Anyway i solved the problem
like this:
mysqlpp::Query q(TheDb::Instance().getConnection());
q <<"select * from `Mob` where %0:dummy and objectId= %1:objectId ;";
q.parse();
q.def["dummy"]=1;
q.def["objectId"]=3;
mysqlpp::SQLQueryParms parms(&q);
parms["dummy"]=1;
parms["objectId"]=4;
mysqlpp::Result result;
cout << q.preview()<<endl;
result = q.store(parms);
cout << result.at(0)["objectId"];
output:
select * from `Mob` where 1 and objectId= 3 ;
4
yeah, it works!!!
I love you!
I will just keep care to remove the "where %0:dummy " when there are no fields to put in
the where condition.
roby
----- Original Message ----
From: Warren Young <mysqlpp@stripped>
To: MySQL++ Mailing List <plusplus@stripped>
Sent: Monday, July 16, 2007 6:49:50 PM
Subject: Re: Weird parsing of templated query
roberto previdi wrote:
> q <<"select * from `Mob` where objectId=%0:objectId";
Single parameter queries don't work right with the SQLQueryParms
mechanism. This has been discussed again and again and again and again
on this list, and it's even documented. You can use the %1 workaround,
or the Query streams interface.
--
MySQL++ Mailing List
For list archives: http://lists.mysql.com/plusplus
To unsubscribe: http://lists.mysql.com/plusplus?unsub=1
____________________________________________________________________________________
Building a website is a piece of cake. Yahoo! Small Business gives you all the tools to
get online.
http://smallbusiness.yahoo.com/webhosting
