List:MySQL++« Previous MessageNext Message »
From:roberto previdi Date:July 16 2007 5:16pm
Subject:Re: Weird parsing of templated query
View as plain text  
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 
Thread
Weird parsing of templated querySteven Van Ingelgem14 Jul
  • Re: Weird parsing of templated queryAndrew Sayers14 Jul
  • Re: Weird parsing of templated queryWarren Young16 Jul
    • Re: Weird parsing of templated querySteven Van Ingelgem16 Jul
      • Re: Weird parsing of templated queryWarren Young16 Jul
        • Re: Weird parsing of templated querySteven Van Ingelgem16 Jul
          • Re: Weird parsing of templated queryWarren Young16 Jul
            • Re: Weird parsing of templated querySteven Van Ingelgem16 Jul
              • Re: Weird parsing of templated queryWarren Young16 Jul
                • Re: Weird parsing of templated querySteven Van Ingelgem16 Jul
Re: Weird parsing of templated queryroberto previdi16 Jul
  • Re: Weird parsing of templated queryWarren Young16 Jul
Re: Weird parsing of templated queryroberto previdi16 Jul