472,796 Members | 1,460 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,796 software developers and data experts.

Commands out of sync error

I'm getting a "2014:: Commands out of sync; you can't run this command
now" error on a php page when I try to call a second stored procedure
against a MySQL db. Does anyone know why I might be getting this
error? The error doesn't occur on my development box where I use the
'root' db user, but does occur in production where I'm using a non-
root user record to establish a connection. I'm essentially opening a
connection at the top of the php page and then calling multiple stored
procedures to fetch data. When I call the 2nd stored procedure I'm
getting the error. Any info would be greatly appreciated.

Aaron
Jan 16 '08 #1
9 2886
Ratfish wrote:
root user record to establish a connection. I'm essentially opening a
connection at the top of the php page and then calling multiple stored
procedures to fetch data. When I call the 2nd stored procedure I'm
getting the error. Any info would be greatly appreciated.
Hi Ratfish,

I think you must free the resultsets from the stored procedures before
opening another one. Look at mysql_free_result if you're using the mysql
extension, or mysqli_stmt_free_result if using the mysqli extension.

Regards,
Marlin Forbes
Data Shaman
datashaman.com
Jan 16 '08 #2
On Jan 16, 12:09 am, Marlin Forbes <"marlinf <ATdatashaman <POINT>
wrote:
Ratfish wrote:
root user record to establish a connection. I'm essentially opening a
connection at the top of the php page and then calling multiple stored
procedures to fetch data. When I call the 2nd stored procedure I'm
getting the error. Any info would be greatly appreciated.

Hi Ratfish,

I think you must free the resultsets from the stored procedures before
opening another one. Look at mysql_free_result if you're using the mysql
extension, or mysqli_stmt_free_result if using the mysqli extension.

Regards,
Marlin Forbes
Data Shaman
datashaman.com
Thanks. I tried adding a call to free_result() before calling
close(), but that did not fix my problem. Any other ideas?

$stmt->free_result();
$stmt->close();

Aaron
Jan 16 '08 #3
Ratfish wrote:
I'm getting a "2014:: Commands out of sync; you can't run this command
now" error on a php page when I try to call a second stored procedure
against a MySQL db. Does anyone know why I might be getting this
error? The error doesn't occur on my development box where I use the
'root' db user, but does occur in production where I'm using a non-
root user record to establish a connection. I'm essentially opening a
connection at the top of the php page and then calling multiple stored
procedures to fetch data. When I call the 2nd stored procedure I'm
getting the error. Any info would be greatly appreciated.

Aaron
Sorry, my crystal ball is in the shop. Since you didn't post any code,
I find it impossible to tell what's wrong.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
js*******@attglobal.net
==================

Jan 16 '08 #4
On Jan 16, 4:06 am, Jerry Stuckle <jstuck...@attglobal.netwrote:
Ratfish wrote:
I'm getting a "2014:: Commands out of sync; you can't run this command
now" error on a php page when I try to call a second stored procedure
against a MySQL db. Does anyone know why I might be getting this
error? The error doesn't occur on my development box where I use the
'root' db user, but does occur in production where I'm using a non-
root user record to establish a connection. I'm essentially opening a
connection at the top of the php page and then calling multiple stored
procedures to fetch data. When I call the 2nd stored procedure I'm
getting the error. Any info would be greatly appreciated.
Aaron

Sorry, my crystal ball is in the shop. Since you didn't post any code,
I find it impossible to tell what's wrong.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstuck...@attglobal.net
==================

Here's the code that fails:

// load the entertainment record
$sql = "call sps_entertainment(?)";
$stmt = $link->prepare($sql);
if ($link->errno) {die($link->errno.":: ".$link->error);}

$stmt->bind_param("i", $EntId);

// execute the statement
$stmt->execute();
if ($link->errno) {die($db->errno.":: ".$link->error);}

//if ($result = $link->store_result()) {
if ($stmt->bind_result($FEntId,
$FCreateDate,
$FCreateUser,
$FModifyDate,
$FModifyUser,
$FEntTypeCode,
$FEntName,
$FURL,
$FPictureQualityCode,
$FPictureResolutionCode,
$FRevenueSourceCode,
$FEntDesc,
$FEntFullDesc,
$FSiteStatusCode,
$FZombiiRatingCode,
$FEntIconId))
{
if ($stmt->fetch())
{
$stmt->free_result();
$stmt->close();
?>
do some html here
<select id="ddlEntIcon" name="ddlEntIcon">
<option value="*" >(Not Specified)</option>
<option value="NEW" >(Upload new image...)</option>
<?php
$sql = "call sps_entertainment_icons()";
$stmt = $link->prepare($sql);
if ($link->errno) {die($link->errno.":: ".$link->error);}
// execute the statement HERE'S WHERE I THINK THE ERROR IS OCCURING!
$stmt->execute();
if ($link->errno) {die($db->errno.":: ".$link->error);}
$stmt->bind_result($EntIconId, $EntIconName);
while ($stmt->fetch())
{
if ($FEntIconId != "" && $FEntIconId == $EntIconId) {
echo "<option value=\"" . $EntIconId . "\" selected>" .
$EntIconName . "</option>\n";
}
else {
echo "<option value=\"" . $EntIconId . "\">" . $EntIconName . "</
option>\n";
}
}
$stmt->free_result();
$stmt->close();
?>
</select>

Jan 16 '08 #5
Ratfish wrote:
On Jan 16, 4:06 am, Jerry Stuckle <jstuck...@attglobal.netwrote:
>Ratfish wrote:
>>I'm getting a "2014:: Commands out of sync; you can't run this command
now" error on a php page when I try to call a second stored procedure
against a MySQL db. Does anyone know why I might be getting this
error? The error doesn't occur on my development box where I use the
'root' db user, but does occur in production where I'm using a non-
root user record to establish a connection. I'm essentially opening a
connection at the top of the php page and then calling multiple stored
procedures to fetch data. When I call the 2nd stored procedure I'm
getting the error. Any info would be greatly appreciated.
Aaron
Sorry, my crystal ball is in the shop. Since you didn't post any code,
I find it impossible to tell what's wrong.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstuck...@attglobal.net
==================


Here's the code that fails:

// load the entertainment record
$sql = "call sps_entertainment(?)";
$stmt = $link->prepare($sql);
if ($link->errno) {die($link->errno.":: ".$link->error);}

$stmt->bind_param("i", $EntId);

// execute the statement
$stmt->execute();
if ($link->errno) {die($db->errno.":: ".$link->error);}

//if ($result = $link->store_result()) {
if ($stmt->bind_result($FEntId,
$FCreateDate,
$FCreateUser,
$FModifyDate,
$FModifyUser,
$FEntTypeCode,
$FEntName,
$FURL,
$FPictureQualityCode,
$FPictureResolutionCode,
$FRevenueSourceCode,
$FEntDesc,
$FEntFullDesc,
$FSiteStatusCode,
$FZombiiRatingCode,
$FEntIconId))
{
if ($stmt->fetch())
{
$stmt->free_result();
$stmt->close();
?>
do some html here
<select id="ddlEntIcon" name="ddlEntIcon">
<option value="*" >(Not Specified)</option>
<option value="NEW" >(Upload new image...)</option>
<?php
$sql = "call sps_entertainment_icons()";
$stmt = $link->prepare($sql);
if ($link->errno) {die($link->errno.":: ".$link->error);}
// execute the statement HERE'S WHERE I THINK THE ERROR IS OCCURING!
$stmt->execute();
if ($link->errno) {die($db->errno.":: ".$link->error);}
$stmt->bind_result($EntIconId, $EntIconName);
while ($stmt->fetch())
{
if ($FEntIconId != "" && $FEntIconId == $EntIconId) {
echo "<option value=\"" . $EntIconId . "\" selected>" .
$EntIconName . "</option>\n";
}
else {
echo "<option value=\"" . $EntIconId . "\">" . $EntIconName . "</
option>\n";
}
}
$stmt->free_result();
$stmt->close();
?>
</select>

OK, what is sps_entertainment returning?

If it's returning more than one row, you need to continue fetching until
they're all returned.

Also, I see if it returns no rows, you're not freeing the result. You
still have to free the result, even if no rows are returned.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
js*******@attglobal.net
==================

Jan 16 '08 #6
On Jan 16, 10:36 am, Jerry Stuckle <jstuck...@attglobal.netwrote:
Ratfish wrote:
On Jan 16, 4:06 am, Jerry Stuckle <jstuck...@attglobal.netwrote:
Ratfish wrote:
I'm getting a "2014:: Commands out of sync; you can't run this command
now" error on a php page when I try to call a second stored procedure
against a MySQL db. Does anyone know why I might be getting this
error? The error doesn't occur on my development box where I use the
'root' db user, but does occur in production where I'm using a non-
root user record to establish a connection. I'm essentially opening a
connection at the top of the php page and then calling multiple stored
procedures to fetch data. When I call the 2nd stored procedure I'm
getting the error. Any info would be greatly appreciated.
Aaron
Sorry, my crystal ball is in the shop. Since you didn't post any code,
I find it impossible to tell what's wrong.
--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstuck...@attglobal.net
==================
Here's the code that fails:
// load the entertainment record
$sql = "call sps_entertainment(?)";
$stmt = $link->prepare($sql);
if ($link->errno) {die($link->errno.":: ".$link->error);}
$stmt->bind_param("i", $EntId);
// execute the statement
$stmt->execute();
if ($link->errno) {die($db->errno.":: ".$link->error);}
//if ($result = $link->store_result()) {
if ($stmt->bind_result($FEntId,
$FCreateDate,
$FCreateUser,
$FModifyDate,
$FModifyUser,
$FEntTypeCode,
$FEntName,
$FURL,
$FPictureQualityCode,
$FPictureResolutionCode,
$FRevenueSourceCode,
$FEntDesc,
$FEntFullDesc,
$FSiteStatusCode,
$FZombiiRatingCode,
$FEntIconId))
{
if ($stmt->fetch())
{
$stmt->free_result();
$stmt->close();
?>
do some html here
<select id="ddlEntIcon" name="ddlEntIcon">
<option value="*" >(Not Specified)</option>
<option value="NEW" >(Upload new image...)</option>
<?php
$sql = "call sps_entertainment_icons()";
$stmt = $link->prepare($sql);
if ($link->errno) {die($link->errno.":: ".$link->error);}
// execute the statement HERE'S WHERE I THINK THE ERROR IS OCCURING!
$stmt->execute();
if ($link->errno) {die($db->errno.":: ".$link->error);}
$stmt->bind_result($EntIconId, $EntIconName);
while ($stmt->fetch())
{
if ($FEntIconId != "" && $FEntIconId == $EntIconId) {
echo "<option value=\"" . $EntIconId . "\" selected>" .
$EntIconName . "</option>\n";
}
else {
echo "<option value=\"" . $EntIconId . "\">" . $EntIconName . "</
option>\n";
}
}
$stmt->free_result();
$stmt->close();
?>
</select>

OK, what is sps_entertainment returning?

If it's returning more than one row, you need to continue fetching until
they're all returned.

Also, I see if it returns no rows, you're not freeing the result. You
still have to free the result, even if no rows are returned.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstuck...@attglobal.net
==================
sps_entertainment returns a single record. I've removed the freeing of
the result outside of the fetch if statement, but am still having the
issue...
Jan 17 '08 #7
Ratfish wrote:
On Jan 16, 10:36 am, Jerry Stuckle <jstuck...@attglobal.netwrote:
>Ratfish wrote:
>>On Jan 16, 4:06 am, Jerry Stuckle <jstuck...@attglobal.netwrote:
Ratfish wrote:
I'm getting a "2014:: Commands out of sync; you can't run this command
now" error on a php page when I try to call a second stored procedure
against a MySQL db. Does anyone know why I might be getting this
error? The error doesn't occur on my development box where I use the
'root' db user, but does occur in production where I'm using a non-
root user record to establish a connection. I'm essentially opening a
connection at the top of the php page and then calling multiple stored
procedures to fetch data. When I call the 2nd stored procedure I'm
getting the error. Any info would be greatly appreciated.
Aaron
Sorry, my crystal ball is in the shop. Since you didn't post any code,
I find it impossible to tell what's wrong.
--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstuck...@attglobal.net
==================
Here's the code that fails:
// load the entertainment record
$sql = "call sps_entertainment(?)";
$stmt = $link->prepare($sql);
if ($link->errno) {die($link->errno.":: ".$link->error);}
$stmt->bind_param("i", $EntId);
// execute the statement
$stmt->execute();
if ($link->errno) {die($db->errno.":: ".$link->error);}
//if ($result = $link->store_result()) {
if ($stmt->bind_result($FEntId,
$FCreateDate,
$FCreateUser,
$FModifyDate,
$FModifyUser,
$FEntTypeCode,
$FEntName,
$FURL,
$FPictureQualityCode,
$FPictureResolutionCode,
$FRevenueSourceCode,
$FEntDesc,
$FEntFullDesc,
$FSiteStatusCode,
$FZombiiRatingCode,
$FEntIconId))
{
if ($stmt->fetch())
{
$stmt->free_result();
$stmt->close();
?>
do some html here
<select id="ddlEntIcon" name="ddlEntIcon">
<option value="*" >(Not Specified)</option>
<option value="NEW" >(Upload new image...)</option>
<?php
$sql = "call sps_entertainment_icons()";
$stmt = $link->prepare($sql);
if ($link->errno) {die($link->errno.":: ".$link->error);}
// execute the statement HERE'S WHERE I THINK THE ERROR IS OCCURING!
$stmt->execute();
if ($link->errno) {die($db->errno.":: ".$link->error);}
$stmt->bind_result($EntIconId, $EntIconName);
while ($stmt->fetch())
{
if ($FEntIconId != "" && $FEntIconId == $EntIconId) {
echo "<option value=\"" . $EntIconId . "\" selected>" .
$EntIconName . "</option>\n";
}
else {
echo "<option value=\"" . $EntIconId . "\">" . $EntIconName . "</
option>\n";
}
}
$stmt->free_result();
$stmt->close();
?>
</select>
OK, what is sps_entertainment returning?

If it's returning more than one row, you need to continue fetching until
they're all returned.

Also, I see if it returns no rows, you're not freeing the result. You
still have to free the result, even if no rows are returned.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstuck...@attglobal.net
==================

sps_entertainment returns a single record. I've removed the freeing of
the result outside of the fetch if statement, but am still having the
issue...
First of all, ensure that it only returns a single result. I've had
SP's return multiple results before when I only expect one. Try calling
it from the MySQL command line, for instance.

Also, you say this is where you "think" the error occurs. Are you sure?
You might be chasing the wrong error. Try adding identifiers to your
error messages to tell you exactly which one is failing.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
js*******@attglobal.net
==================

Jan 17 '08 #8
On Jan 17, 11:40 am, Jerry Stuckle <jstuck...@attglobal.netwrote:
Ratfish wrote:
On Jan 16, 10:36 am, Jerry Stuckle <jstuck...@attglobal.netwrote:
Ratfish wrote:
On Jan 16, 4:06 am, Jerry Stuckle <jstuck...@attglobal.netwrote:
Ratfish wrote:
I'm getting a "2014:: Commands out of sync; you can't run this command
now" error on a php page when I try to call a second stored procedure
against a MySQL db. Does anyone know why I might be getting this
error? The error doesn't occur on my development box where I use the
'root' db user, but does occur in production where I'm using a non-
root user record to establish a connection. I'm essentially opening a
connection at the top of the php page and then calling multiple stored
procedures to fetch data. When I call the 2nd stored procedure I'm
getting the error. Any info would be greatly appreciated.
Aaron
Sorry, my crystal ball is in the shop. Since you didn't post any code,
I find it impossible to tell what's wrong.
--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstuck...@attglobal.net
==================
Here's the code that fails:
// load the entertainment record
$sql = "call sps_entertainment(?)";
$stmt = $link->prepare($sql);
if ($link->errno) {die($link->errno.":: ".$link->error);}
$stmt->bind_param("i", $EntId);
// execute the statement
$stmt->execute();
if ($link->errno) {die($db->errno.":: ".$link->error);}
//if ($result = $link->store_result()) {
if ($stmt->bind_result($FEntId,
$FCreateDate,
$FCreateUser,
$FModifyDate,
$FModifyUser,
$FEntTypeCode,
$FEntName,
$FURL,
$FPictureQualityCode,
$FPictureResolutionCode,
$FRevenueSourceCode,
$FEntDesc,
$FEntFullDesc,
$FSiteStatusCode,
$FZombiiRatingCode,
$FEntIconId))
{
if ($stmt->fetch())
{
$stmt->free_result();
$stmt->close();
?>
do some html here
<select id="ddlEntIcon" name="ddlEntIcon">
<option value="*" >(Not Specified)</option>
<option value="NEW" >(Upload new image...)</option>
<?php
$sql = "call sps_entertainment_icons()";
$stmt = $link->prepare($sql);
if ($link->errno) {die($link->errno.":: ".$link->error);}
// execute the statement HERE'S WHERE I THINK THE ERROR IS OCCURING!
$stmt->execute();
if ($link->errno) {die($db->errno.":: ".$link->error);}
$stmt->bind_result($EntIconId, $EntIconName);
while ($stmt->fetch())
{
if ($FEntIconId != "" && $FEntIconId == $EntIconId) {
echo "<option value=\"" . $EntIconId . "\" selected>" .
$EntIconName . "</option>\n";
}
else {
echo "<option value=\"" . $EntIconId . "\">" . $EntIconName . "</
option>\n";
}
}
$stmt->free_result();
$stmt->close();
?>
</select>
OK, what is sps_entertainment returning?
If it's returning more than one row, you need to continue fetching until
they're all returned.
Also, I see if it returns no rows, you're not freeing the result. You
still have to free the result, even if no rows are returned.
--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstuck...@attglobal.net
==================
sps_entertainment returns a single record. I've removed the freeing of
the result outside of the fetch if statement, but am still having the
issue...

First of all, ensure that it only returns a single result. I've had
SP's return multiple results before when I only expect one. Try calling
it from the MySQL command line, for instance.

Also, you say this is where you "think" the error occurs. Are you sure?
You might be chasing the wrong error. Try adding identifiers to your
error messages to tell you exactly which one is failing.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstuck...@attglobal.net
==================
I've verified that the stored procedure only returns a single result
set.

I'm not sure what you mean by "adding identifiers to your error
messages". Can you elaborate on that?

Aaron
Jan 18 '08 #9
Ratfish wrote:
On Jan 17, 11:40 am, Jerry Stuckle <jstuck...@attglobal.netwrote:
>Ratfish wrote:
>>On Jan 16, 10:36 am, Jerry Stuckle <jstuck...@attglobal.netwrote:
Ratfish wrote:
On Jan 16, 4:06 am, Jerry Stuckle <jstuck...@attglobal.netwrote:
>Ratfish wrote:
>>I'm getting a "2014:: Commands out of sync; you can't run this command
>>now" error on a php page when I try to call a second stored procedure
>>against a MySQL db. Does anyone know why I might be getting this
>>error? The error doesn't occur on my development box where I use the
>>'root' db user, but does occur in production where I'm using a non-
>>root user record to establish a connection. I'm essentially opening a
>>connection at the top of the php page and then calling multiple stored
>>procedures to fetch data. When I call the 2nd stored procedure I'm
>>getting the error. Any info would be greatly appreciated.
>>Aaron
>Sorry, my crystal ball is in the shop. Since you didn't post any code,
>I find it impossible to tell what's wrong.
>--
>==================
>Remove the "x" from my email address
>Jerry Stuckle
>JDS Computer Training Corp.
>jstuck...@attglobal.net
>==================
Here's the code that fails:
// load the entertainment record
$sql = "call sps_entertainment(?)";
$stmt = $link->prepare($sql);
if ($link->errno) {die($link->errno.":: ".$link->error);}
$stmt->bind_param("i", $EntId);
// execute the statement
$stmt->execute();
if ($link->errno) {die($db->errno.":: ".$link->error);}
//if ($result = $link->store_result()) {
if ($stmt->bind_result($FEntId,
$FCreateDate,
$FCreateUser,
$FModifyDate,
$FModifyUser,
$FEntTypeCode,
$FEntName,
$FURL,
$FPictureQualityCode,
$FPictureResolutionCode,
$FRevenueSourceCode,
$FEntDesc,
$FEntFullDesc,
$FSiteStatusCode,
$FZombiiRatingCode,
$FEntIconId))
{
if ($stmt->fetch())
{
$stmt->free_result();
$stmt->close();
?>
do some html here
<select id="ddlEntIcon" name="ddlEntIcon">
<option value="*" >(Not Specified)</option>
<option value="NEW" >(Upload new image...)</option>
<?php
$sql = "call sps_entertainment_icons()";
$stmt = $link->prepare($sql);
if ($link->errno) {die($link->errno.":: ".$link->error);}
// execute the statement HERE'S WHERE I THINK THE ERROR IS OCCURING!
$stmt->execute();
if ($link->errno) {die($db->errno.":: ".$link->error);}
$stmt->bind_result($EntIconId, $EntIconName);
while ($stmt->fetch())
{
if ($FEntIconId != "" && $FEntIconId == $EntIconId) {
echo "<option value=\"" . $EntIconId . "\" selected>" .
$EntIconName . "</option>\n";
}
else {
echo "<option value=\"" . $EntIconId . "\">" . $EntIconName . "</
option>\n";
}
}
$stmt->free_result();
$stmt->close();
?>
</select>
OK, what is sps_entertainment returning?
If it's returning more than one row, you need to continue fetching until
they're all returned.
Also, I see if it returns no rows, you're not freeing the result. You
still have to free the result, even if no rows are returned.
--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstuck...@attglobal.net
==================
sps_entertainment returns a single record. I've removed the freeing of
the result outside of the fetch if statement, but am still having the
issue...
First of all, ensure that it only returns a single result. I've had
SP's return multiple results before when I only expect one. Try calling
it from the MySQL command line, for instance.

Also, you say this is where you "think" the error occurs. Are you sure?
You might be chasing the wrong error. Try adding identifiers to your
error messages to tell you exactly which one is failing.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstuck...@attglobal.net
==================

I've verified that the stored procedure only returns a single result
set.

I'm not sure what you mean by "adding identifiers to your error
messages". Can you elaborate on that?

Aaron
You indicated you "think" the error occurs in one place. But all you're
doing is putting out the error number and message, so you don't know for
sure.

Add unique text to each message so you know for sure which one had the
problem.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
js*******@attglobal.net
==================

Jan 19 '08 #10

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
by: Will Seay | last post by:
At the end of this message I've pasted a script we're trying to modify slightly. I don't believe it is VBscript or javascript but these are the closest groups I could find with my limited...
0
by: Free Grafton | last post by:
We are currently running about 50 databases on MySQL 4.0.14. Occasionally our users will get the error: Couldn't select database. Message: Commands out of sync; You can't run this command now...
1
by: kartik | last post by:
I open an fstream in read-only mode, read till the end, then try to sync() before seeking to position 0 & reading again. But the sync fails. I discovered that clear()ing the stream before the sync...
1
by: xtra | last post by:
Hi Folk I have written a module that allows you to type a bunch of commands in the immediate window, for quick access to information when you are creating VB code. Here it is, it may be helpful...
0
by: njord | last post by:
Hi, I try to use mysqli through ADODB to connect to my MySQL (5.0.15) database. I try to execute such a part of code: $date = $this->db->Execute("call get_date()")->FetchObj->value; and...
8
by: Michael.Guppenberger | last post by:
Hello everyone, I am currently trying to create a materialized query table which should be in-sync all the time. So my first attempt was to use the "REFRESH IMMEDIATE" option of the create table...
8
by: yaguirre | last post by:
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...
7
by: john | last post by:
I am reading TC++PL3 and on page 644 it is mentioned: "Flushing an istream is done using sync(). This cannot always be done right. For some kinds of streams, we would have to reread characters...
4
by: Eran.Yasso | last post by:
Hi all, I am trying to write application which runs on my PC that sends data to an application running on Windows mobile. The problem is that the tcp over activesync doesn't work. The device is...
0
by: erikbower65 | last post by:
Using CodiumAI's pr-agent is simple and powerful. Follow these steps: 1. Install CodiumAI CLI: Ensure Node.js is installed, then run 'npm install -g codiumai' in the terminal. 2. Connect to...
0
by: erikbower65 | last post by:
Here's a concise step-by-step guide for manually installing IntelliJ IDEA: 1. Download: Visit the official JetBrains website and download the IntelliJ IDEA Community or Ultimate edition based on...
0
by: kcodez | last post by:
As a H5 game development enthusiast, I recently wrote a very interesting little game - Toy Claw ((http://claw.kjeek.com/))。Here I will summarize and share the development experience here, and hope it...
2
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Sept 2023 starting at 18:00 UK time (6PM UTC+1) and finishing at about 19:15 (7.15PM) The start time is equivalent to 19:00 (7PM) in Central...
0
by: Taofi | last post by:
I try to insert a new record but the error message says the number of query names and destination fields are not the same This are my field names ID, Budgeted, Actual, Status and Differences ...
0
by: Rina0 | last post by:
I am looking for a Python code to find the longest common subsequence of two strings. I found this blog post that describes the length of longest common subsequence problem and provides a solution in...
0
by: lllomh | last post by:
Define the method first this.state = { buttonBackgroundColor: 'green', isBlinking: false, // A new status is added to identify whether the button is blinking or not } autoStart=()=>{
0
by: Mushico | last post by:
How to calculate date of retirement from date of birth
2
by: DJRhino | last post by:
Was curious if anyone else was having this same issue or not.... I was just Up/Down graded to windows 11 and now my access combo boxes are not acting right. With win 10 I could start typing...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.