Hello ViSolve DB Team, thank you for response. I guess I didn't write clearly enough what information I need: general usage of prepared statements I already know.
The question right now is, if I get a result set containing several rows, must I fetch *all* of them, if I don't use client side cursor. Because when using "classic functions" instead of prepared statements, I really must fetch *all* rows to avoid memory leak on database engine. With best regards, Roland. Visolve DB Team schrieb am 17.10.2006 07:57: > Hi, > > Hope this link will be useful: > http://mirrors.sunsite.dk/mysql/doc/refman/5.1/en/c-api-prepared-statement-functions.html > > > Thanks > ViSolve DB Team > ----- Original Message ----- From: "Roland Volkmann" > <[EMAIL PROTECTED]> > To: <mysql@lists.mysql.com> > Sent: Sunday, October 15, 2006 5:59 PM > Subject: result set on prepared statements > > >> Hello all, >> >> using MySQL C API function "|mysql_query()" with a query producing a >> result set, I have to fetch *all* records, if I use >> "||mysql_use_result()" to avoid a client side cursor. So it's written in >> the manual section |22.2.3.70. >> >> But if I want to use prepared statements with MySQL C API functions " >> |mysql_stmt_prepare()", ||"mysql_stmt_execute()" and >> "||mysql_stmt_fetch()", I can't find anything in the manual, whether I >> also have to fetch *all* records, when not using >> "||mysql_stmt_store_result()" (I don't want to use client side cursor). >> MySQL Version is 5.0.26 on Windows 32 Bit. >> >> Any Information is welcome. >> >> >> With best regards, >> >> Roland. >> | >> >> -- >> MySQL General Mailing List >> For list archives: http://lists.mysql.com/mysql >> To unsubscribe: >> http://lists.mysql.com/[EMAIL PROTECTED] >> > > > . > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
