Bruce Gust
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...
Is it the equivalent to simply setting a variable?
What do you think?
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");
Is it the equivalent to simply setting a variable?
What do you think?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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!