Bookmarks

Yahoo Gmail Google Facebook Delicious Twitter Reddit Stumpleupon Myspace Digg

Search queries

sqldatasource dal, wwwxxxenden, convert raid5 to raid 10 mdadm, apache force chunked, nrao wwwxxx, xxxxxdup, procmail change subject header, wwwXxx not20, Wwwxxx.doks sas, linux raid resync after reboot

Links

XODOX
Impressum

#1: 2014 Commands out of sync; you can"t run this command now

Posted on 2007-07-25 19:09:37 by yaguirre

Hello All,

I was searching for a response about this topic but none get the right
answare, I hope i get help from you on this. :)

I trying to do an insert using a stored procedure to rely the charge
on the db but every type I run the call from my web page ussing PHP
5.X I get the same error.

This is what I'm doing:
____________________________________________________________ __________________________________
$link = mysql_connect( DB_HOST, DB_USER, DB_PASSWORD, true, 131074);
mysql_select_db(DB_NAME);

$sql = "call spTestCreate('" .
trim($Value1) . "', '" .
trim($Value2) . "', '" .
trim($Value3) . "', " .
$Value4 . ", " .
$Value5 . ", '" .
trim($Value6) . "', '" .
trim($Value7) . "', '" .
trim($Value8) . "') ; ";

$res = mysql_query($sql);

if (!$res) {
echo "Could not successfully run query (" . $sql . ") from DB: " .
mysql_error();
} else {
$row = mysql_fetch_row($res);
$LastId = $row[0];
}
____________________________________________________________ __________________________________

If I run the call from the SQLyog or any other tool it runs prefect
but that's not the case in the PHP.

Any Idea or Solution is welcome.

Thanks!

Report this message

#2: Re: 2014 Commands out of sync; you can"t run this command now

Posted on 2007-07-25 19:14:01 by Shawn Hamzee

yaguirre@gmail.com wrote:
> Hello All,
>
> I was searching for a response about this topic but none get the right
> answare, I hope i get help from you on this. :)
>
> I trying to do an insert using a stored procedure to rely the charge
> on the db but every type I run the call from my web page ussing PHP
> 5.X I get the same error.
>
> This is what I'm doing:
> ____________________________________________________________ __________________________________
> $link = mysql_connect( DB_HOST, DB_USER, DB_PASSWORD, true, 131074);
> mysql_select_db(DB_NAME);
>
> $sql = "call spTestCreate('" .
> trim($Value1) . "', '" .
> trim($Value2) . "', '" .
> trim($Value3) . "', " .
> $Value4 . ", " .
> $Value5 . ", '" .
> trim($Value6) . "', '" .
> trim($Value7) . "', '" .
> trim($Value8) . "') ; ";
>
> $res = mysql_query($sql);
>
> if (!$res) {
> echo "Could not successfully run query (" . $sql . ") from DB: " .
> mysql_error();
> } else {
> $row = mysql_fetch_row($res);
> $LastId = $row[0];
> }
> ____________________________________________________________ __________________________________
>
> If I run the call from the SQLyog or any other tool it runs prefect
> but that's not the case in the PHP.
>
> Any Idea or Solution is welcome.
>
> Thanks!
>
do an echo($sql) or print($sql) and post the results in here.

Report this message

#3: Re: 2014 Commands out of sync; you can"t run this command now

Posted on 2007-07-25 19:23:07 by yaguirre

On Jul 25, 11:14 am, lark <ham...@sbcglobal.net> wrote:
> yagui...@gmail.com wrote:
> > Hello All,
>
> > I was searching for a response about this topic but none get the right
> > answare, I hope i get help from you on this. :)
>
> > I trying to do an insert using a stored procedure to rely the charge
> > on the db but every type I run the call from my web page ussing PHP
> > 5.X I get the same error.
>
> > This is what I'm doing:
> > ____________________________________________________________ __________________________________
> > $link = mysql_connect( DB_HOST, DB_USER, DB_PASSWORD, true, 131074);
> > mysql_select_db(DB_NAME);
>
> > $sql = "call spTestCreate('" .
> > trim($Value1) . "', '" .
> > trim($Value2) . "', '" .
> > trim($Value3) . "', " .
> > $Value4 . ", " .
> > $Value5 . ", '" .
> > trim($Value6) . "', '" .
> > trim($Value7) . "', '" .
> > trim($Value8) . "') ; ";
>
> > $res = mysql_query($sql);
>
> > if (!$res) {
> > echo "Could not successfully run query (" . $sql . ") from DB: " .
> > mysql_error();
> > } else {
> > $row = mysql_fetch_row($res);
> > $LastId = $row[0];
> > }
> > ____________________________________________________________ __________________________________
>
> > If I run the call from the SQLyog or any other tool it runs prefect
> > but that's not the case in the PHP.
>
> > Any Idea or Solution is welcome.
>
> > Thanks!
>
> do an echo($sql) or print($sql) and post the results in here.

The result of the echo is the next:

call spTestCreate('myself', 'value2', 'value3', 56, 0, 'value6',
'value7', '7818ec0361') ;

Report this message

#4: Re: 2014 Commands out of sync; you can"t run this command now

Posted on 2007-07-25 20:09:17 by yaguirre

On Jul 25, 11:23 am, "yagui...@gmail.com" <yagui...@gmail.com> wrote:
> On Jul 25, 11:14 am, lark <ham...@sbcglobal.net> wrote:
>
>
>
> > yagui...@gmail.com wrote:
> > > Hello All,
>
> > > I was searching for a response about this topic but none get the right
> > > answare, I hope i get help from you on this. :)
>
> > > I trying to do an insert using a stored procedure to rely the charge
> > > on the db but every type I run the call from my web page ussing PHP
> > > 5.X I get the same error.
>
> > > This is what I'm doing:
> > > ____________________________________________________________ __________________________________
> > > $link = mysql_connect( DB_HOST, DB_USER, DB_PASSWORD, true, 131074);
> > > mysql_select_db(DB_NAME);
>
> > > $sql = "call spTestCreate('" .
> > > trim($Value1) . "', '" .
> > > trim($Value2) . "', '" .
> > > trim($Value3) . "', " .
> > > $Value4 . ", " .
> > > $Value5 . ", '" .
> > > trim($Value6) . "', '" .
> > > trim($Value7) . "', '" .
> > > trim($Value8) . "') ; ";
>
> > > $res = mysql_query($sql);
>
> > > if (!$res) {
> > > echo "Could not successfully run query (" . $sql . ") from DB: " .
> > > mysql_error();
> > > } else {
> > > $row = mysql_fetch_row($res);
> > > $LastId = $row[0];
> > > }
> > > ____________________________________________________________ __________________________________
>
> > > If I run the call from the SQLyog or any other tool it runs prefect
> > > but that's not the case in the PHP.
>
> > > Any Idea or Solution is welcome.
>
> > > Thanks!
>
> > do an echo($sql) or print($sql) and post the results in here.
>
> The result of the echo is the next:
>
> call spTestCreate('myself', 'value2', 'value3', 56, 0, 'value6',
> 'value7', '7818ec0361') ;

One more thing to say from my side is that all the select queries are
running fine and no errors so far. just in this kind of queries.

Hope you find guys could help me.

TIA.

Report this message

#5: Re: 2014 Commands out of sync; you can"t run this command now

Posted on 2007-07-25 22:56:54 by Shawn Hamzee

Chainsaw [cr] wrote:
> On Jul 25, 11:23 am, "yagui...@gmail.com" <yagui...@gmail.com> wrote:
>> On Jul 25, 11:14 am, lark <ham...@sbcglobal.net> wrote:
>>
>>
>>
>>> yagui...@gmail.com wrote:
>>>> Hello All,
>>>> I was searching for a response about this topic but none get the right
>>>> answare, I hope i get help from you on this. :)
>>>> I trying to do an insert using a stored procedure to rely the charge
>>>> on the db but every type I run the call from my web page ussing PHP
>>>> 5.X I get the same error.
>>>> This is what I'm doing:
>>>> ____________________________________________________________ __________________________________
>>>> $link = mysql_connect( DB_HOST, DB_USER, DB_PASSWORD, true, 131074);
>>>> mysql_select_db(DB_NAME);
>>>> $sql = "call spTestCreate('" .
>>>> trim($Value1) . "', '" .
>>>> trim($Value2) . "', '" .
>>>> trim($Value3) . "', " .
>>>> $Value4 . ", " .
>>>> $Value5 . ", '" .
>>>> trim($Value6) . "', '" .
>>>> trim($Value7) . "', '" .
>>>> trim($Value8) . "') ; ";
>>>> $res = mysql_query($sql);
>>>> if (!$res) {
>>>> echo "Could not successfully run query (" . $sql . ") from DB: " .
>>>> mysql_error();
>>>> } else {
>>>> $row = mysql_fetch_row($res);
>>>> $LastId = $row[0];
>>>> }
>>>> ____________________________________________________________ __________________________________
>>>> If I run the call from the SQLyog or any other tool it runs prefect
>>>> but that's not the case in the PHP.
>>>> Any Idea or Solution is welcome.
>>>> Thanks!
>>> do an echo($sql) or print($sql) and post the results in here.
>> The result of the echo is the next:
>>
>> call spTestCreate('myself', 'value2', 'value3', 56, 0, 'value6',
>> 'value7', '7818ec0361') ;
>
> One more thing to say from my side is that all the select queries are
> running fine and no errors so far. just in this kind of queries.
>
> Hope you find guys could help me.
>
> TIA.
>
what is the data type of the fields that correspond to values "56" and "0"?



--
lark -- hamzee@sbcdeglobalspam.net
To reply to me directly, delete "despam".

Report this message

#6: Re: 2014 Commands out of sync; you can"t run this command now

Posted on 2007-07-26 00:34:22 by yaguirre

On Jul 25, 2:56 pm, lark <ham...@sbcglobal.net> wrote:
> Chainsaw [cr] wrote:
> > On Jul 25, 11:23 am, "yagui...@gmail.com" <yagui...@gmail.com> wrote:
> >> On Jul 25, 11:14 am, lark <ham...@sbcglobal.net> wrote:
>
> >>> yagui...@gmail.com wrote:
> >>>> Hello All,
> >>>> I was searching for a response about this topic but none get the right
> >>>> answare, I hope i get help from you on this. :)
> >>>> I trying to do an insert using a stored procedure to rely the charge
> >>>> on the db but every type I run the call from my web page ussing PHP
> >>>> 5.X I get the same error.
> >>>> This is what I'm doing:
> >>>> ____________________________________________________________ __________________________________
> >>>> $link = mysql_connect( DB_HOST, DB_USER, DB_PASSWORD, true, 131074);
> >>>> mysql_select_db(DB_NAME);
> >>>> $sql = "call spTestCreate('" .
> >>>> trim($Value1) . "', '" .
> >>>> trim($Value2) . "', '" .
> >>>> trim($Value3) . "', " .
> >>>> $Value4 . ", " .
> >>>> $Value5 . ", '" .
> >>>> trim($Value6) . "', '" .
> >>>> trim($Value7) . "', '" .
> >>>> trim($Value8) . "') ; ";
> >>>> $res = mysql_query($sql);
> >>>> if (!$res) {
> >>>> echo "Could not successfully run query (" . $sql . ") from DB: " .
> >>>> mysql_error();
> >>>> } else {
> >>>> $row = mysql_fetch_row($res);
> >>>> $LastId = $row[0];
> >>>> }
> >>>> ____________________________________________________________ __________________________________
> >>>> If I run the call from the SQLyog or any other tool it runs prefect
> >>>> but that's not the case in the PHP.
> >>>> Any Idea or Solution is welcome.
> >>>> Thanks!
> >>> do an echo($sql) or print($sql) and post the results in here.
> >> The result of the echo is the next:
>
> >> call spTestCreate('myself', 'value2', 'value3', 56, 0, 'value6',
> >> 'value7', '7818ec0361') ;
>
> > One more thing to say from my side is that all the select queries are
> > running fine and no errors so far. just in this kind of queries.
>
> > Hope you find guys could help me.
>
> > TIA.
>
> what is the data type of the fields that correspond to values "56" and "0"?
>
> --
> lark -- ham...@sbcdeglobalspam.net
> To reply to me directly, delete "despam".

Those fields are int(11);

FYI The other stored procedures run OK, only this and others with the
same insert and last_insert_id() has the problems.

TIA.

Report this message

#7: Re: 2014 Commands out of sync; you can"t run this command now

Posted on 2007-07-26 03:20:25 by Shawn Hamzee

Chainsaw [cr] wrote:
> On Jul 25, 2:56 pm, lark <ham...@sbcglobal.net> wrote:
>> Chainsaw [cr] wrote:
>>> On Jul 25, 11:23 am, "yagui...@gmail.com" <yagui...@gmail.com> wrote:
>>>> On Jul 25, 11:14 am, lark <ham...@sbcglobal.net> wrote:
>>>>> yagui...@gmail.com wrote:
>>>>>> Hello All,
>>>>>> I was searching for a response about this topic but none get the right
>>>>>> answare, I hope i get help from you on this. :)
>>>>>> I trying to do an insert using a stored procedure to rely the charge
>>>>>> on the db but every type I run the call from my web page ussing PHP
>>>>>> 5.X I get the same error.
>>>>>> This is what I'm doing:
>>>>>> ____________________________________________________________ __________________________________
>>>>>> $link = mysql_connect( DB_HOST, DB_USER, DB_PASSWORD, true, 131074);
>>>>>> mysql_select_db(DB_NAME);
>>>>>> $sql = "call spTestCreate('" .
>>>>>> trim($Value1) . "', '" .
>>>>>> trim($Value2) . "', '" .
>>>>>> trim($Value3) . "', " .
>>>>>> $Value4 . ", " .
>>>>>> $Value5 . ", '" .
>>>>>> trim($Value6) . "', '" .
>>>>>> trim($Value7) . "', '" .
>>>>>> trim($Value8) . "') ; ";
>>>>>> $res = mysql_query($sql);
>>>>>> if (!$res) {
>>>>>> echo "Could not successfully run query (" . $sql . ") from DB: " .
>>>>>> mysql_error();
>>>>>> } else {
>>>>>> $row = mysql_fetch_row($res);
>>>>>> $LastId = $row[0];
>>>>>> }
>>>>>> ____________________________________________________________ __________________________________
>>>>>> If I run the call from the SQLyog or any other tool it runs prefect
>>>>>> but that's not the case in the PHP.
>>>>>> Any Idea or Solution is welcome.
>>>>>> Thanks!
>>>>> do an echo($sql) or print($sql) and post the results in here.
>>>> The result of the echo is the next:
>>>> call spTestCreate('myself', 'value2', 'value3', 56, 0, 'value6',
>>>> 'value7', '7818ec0361') ;
>>> One more thing to say from my side is that all the select queries are
>>> running fine and no errors so far. just in this kind of queries.
>>> Hope you find guys could help me.
>>> TIA.
>> what is the data type of the fields that correspond to values "56" and "0"?
>>
>> --
>> lark -- ham...@sbcdeglobalspam.net
>> To reply to me directly, delete "despam".
>
> Those fields are int(11);
>
> FYI The other stored procedures run OK, only this and others with the
> same insert and last_insert_id() has the problems.
>
> TIA.
>
make sure that the user that is logged in through your php application
has execute privilege in the database where the stored procedure is
declared.

Report this message

#8: Re: 2014 Commands out of sync; you can"t run this command now

Posted on 2007-07-26 16:28:23 by yaguirre

On Jul 25, 7:20 pm, lark <ham...@sbcglobal.net> wrote:
> Chainsaw [cr] wrote:
> > On Jul 25, 2:56 pm, lark <ham...@sbcglobal.net> wrote:
> >> Chainsaw [cr] wrote:
> >>> On Jul 25, 11:23 am, "yagui...@gmail.com" <yagui...@gmail.com> wrote:
> >>>> On Jul 25, 11:14 am, lark <ham...@sbcglobal.net> wrote:
> >>>>> yagui...@gmail.com wrote:
> >>>>>> Hello All,
> >>>>>> I was searching for a response about this topic but none get the right
> >>>>>> answare, I hope i get help from you on this. :)
> >>>>>> I trying to do an insert using a stored procedure to rely the charge
> >>>>>> on the db but every type I run the call from my web page ussing PHP
> >>>>>> 5.X I get the same error.
> >>>>>> This is what I'm doing:
> >>>>>> ____________________________________________________________ __________________________________
> >>>>>> $link = mysql_connect( DB_HOST, DB_USER, DB_PASSWORD, true, 131074);
> >>>>>> mysql_select_db(DB_NAME);
> >>>>>> $sql = "call spTestCreate('" .
> >>>>>> trim($Value1) . "', '" .
> >>>>>> trim($Value2) . "', '" .
> >>>>>> trim($Value3) . "', " .
> >>>>>> $Value4 . ", " .
> >>>>>> $Value5 . ", '" .
> >>>>>> trim($Value6) . "', '" .
> >>>>>> trim($Value7) . "', '" .
> >>>>>> trim($Value8) . "') ; ";
> >>>>>> $res = mysql_query($sql);
> >>>>>> if (!$res) {
> >>>>>> echo "Could not successfully run query (" . $sql . ") from DB: " .
> >>>>>> mysql_error();
> >>>>>> } else {
> >>>>>> $row = mysql_fetch_row($res);
> >>>>>> $LastId = $row[0];
> >>>>>> }
> >>>>>> ____________________________________________________________ __________________________________
> >>>>>> If I run the call from the SQLyog or any other tool it runs prefect
> >>>>>> but that's not the case in the PHP.
> >>>>>> Any Idea or Solution is welcome.
> >>>>>> Thanks!
> >>>>> do an echo($sql) or print($sql) and post the results in here.
> >>>> The result of the echo is the next:
> >>>> call spTestCreate('myself', 'value2', 'value3', 56, 0, 'value6',
> >>>> 'value7', '7818ec0361') ;
> >>> One more thing to say from my side is that all the select queries are
> >>> running fine and no errors so far. just in this kind of queries.
> >>> Hope you find guys could help me.
> >>> TIA.
> >> what is the data type of the fields that correspond to values "56" and "0"?
>
> >> --
> >> lark -- ham...@sbcdeglobalspam.net
> >> To reply to me directly, delete "despam".
>
> > Those fields are int(11);
>
> > FYI The other stored procedures run OK, only this and others with the
> > same insert and last_insert_id() has the problems.
>
> > TIA.
>
> make sure that the user that is logged in through your php application
> has execute privilege in the database where the stored procedure is
> declared.

I did check the user access rights and has all the options granted but
still getting the same error. "Commands out of sync; you cannot run
this command now "
I still no have a clue around this.

Report this message

#9: Re: 2014 Commands out of sync; you can"t run this command now

Posted on 2007-07-26 19:52:24 by Shawn Hamzee

Chainsaw [cr] wrote:
> On Jul 25, 7:20 pm, lark <ham...@sbcglobal.net> wrote:
>> Chainsaw [cr] wrote:
>>> On Jul 25, 2:56 pm, lark <ham...@sbcglobal.net> wrote:
>>>> Chainsaw [cr] wrote:
>>>>> On Jul 25, 11:23 am, "yagui...@gmail.com" <yagui...@gmail.com> wrote:
>>>>>> On Jul 25, 11:14 am, lark <ham...@sbcglobal.net> wrote:
>>>>>>> yagui...@gmail.com wrote:
>>>>>>>> Hello All,
>>>>>>>> I was searching for a response about this topic but none get the right
>>>>>>>> answare, I hope i get help from you on this. :)
>>>>>>>> I trying to do an insert using a stored procedure to rely the charge
>>>>>>>> on the db but every type I run the call from my web page ussing PHP
>>>>>>>> 5.X I get the same error.
>>>>>>>> This is what I'm doing:
>>>>>>>> ____________________________________________________________ __________________________________
>>>>>>>> $link = mysql_connect( DB_HOST, DB_USER, DB_PASSWORD, true, 131074);
>>>>>>>> mysql_select_db(DB_NAME);
>>>>>>>> $sql = "call spTestCreate('" .
>>>>>>>> trim($Value1) . "', '" .
>>>>>>>> trim($Value2) . "', '" .
>>>>>>>> trim($Value3) . "', " .
>>>>>>>> $Value4 . ", " .
>>>>>>>> $Value5 . ", '" .
>>>>>>>> trim($Value6) . "', '" .
>>>>>>>> trim($Value7) . "', '" .
>>>>>>>> trim($Value8) . "') ; ";
>>>>>>>> $res = mysql_query($sql);
>>>>>>>> if (!$res) {
>>>>>>>> echo "Could not successfully run query (" . $sql . ") from DB: " .
>>>>>>>> mysql_error();
>>>>>>>> } else {
>>>>>>>> $row = mysql_fetch_row($res);
>>>>>>>> $LastId = $row[0];
>>>>>>>> }
>>>>>>>> ____________________________________________________________ __________________________________
>>>>>>>> If I run the call from the SQLyog or any other tool it runs prefect
>>>>>>>> but that's not the case in the PHP.
>>>>>>>> Any Idea or Solution is welcome.
>>>>>>>> Thanks!
>>>>>>> do an echo($sql) or print($sql) and post the results in here.
>>>>>> The result of the echo is the next:
>>>>>> call spTestCreate('myself', 'value2', 'value3', 56, 0, 'value6',
>>>>>> 'value7', '7818ec0361') ;
>>>>> One more thing to say from my side is that all the select queries are
>>>>> running fine and no errors so far. just in this kind of queries.
>>>>> Hope you find guys could help me.
>>>>> TIA.
>>>> what is the data type of the fields that correspond to values "56" and "0"?
>>>> --
>>>> lark -- ham...@sbcdeglobalspam.net
>>>> To reply to me directly, delete "despam".
>>> Those fields are int(11);
>>> FYI The other stored procedures run OK, only this and others with the
>>> same insert and last_insert_id() has the problems.
>>> TIA.
>> make sure that the user that is logged in through your php application
>> has execute privilege in the database where the stored procedure is
>> declared.
>
> I did check the user access rights and has all the options granted but
> still getting the same error. "Commands out of sync; you cannot run
> this command now "
> I still no have a clue around this.
>
>
>

If you get `Commands out of sync; You can't run this command now' in
your client code, you are calling client functions in the wrong order!

This can happen, for example, if you are using `mysql_use_result()' and
try to execute a new query before you have called `mysql_free_result()'.
It can also happen if you try to execute two queries that return data
without a `mysql_use_result()' or `mysql_store_result()' in between.

what version of php are you using?

Report this message

#10: Re: 2014 Commands out of sync; you can"t run this command now

Posted on 2007-07-26 23:27:35 by yaguirre

The stored procedure is built to do :

1- insert into a table
2- get last id inserted and return it in a select statement ( select
last_inserted_id(); )

And the PHP is located in to computers the first is a 5.2.3 which is
the Dev Server and other is an 5.2.0-8 in the Production server but so
far both has the same problem.

Thanks for all the help.

Report this message

#11: Re: 2014 Commands out of sync; you can"t run this command now

Posted on 2007-07-28 06:10:06 by Shawn Hamzee

== Quote from "Chainsaw [cr]" (yaguirre@gmail.com)'s article
> The stored procedure is built to do :
> 1- insert into a table
> 2- get last id inserted and return it in a select statement ( select
> last_inserted_id(); )
> And the PHP is located in to computers the first is a 5.2.3 which is
> the Dev Server and other is an 5.2.0-8 in the Production server but so
> far both has the same problem.
> Thanks for all the help.

somewhere, somehow, your sql statements are out of order; maybe not inside the
procedure but around the code that calls the procedure.



--
POST BY: lark with PHP News Reader

Report this message

#12: Re: 2014 Commands out of sync; you can"t run this command now

Posted on 2007-07-30 05:29:00 by gordonb.1q6g6

>> The stored procedure is built to do :
>> 1- insert into a table
>> 2- get last id inserted and return it in a select statement ( select
>> last_inserted_id(); )
>> And the PHP is located in to computers the first is a 5.2.3 which is
>> the Dev Server and other is an 5.2.0-8 in the Production server but so
>> far both has the same problem.
>> Thanks for all the help.
>
>somewhere, somehow, your sql statements are out of order; maybe not inside the
>procedure but around the code that calls the procedure.

I believe it is not the *SQL STATEMENTS* that are out of order, but
the calls to the API functions that are out of order. One example
would be fetching a result set before executing a query. Another
example might be issuing a query before at least grabbing the result
set from the previous query.

Report this message

#13: Re: 2014 Commands out of sync; you can"t run this command now

Posted on 2007-07-31 05:21:11 by Shawn Hamzee

== Quote from Gordon Burditt (gordonb.1q6g6@burditt.org)'s article
> >> The stored procedure is built to do :
> >> 1- insert into a table
> >> 2- get last id inserted and return it in a select statement ( select
> >> last_inserted_id(); )
> >> And the PHP is located in to computers the first is a 5.2.3 which is
> >> the Dev Server and other is an 5.2.0-8 in the Production server but so
> >> far both has the same problem.
> >> Thanks for all the help.
> >
> >somewhere, somehow, your sql statements are out of order; maybe not inside the
> >procedure but around the code that calls the procedure.
> I believe it is not the *SQL STATEMENTS* that are out of order, but
> the calls to the API functions that are out of order. One example
> would be fetching a result set before executing a query. Another
> example might be issuing a query before at least grabbing the result
> set from the previous query.
you are right. that is actually what i meant. thanks for clearing that up.
--
POST BY: lark with PHP News Reader

Report this message