I'm having trouble executing queries using odbc. Here's what I use:
define("NEED_REPLY", true);
$con = 0;
function con()
{
$con = odbc_connect("rest","DBA","SQL");
odbc_autocommit($con, true);
}
function query($query, $reply_expected = false)
{
$reply = odbc_exec($con, $query);
i
When I try to do the two seperate SQL command with the 2nd odbc execution
right after the 1st odbc execution. It work fine. Weird!!
--clip--
//SQL Command #1
$ask = "SELECT * FROM CUSTOMERS ";
$ask .= "WHERE CUSTOMERS.CUSTOMER_ID = '".$_POST['Customer_Id']."'";
//SQL Command #2
clip
$database = "ECBI_DB";
$user = "db2inst1";
$pass = "ibmdb2";
$cid = @odbc_connect($database,$user,$pass) or die("Unable to connect to
Database !!!") ;
$ask = "SELECT * FROM CUSTOMERS, USERS ";
$ask .= "WHERE CUSTOMERS.CUSTOMER_ID = '".$_POST['Customer_Id']."
[snip]
With odbc_exec() function, it is able to execute and retrieve the data
pretty well. Unfortunately, when the number of fields grow and grow then
the odbc_exec() return false and a blank data. I don't get it! When I run
the SQL command through the database interface, it work like a charm.
[snip]
With odbc_exec() function, it is able to execute and retrieve the data
pretty well. Unfortunately, when the number of fields grow and grow then
the odbc_exec() return false and a blank data. I don't get it! When I run
the SQL command through the database interface, it work like a charm.
With odbc_exec() function, it is able to execute and retrieve the data
pretty well. Unfortunately, when the number of fields grow and grow then
the odbc_exec() return false and a blank data. I don't get it! When I run
the SQL command through the database interface, it work like a charm. So,
it
For the odbc_exec(), is there a way to validate whether this return a true
or false. If false, then the error message?
I really hate PHP_SELF now, this one web page is written to be repeated 3
times. With the global register turned off, everything was really a mess
and I'm close to being done i
From: Scott Fletcher [mailto:[EMAIL PROTECTED]]
> > Sent: Wednesday, April 18, 2001 9:37 AM
> > To: [EMAIL PROTECTED]
> > Subject: [PHP] New problem with PHP "odbc_exec".
> >
> >
> > Hi! I don't understand why PHP is having trouble with the
> >
//www.openlinksw.com
> -Original Message-
> From: Scott Fletcher [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, April 18, 2001 9:37 AM
> To: [EMAIL PROTECTED]
> Subject: [PHP] New problem with PHP "odbc_exec".
>
>
> Hi! I don't understand why PHP is having
[From BugDB]
ID: 10375
Updated by: kalowsky
Reported By: [EMAIL PROTECTED]
Old-Status: Open
Status: Closed
Bug Type: Reproduceable crash
PHP Version: 4.0.4pl1
Assigned To:
Comments:
fixed in cvs, will not be in 4.0.5, but later releases.
Previous Comments:
---
Hi! I don't understand why PHP is having trouble with the odbc_exec. Is
there a bug in PHP code? Here's what the error messages said!
"SQL error: [OpenLink][ODBC][Driver]No key columns found for table
referenced by keyset driven cursor., SQL state IM909 in SQLExecDirect".
This show that
11 matches
Mail list logo
