RE: [PHP-DB] Text Field in SQL Server
I got it: In php.ini there is a setting for ODBC called odbc.defaultlrl, if you change it to 0 it will hand over everything. Ryan -Original Message- From: Ryan Jameson (USA) Sent: Wednesday, May 15, 2002 4:17 PM To: [EMAIL PROTECTED] Subject: [PHP-DB] Text Field in SQL Server When I make a field of Text type (MS SQL Server) and attempt to retrieve it from the database using PHP ODBC I don't get the whole thing. Anyone have any ideas? Thanks. Ryan -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] Text Field in SQL Server
BTW: 0 wasn't the right answer, but I get by with 10. :-) -Original Message- From: Ryan Jameson (USA) Sent: Wednesday, May 15, 2002 4:27 PM To: [EMAIL PROTECTED] Subject: RE: [PHP-DB] Text Field in SQL Server I got it: In php.ini there is a setting for ODBC called odbc.defaultlrl, if you change it to 0 it will hand over everything. Ryan -Original Message- From: Ryan Jameson (USA) Sent: Wednesday, May 15, 2002 4:17 PM To: [EMAIL PROTECTED] Subject: [PHP-DB] Text Field in SQL Server When I make a field of Text type (MS SQL Server) and attempt to retrieve it from the database using PHP ODBC I don't get the whole thing. Anyone have any ideas? Thanks. Ryan -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: RE: [PHP-DB] Text Field in SQL Server
You can actually control this on the fly. odbc_binmode($iRecordSet, 2); odbc_longreadlen($iRecordSet, 4096); $str = ; while ($temp = odbc_result($iRecordSet, COLUMN_NAME)) $str .= $temp; This will set the block size to 4k and when you fetch data until the entire column has ben fetched. - Frank BTW: 0 wasn't the right answer, but I get by with 10. :-) -Original Message- From: Ryan Jameson (USA) Sent: Wednesday, May 15, 2002 4:27 PM To: [EMAIL PROTECTED] Subject: RE: [PHP-DB] Text Field in SQL Server I got it: In php.ini there is a setting for ODBC called odbc.defaultlrl, if you change it to 0 it will hand over everything. Ryan -Original Message- From: Ryan Jameson (USA) Sent: Wednesday, May 15, 2002 4:17 PM To: [EMAIL PROTECTED] Subject: [PHP-DB] Text Field in SQL Server When I make a field of Text type (MS SQL Server) and attempt to retrieve it from the database using PHP ODBC I don't get the whole thing. Anyone have any ideas? Thanks. Ryan -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] Text Field in SQL Server
So I can retrieve it in 4k pieces? That's cool. Thanks! Ryan -Original Message- From: Frank M. Kromann [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 15, 2002 4:37 PM To: Ryan Jameson (USA) Cc: [EMAIL PROTECTED] Subject: Re: [PHP-DB] Text Field in SQL Server You can actually control this on the fly. odbc_binmode($iRecordSet, 2); odbc_longreadlen($iRecordSet, 4096); $str = ; while ($temp = odbc_result($iRecordSet, COLUMN_NAME)) $str .= $temp; This will set the block size to 4k and when you fetch data until the entire column has ben fetched. - Frank BTW: 0 wasn't the right answer, but I get by with 10. :-) -Original Message- From: Ryan Jameson (USA) Sent: Wednesday, May 15, 2002 4:27 PM To: [EMAIL PROTECTED] Subject: RE: [PHP-DB] Text Field in SQL Server I got it: In php.ini there is a setting for ODBC called odbc.defaultlrl, if you change it to 0 it will hand over everything. Ryan -Original Message- From: Ryan Jameson (USA) Sent: Wednesday, May 15, 2002 4:17 PM To: [EMAIL PROTECTED] Subject: [PHP-DB] Text Field in SQL Server When I make a field of Text type (MS SQL Server) and attempt to retrieve it from the database using PHP ODBC I don't get the whole thing. Anyone have any ideas? Thanks. Ryan -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php