Justtechjobs.com Find a programming school near you






Online Campus Both


php-db | 2001071

[PHP-DB] PHP-ODBC-MSSQL (Text type fields) From: Michael Yevdokimov (michaely <email protected>)
Date: 07/10/01

Hello

Did anybody have problems with retrieving data from the fields of type
Text..

<?php
$dsn = "dsn_database";
$user = "enduser";
$pass = "";

$query = "usp_get_subj 10";

$conn = odbc_connect($dsn, $user, $pass);
$res = odbc_exec($conn, $query);

while (odbc_fetch_row($res)) {
        //$data = odbc_field_type($res, 10); // text
        //$data = odbc_field_name($res, 10); // col_subj_content
        //$data = odbc_field_len($res, 10); // 2147483647

        $data = odbc_result($res, "col_subj_content");
        //$data = odbc_result($res, 10);

        echo $data;
}

odbc_close($conn);
?>

I can retrieve any other fields but not the field of type text.. What could
be the problem?

Thank you.

Mike

Michael Yevdokimov
Web developer
e-mail: michaely <email protected>

--------------------------------
Globalocity B.V.
Tel.: +31 (0)70 312 2814
Fax.: +31 (0)70 312 2808
http://www.globalocity.com
e-mail: info <email protected>
-------------------------------- 

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: php-db-unsubscribe <email protected>
For additional commands, e-mail: php-db-help <email protected>
To contact the list administrators, e-mail: php-list-admin <email protected>