execute statement within statement

This is a discussion on execute statement within statement within the MySQL Database forums, part of the Database Forums category; Hi, I would like to use your experience on a problem. I would like to execute a statement from within ...


Go Back   Usenet Forums > Database Forums > MySQL Database

FAQ Members List Calendar Search Today's Posts Mark Forums Read
  #1 (permalink)  
Old 03-17-2008
alexandre.melard@gmail.com
 
Posts: n/a
Default execute statement within statement

Hi,

I would like to use your experience on a problem. I would like to
execute a statement from within another statement, it seems that it is
not possible...

01 prepare STMT1
02 prepare STMT2
03
04 execute STMT1
05 fetch STMT1
06 execute STMT2
07 clean STMT2
08 fetch STMT1
09 execute STMT2
10 clean STMT2
11 clean STMT1

I get a Commands out of sync; you can't run this command now error
from line 06

I would like to get your expertise on that matters, what would be a
good work around for this?

Thank you for your support

Alexandre MELARD
Reply With Quote
  #2 (permalink)  
Old 03-27-2008
alexandre.melard@gmail.com
 
Posts: n/a
Default Re: execute statement within statement

UP

On 17 mar, 17:06, alexandre.mel...@gmail.com wrote:
> Hi,
>
> I would like to use your experience on a problem. I would like to
> execute a statement from within another statement, it seems that it is
> not possible...
>
> 01 prepare STMT1
> 02 prepare STMT2
> 03
> 04 execute STMT1
> 05 fetch STMT1
> 06 execute STMT2
> 07 clean STMT2
> 08 fetch STMT1
> 09 execute STMT2
> 10 clean STMT2
> 11 clean STMT1
>
> I get a Commands out of sync; you can't run this command now error
> from line 06
>
> I would like to get your expertise on that matters, what would be a
> good work around for this?
>
> Thank you for your support
>
> AlexandreMELARD


Reply With Quote
  #3 (permalink)  
Old 03-27-2008
Peter H. Coffin
 
Posts: n/a
Default Re: execute statement within statement

On Thu, 27 Mar 2008 07:27:43 -0700 (PDT), alexandre.melard@gmail.com wrote:
> UP


Up? What the hell is "up"?

--
51. If one of my dungeon guards begins expressing concern over the conditions
in the beautiful princess' cell, I will immediately transfer him to a
less people-oriented position.
--Peter Anspach's list of things to do as an Evil Overlord
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are Off
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT +1. The time now is 04:14 AM.


Powered by vBulletin® Version 3.6.8
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Content Relevant URLs by vBSEO 3.0.0