Re: parameters problem

My code is something like this:
 (q is a mysqlpp::Query)

    for(IFieldContainer::const_iterator i = toSetFields.begin(); i != toSetFields.end(); i++)     {

        q.def[(*i).getName()]=(*i).getValue();     }

the query and the toSetFields vector are filled in this way (simplifying):

    q << "select * from " << theTable.getName() << " where 1 ";     int paramIndex=0;
    for(IFieldContainer::const_iterator i= allFields.begin(); i != allFields.end(); i++)     {

        if ((*i).hasValue())
        {
            q << " and " << (*i).getName() << "= %"<

    }


Passing a vector or a map to q.store() would be just the perfect solution in my opinion..


Roberto Previdi



  Original Message ----
roberto previdi wrote:

> I admit that i am one of the query.def abusers :)

Father Warren has heard your confession, and bids you go and say three 
Hail Linuses.  Go forth and sin no more, my child.

Do you need help?
In addition to our free technical library, Pantek provides professional IT services to companies who utilize Open Source software:
Learn more about Pantek's Technical Support offerings
Place an order for 24/7/365 Technical Support here
Learn more about Pantek, who we are, and what we do
Chat with a Live Operator
Related lists.mysql.com Links
announce
benchmarks
bugs
certification
cluster
commits
dotnet
gui-tools
internals
java
maxdb
myodbc
mysql
mysqldoc
packagers
perl
plusplus
replication
win32
Request more information about Pantek
> The problem is that my query is dynamically generated, 

Please post an example of the sort of thing you're generating.  I 
suspect you might have just picked up a hammer, and all problems are 
looking like nails to you right now.

> I would need something like
> putting all the (parameter,value) couples in a vector or some dynamic
> structure and pass it to the query object..

Would it be enough if one of the overloads for these query execution 
methods took a vector of string?  Or maybe a map of string to string?


Even if the answer is "yes", I'd still like to know how you're trying to 
use this feature.  I have a deep suspicion that any attempt to create 
dynamic templates is wrong-headed.  The whole idea of a "template" is 
that you have to know the parameters of the problem up front.

-- 
MySQL++ Mailing List
For list archives: 
http://lists.mysql.com/plusplus
To unsubscribe:    
http://lists.mysql.com/plusplus?unsub=hariseldon78@yahoo.it




       
____________________________________________________________________________________
Pinpoint customers who are looking for what you sell. 
http://searchmarketing.yahoo.com/

-- 
MySQL++ Mailing List
For list archives: 
http://lists.mysql.com/plusplus
To unsubscribe:    
http://lists.mysql.com/plusplus?unsub=lists@pantek.com
Received on Mon Jul 16 09:32:37 2007