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.
4 matches
Mail list logo
