Justtechjobs.com Find a programming school near you






Online Campus Both


php-windows | 2002071

[PHP-WIN] DB2 ODBC Connections... From: Erik Ableson (eableson <email protected>)
Date: 07/12/02

Well - here's an odd one:

PHP 4.2.1 (win32)
apache 1.3.26
W2K Workstation

Making an ODBC Connection to a DB2 database, everything is working with the
sole exception that it never ever returns any rows. The correct number of
fields are being returned each time, even when the query absolutely requires a
row to be returned.

Code
<?php
class fetch_object
{
        function fetch( $re )
        {
                if( !$re )
                        return null;
                
                $no_f = odbc_num_fields( $re );
                if( odbc_fetch_row( $re ) )
                {
                        for( $i = 1; $i <= $no_f; $i++ )
                        {
                                $fn = odbc_field_name( $re, $i );
                                $f_re = odbc_result( $re, $i );
                                $ff = "\$this->$fn = \"" . addslashes( $f_re ) .
"\";";
                                eval( $ff );
                        }
                }
                else
                        return null;
        }
}

function odbc_fetch_object( $result )
{
        $good = new fetch_object;
        $good->fetch( $result );
        return $good;
}

$dbconn = odbc_connect ( "DSN", "USER", "PASSWORD");

echo "Connected to: $dbconn<br>";
# $sqlresult = odbc_exec( $dbconn, "SELECT ATTR_NM, NEW_VALUE FROM RU99.RC548
WHERE SIGNONID = 'L6XJ'");
$sqlresult = odbc_exec( $dbconn, "SELECT COUNT(*) AS TOTAL FROM RU99.RC545
WHERE SIGNONID='L6XJ'");
echo $sqlresult . "<BR>";

$mycursor = odbc_cursor ( $sqlresult);
echo $mycursor . "<BR>";

echo "Fields: " . odbc_num_fields ($sqlresult);
echo "Rows: " . odbc_num_rows ($sqlresult);

while ($row = odbc_fetch_object ($sqlresult) ) {
        echo $row->ATTR_NM . "<BR>" ;
        echo $row->NEW_VALUE . "<BR>";
}

odbc_close($dbconn);

?>

Output:
Connected to: Resource id #1
Resource id #2
SQLLF0004
Fields: 1 Rows: 0 

-- 
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php