PHP-ODBC-MSSQL (Text type fields)

From: Date: Tue, 10 Jul 2001 21:34:38 +0000
Subject: PHP-ODBC-MSSQL (Text type fields)
Groups: php.db 
Request: Send a blank email to php-db+get-10233@lists.php.net to get a copy of this message
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@globalocity.com -------------------------------- Globalocity B.V. Tel.: +31 (0)70 312 2814 Fax.: +31 (0)70 312 2808 http://www.globalocity.com e-mail: info@globalocity.com --------------------------------

« previous php.db (#10233) next »