List:MySQL++« Previous MessageNext Message »
From:Alex Date:August 22 2008 1:26pm
Subject:Re: A way to copy mysqlpp::StoreQueryResult into a std::map?
View as plain text  
Alright now.. Rewrote the first chunk of code to my liking.

                mysqlpp::Query qry_help_cmd = mysql_conn.query("SELECT *
FROM `command` WHERE `name` = ");
                qry_help_cmd << quote << command_tokens[1];
                mysqlpp::StoreQueryResult res_help_cmd =
qry_help_cmd.store();
                if(res_help_cmd){
                        slog.clog("Name: " + res_help_cmd[0]["name"]);
                        slog.clog("Syntax: " + res_help_cmd[0]["syntax"]);
                        slog.clog("Description: " +
res_help_cmd[0]["help"]);
                }else{
                        slog.clog("No help available for " +
command_tokens[1] + ".");
                };

Although, it seems either a) I did something wrong or b) mysql++ is acting
weird. Because, it somehow manages to make the query into this:

terminate called after throwing an instance of 'mysqlpp::BadQuery'
  what():  You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use near
''info' * from `command` where `name` =' at line 1

That's.. Not what it's supposed to do, is it?

Note: command_tokens is the tokens of the entered text ("help info" becomes
command_tokens[0] and command_tokens[1]).

And yes, I do have the actual data in the DB:

mysql> select * from awi.command where name = "info";
+------+------------------------------+--------+
| name | help                         | syntax |
+------+------------------------------+--------+
| info | Shows information about AWI. | info   |
+------+------------------------------+--------+

I might've missed some little detail here, though. Scanned it over
thoroughly and couldn't find any errors in my version.

Thanks.

2008/8/21 Alex <xtzgzorex@stripped>

> Haha, no, not homework. Just a project I'm working on. :)
>
> Thanks for that extensive piece of code. I'll try to give it a shot
> tomorrow.. Right now, I'm going to go to sleep.
>
> Thanks again. :)
>
> 2008/8/21 Warren Young <mysqlpp@stripped>
>
>> Alex wrote:
>>
>>
>>> So you can understand that I wouldn't be able to directly refer to the
>>> specific command the user wants help for as the vector is split up in
>>> numbers.
>>>
>>
>> I understand no such thing.  The answer is simple either way:
>>
>>        Query q = conn.query("SELECT * FROM command WHERE NAME =");
>>        q << quote << myCommandName;
>>        StoreQueryResult res = q.store();
>>        if (res) {
>>                // have help for this command
>>        }
>>        else {
>>                // don't have help for this command
>>        }
>>
>> Or:
>>
>>        class command {
>>        public:
>>                command(const char* name, const char* help = 0,
>>                        const char* syntax = 0) :
>>                name_(name),
>>                help_(help ? help : ""),
>>                syntax_(syntax ? syntax : "")
>>                {
>>                }
>>                ....
>>                bool operator==(const command& rhs)
>>                {
>>                        return name_ == rhs.name_;
>>                }
>>        private:
>>                string name_, help_, syntax_;
>>        };
>>
>>        vector<commands> vc;
>>
>>        // populate vector of command objects somehow
>>
>>        vector<commands>::iterator it = find(vc.begin(), vc.end(),
>>                command(myCommandName));
>>        if (it != vc.end()) {
>>                // have help for this command
>>        }
>>        else {
>>                // don't have help for this command
>>        }
>>
>> So, is this a homework problem, or what?
>>
>>
>> --
>> MySQL++ Mailing List
>> For list archives: http://lists.mysql.com/plusplus
>> To unsubscribe:
>> http://lists.mysql.com/plusplus?unsub=1
>>
>>
>
>
> --
> GamerzWoW - http://www.gamerzwow.net
>



-- 
GamerzWoW - http://www.gamerzwow.net

Thread
A way to copy mysqlpp::StoreQueryResult into a std::map?Alex13 Aug
  • Re: A way to copy mysqlpp::StoreQueryResult into a std::map?Warren Young13 Aug
    • Re: A way to copy mysqlpp::StoreQueryResult into a std::map?Alex13 Aug
      • Re: A way to copy mysqlpp::StoreQueryResult into a std::map?Warren Young13 Aug
        • Re: A way to copy mysqlpp::StoreQueryResult into a std::map?Alex14 Aug
          • Re: A way to copy mysqlpp::StoreQueryResult into a std::map?Alex17 Aug
            • Re: A way to copy mysqlpp::StoreQueryResult into a std::map?Warren Young17 Aug
              • Re: A way to copy mysqlpp::StoreQueryResult into a std::map?Alex19 Aug
                • Re: A way to copy mysqlpp::StoreQueryResult into a std::map?Warren Young19 Aug
                  • Re: A way to copy mysqlpp::StoreQueryResult into a std::map?Alex20 Aug
                    • Re: A way to copy mysqlpp::StoreQueryResult into a std::map?Warren Young21 Aug
                      • Re: A way to copy mysqlpp::StoreQueryResult into a std::map?Alex21 Aug
                        • Re: A way to copy mysqlpp::StoreQueryResult into a std::map?Warren Young21 Aug
                          • Re: A way to copy mysqlpp::StoreQueryResult into a std::map?Alex21 Aug
                            • Re: A way to copy mysqlpp::StoreQueryResult into a std::map?Alex22 Aug
                              • Re: A way to copy mysqlpp::StoreQueryResult into a std::map?Warren Young22 Aug
                                • Re: A way to copy mysqlpp::StoreQueryResult into a std::map?Alex22 Aug
                                  • Re: A way to copy mysqlpp::StoreQueryResult into a std::map?Warren Young22 Aug
                                    • Re: A way to copy mysqlpp::StoreQueryResult into a std::map?Alex22 Aug
                                      • Re: A way to copy mysqlpp::StoreQueryResult into a std::map?Alex22 Aug
                                      • Re: A way to copy mysqlpp::StoreQueryResult into a std::map?Warren Young22 Aug
                                        • Re: A way to copy mysqlpp::StoreQueryResult into a std::map?Alex22 Aug
                                          • Re: A way to copy mysqlpp::StoreQueryResult into a std::map?Warren Young22 Aug
                                            • Re: A way to copy mysqlpp::StoreQueryResult into a std::map?Alex25 Aug
                                              • Re: A way to copy mysqlpp::StoreQueryResult into a std::map?Joel Fielder26 Aug
                                                • Re: A way to copy mysqlpp::StoreQueryResult into a std::map?Alex26 Aug
                                                  • Re: A way to copy mysqlpp::StoreQueryResult into a std::map?Joel Fielder26 Aug
                                                    • Re: A way to copy mysqlpp::StoreQueryResult into a std::map?Alex26 Aug
                                                  • Re: A way to copy mysqlpp::StoreQueryResult into a std::map?Warren Young26 Aug
                                                    • Re: A way to copy mysqlpp::StoreQueryResult into a std::map?Alex27 Aug