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: [EMAIL PROTECTED] -------------------------------- Globalocity B.V. Tel.: +31 (0)70 312 2814 Fax.: +31 (0)70 312 2808 http://www.globalocity.com e-mail: [EMAIL PROTECTED] -------------------------------- -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]