cppcms-users

[Cppcms-users] How to call MySQL store procedure

[陈抒 <csf...@gm...>]

Hello,
  I didn't find any document that describes this feature.
  Can anybody tell me how to do this?



陈抒
Best regards
http://blog.csdn.net/sheismylife

Re: [Cppcms-users] How to call MySQL store procedure

[陈抒 <csf...@gm...>]

It seems that CPPDB doesn't support store procedure for now. Any plan for
this?
I have to use MySQL++ now.

陈抒
Best regards
http://blog.csdn.net/sheismylife


On Wed, Jul 20, 2011 at 4:04 PM, 陈抒 <csf...@gm...> wrote:

> Hello,
>   I didn't find any document that describes this feature.
>   Can anybody tell me how to do this?
>
>
>
> 陈抒
> Best regards
> http://blog.csdn.net/sheismylife
>

Re: [Cppcms-users] How to call MySQL store procedure

[Artyom B. <art...@ya...>]

To: cpp...@li...
>Sent: Thursday, July 28, 2011 5:21 PM
>Subject: Re: [Cppcms-users] How to call MySQL store procedure
>
>
>It seems that CPPDB doesn't support store procedure for now. Any plan for this?
>I have to use MySQL++ now.
>陈抒 
>Best regards
>http://blog.csdn.net/sheismylife
>
>


Do you have any specific problems calling stored procedures?

See: http://dev.mysql.com/doc/refman/5.5/en/call.html

I don't see something specific that would prevent from executing

"CALL " statement or query.

This example from the site:

mysql_query(mysql, "SET @increment = 10");
mysql_query(mysql, "CALL p(@version, @increment)");
mysql_query(mysql, "SELECT @version, @increment");
result = mysql_store_result(mysql);
row = mysql_fetch_row(result);
mysql_free_result(result);

Can be executed as;


sql << "SET @increment = 10" << cppdb::exec;
sql << "CALL p(@version, @increment)" << cppdb::exec;
cppdb::result r = sql << "SELECT @version, @increment";

By default CppDB uses prepared statements, if you want unprepared onces
(I don't know if mysql requires unprepared statements for such things)
you may call

sql.create_statement("SET @increment = 10").exec();
sql.create_statement("CALL p(@version, @increment)").exec();
cppdb::result r = sql.create_statement("SELECT @version, @increment");
If you have any specific problems using CALL syntax tell
exactly what you are doing and probably provide a simple
use case that shows the problem.


Artyom

Re: [Cppcms-users] How to call MySQL store procedure

[陈抒 <csf...@gm...>]

I am sorry I didn't see this email.I will try it soon.
Thanks.

陈抒
Best regards
http://blog.csdn.net/sheismylife


On Fri, Jul 29, 2011 at 3:32 AM, Artyom Beilis <art...@ya...> wrote:

>
> To: cpp...@li...
> >Sent: Thursday, July 28, 2011 5:21 PM
> >Subject: Re: [Cppcms-users] How to call MySQL store procedure
> >
> >
> >It seems that CPPDB doesn't support store procedure for now. Any plan for
> this?
> >I have to use MySQL++ now.
> >陈抒
> >Best regards
> >http://blog.csdn.net/sheismylife
> >
> >
>
>
> Do you have any specific problems calling stored procedures?
>
> See: http://dev.mysql.com/doc/refman/5.5/en/call.html
>
> I don't see something specific that would prevent from executing
>
> "CALL " statement or query.
>
> This example from the site:
>
> mysql_query(mysql, "SET @increment = 10");
> mysql_query(mysql, "CALL p(@version, @increment)");
> mysql_query(mysql, "SELECT @version, @increment");
> result = mysql_store_result(mysql);
> row = mysql_fetch_row(result);
> mysql_free_result(result);
>
> Can be executed as;
>
>
> sql << "SET @increment = 10" << cppdb::exec;
> sql << "CALL p(@version, @increment)" << cppdb::exec;
> cppdb::result r = sql << "SELECT @version, @increment";
>
> By default CppDB uses prepared statements, if you want unprepared onces
> (I don't know if mysql requires unprepared statements for such things)
> you may call
>
> sql.create_statement("SET @increment = 10").exec();
> sql.create_statement("CALL p(@version, @increment)").exec();
> cppdb::result r = sql.create_statement("SELECT @version, @increment");
> If you have any specific problems using CALL syntax tell
> exactly what you are doing and probably provide a simple
> use case that shows the problem.
>
>
> Artyom
>
>
> ------------------------------------------------------------------------------
> Got Input?   Slashdot Needs You.
> Take our quick survey online.  Come on, we don't ask for help often.
> Plus, you'll get a chance to win $100 to spend on ThinkGeek.
> http://p.sf.net/sfu/slashdot-survey
> _______________________________________________
> Cppcms-users mailing list
> Cpp...@li...
> https://lists.sourceforge.net/lists/listinfo/cppcms-users
>