--------clip--------
$database = "ECBI_DB";
$user = "db2inst1";
$pass = "ibmdb2";
Advertising
$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']."' AND ";
$ask .= "USERS.USER_LOGON1 = '".$User_Logon1."' AND ";
$ask .= "USERS.USER_PASS1 = '".$User_Pass1."' ";
$result=odbc_exec($cid,$ask);
$workaround_fix = 0;
if (odbc_fetch_row($result,++$workaround_fix))
{
$USER_ID = odbc_result($result,USER_ID);
$ECBI_ACCESS = odbc_result($result,ECBI_ACCESS);
$COMPANY_STATUS = odbc_result($result,COMPANY_STATUS);
$TIME_START = odbc_result($result,TIME_START);
$TIME_END = odbc_result($result,TIME_END);
$LOGIN_COUNT = odbc_result($result,LOGIN_COUNT);
}
else $login_status="FAIL";
--------clip--------
Instead of odbc_fetch_row, the other odbc function does the same thing.
--------clip--------
odbc_result_all($result,"class='form' border='2' cellpading='0'
cellspacing='0' bordercolor='#C64839'");
--------clip--------
However, odbc_exec() work great with these two, 1) odbc_num_rows, 2)
odbc_num_fields.
"Jay Blanchard" <[EMAIL PROTECTED]> wrote in message
000901c2747b$ccaffc00$8102a8c0@000347D72515">news:000901c2747b$ccaffc00$8102a8c0@000347D72515...
> [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. So,
> it is a PHP issue.
>
> Is it a PHP bug? What's up with that?????
> [/snip]
>
> Can we see the code involved?
>
> Jay
>
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php