[PHP] mssql_fetch_row - result array returns only 255 chars in one value
hey, i've the following problem. I start a query and get a result If I list this result list($value) = mssql_fetch_row($result); the value in the databasetable is a string value with over 255 characters but the value in the listed $value has only 255 characters. How to get the value from databasetable with all 280 characters?? Christian mailto:[EMAIL PROTECTED] http://www.packdata.net -- PHP General 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]
RE: [PHP] mssql_fetch_row - result array returns only 255 chars in one value
i 've used the following default definition. the some behavior. my result value is cut at position 255. Christian ; Valid range 0 - 2147483647. Default = 4096. mssql.textlimit = 4096 ; Valid range 0 - 2147483647. Default = 4096. mssql.textsize = 4096 -Original Message- From: Brad S. Jackson [mailto:[EMAIL PROTECTED]] Sent: Freitag, 20. Juli 2001 21:22 To: ckieninger Subject: Re: [PHP] mssql_fetch_row - result array returns only 255 chars in one value Check the settings in the [MSSQL] section of your php.ini file. ckieninger [EMAIL PROTECTED] wrote: hey, i've the following problem. I start a query and get a result If I list this result list($value) = mssql_fetch_row($result); the value in the databasetable is a string value with over 255 characters but the value in the listed $value has only 255 characters. How to get the value from databasetable with all 280 characters?? Christian mailto:[EMAIL PROTECTED] http://www.packdata.net -- PHP General 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]
[PHP] How to build this SQL statement?
Hello, i've to build a SQL Statement from a table with the following resultset table with rows id subid roleid rolebundle name 50 0 0 50.0.0 header1 50 1 0 50.1.0 subheader1 50 2 0 50.2.0 subheader2 50 3 0 50.3.0 subheader3 50 3 1 50.3.1 subheader3.1 50 3 2 50.3.2 subheader3.2 50 4 0 50.4.0 subheader4 50 4 1 50.4.1 subheader4.1 50 4 2 50.4.2 subheader4.2 9 rows SQL statement ??? Resultset id subid roleid rolebundle name 50 1 0 50.1.0 subheader1 50 2 0 50.2.0 subheader2 50 3 1 50.3.1 subheader3.1 50 3 2 50.3.2 subheader3.2 50 4 1 50.4.1 subheader4.1 50 4 2 50.4.2 subheader4.2 6 Rows -- PHP General 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]
RE: [PHP] SQL statement for clearing a table
$query = delete * from table; table is empty mailto:[EMAIL PROTECTED] -Original Message- From: Wilbert Enserink [mailto:[EMAIL PROTECTED]] Sent: Freitag, 22. Juni 2001 14:18 To: [EMAIL PROTECTED] Subject: [PHP] SQL statement for clearing a table Hi all, anybody knows the mysql statement for clearing the contents of a table and lieving the table itself intact? Wilbert - Pas de Deux Van Mierisstraat 25 2526 NM Den Haag tel 070 4450855 fax 070 4450852 http://www.pdd.nl [EMAIL PROTECTED] - -- PHP General 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] -- PHP General 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]
[PHP] RE: Lists are back up
thanks mailto:[EMAIL PROTECTED] http://www.packdata.net -Original Message- From: Rasmus Lerdorf [mailto:[EMAIL PROTECTED]] Sent: Montag, 18. Juni 2001 21:15 To: [EMAIL PROTECTED] Subject: Lists are back up We have re-enabled the PHP mailing lists. They are now running from a temporary machine sitting on the floor of my spare bedroom. A more permanent home is in the works. -Rasmus
