Re: Sorry, answered too quick [waas: SET in MSSQL-query]

Textsize and textlimit are connected. Textsize can be set to any value from 0 to textlimit and text limit can be any value from 0 to 2Gb (on 32 bit API) By default textsize and textlimit are set according to your server and library settings but if you have textlimit = 8192 in php.ini you will not be able to use a higher value. Textlimit can not be set with a SET command, you have to configure the value in php.ini or setting the value on the server. The next version of php_mssql70.dll includes a new function mssql_setopt() allowing you to set this an 17 other options from the script. - Frank >Hello Flint, > >Sorry for the previous reply, it was too fast. I'll try again the SET and SELECT in one >query. > >Thanks again, >Thomas > > >Flint Doungchak wrote: > >> Thomas, >> >> There has been some recent discussion on the list on this topic so my >> information may be dated. However, the latest (or the last few) release of >> the php_mssql70.dll module allows you to set the textsize in the php.ini >> file. >> >> The sample ini file released with php4 shows an example of the syntax. >> >> -Flint >> >> -----Original Message----- >> From: Thomas [mailto:Yin.Yang@gmx.net] >> Sent: Monday, January 08, 2001 5:58 AM >> To: php-windows@lists.php.net >> Subject: [PHP-WIN] SET in MSSQL-query >> >> Hello! >> >> If I want to change e.g. the textsize with SET TEXTSIZE 16384, it is no >> problem in the qury-analyzer. >> >> If I want to do it in script with >> mssql_query( "SET TEXTSIZE 16384", $db ); >> >> and check it in the query- analizer with: >> SELECT @@TEXTSIZE >> >> it has still the old value. >> >> What do I wrong? >> >> 2nd questiion: How can I get the result of "SELECT @@TEXTSIZE" in a >> php-script? >> >> Many thanks, >> Thomas >> >> -- >> PHP Windows Mailing List (http://www.php.net/) >> To unsubscribe, e-mail: php-windows-unsubscribe@lists.php.net >> For additional commands, e-mail: php-windows-help@lists.php.net >> To contact the list administrators, e-mail: php-list-admin@lists.php.net >> >> -- >> PHP Windows Mailing List (http://www.php.net/) >> To unsubscribe, e-mail: php-windows-unsubscribe@lists.php.net >> For additional commands, e-mail: php-windows-help@lists.php.net >> To contact the list administrators, e-mail: php-list-admin@lists.php.net > > >-- >PHP Windows Mailing List (http://www.php.net/) >To unsubscribe, e-mail: php-windows-unsubscribe@lists.php.net >For additional commands, e-mail: php-windows-help@lists.php.net >To contact the list administrators, e-mail: php-list-admin@lists.php.net > > >