Link to home
Start Free TrialLog in
Avatar of Bruce Gust
Bruce GustFlag for United States of America

asked on

What is this? I've never seen this...

I'm updating some deprecated code but I've never seen this:

mssql_query("SET TEXTSIZE 2147483647")

Here's what it looks like in context...

$query ="SELECT highlightcolor FROM onecommunity.dbo.tblprogram WHERE programid IN (SELECT programid FROM onecommunity.dbo.tblprogramtoparticipant WHERE participantid = $participantid)";
$result = mssql_query($query, $con);

$num = mssql_num_rows($result);

$highlightcolor = '#0074BA'; // default blue, in case there is no color set;

if($num==0) {
	echo 'no program color found';
	return;
}

$highlightcolor = mssql_result($result, 0, 'highlightcolor');


mssql_query("SET TEXTSIZE 2147483647");

Open in new window


Is it the equivalent to simply setting a variable?

What do you think?
ASKER CERTIFIED SOLUTION
Avatar of zephyr_hex (Megan)
zephyr_hex (Megan)
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Bruce Gust

ASKER

Got it!

And for anyone coming after me, this site shows a good example: https://www.interfacett.com/blogs/using-textsize-limit-amount-text-displayed-select-statement-sql-server/

Thanks, zephyr!