[Resolved] Truncating return of data

Spudgun

Hi all
Hope you can help with this. I've got a query that pulls comments out of my database, but it seems to be truncating them. My query is :

$query2 = " select * from database where cono='01' and deleted='0' and account='123456' ";
$dbResult2 = mssql_query($query2, $dbLink2);
for($count=1; $row = mssql_fetch_array($dbResult2); ++$count)
{
        	print("<TR CLASS=HEADER-DARK ALIGN=CENTER VALIGN=MIDDLE><TD>$count</TD>");
        print("<TD>$row[1]<BR><A HREF='$page?idx=$row[34]'>$row[2]</A></TD>");
        print("<TD>$row[8] $row[33]<BR>$row[9] $row[10]<BR>$row[11] $row[12]<BR>$row[13] $row[22]<BR>$row[14]</TD>");
        print("<TD>$row[7]<BR>$row[6]<BR>$row[19]</TD>");
        print("<TD>$row[3]</TD>");
        print("<TD>$row[15]</TD>");
        print("<TD>$row[4]</TD>");
        print("<TD>$row[18]</FONT></TD>");
        print("<TD>$row[21]<BR>$row[20]</FONT></TD></TR>");
}

When it pulls the comments out, it is only pulling the first 255 characters. Any ideas why and how I can get it to pull everything out?
Many thanks in advance guys!
Cheers
J

laserlight

maybe you need to store certain data as type TEXT instead?

lanjoky

Whats the Field type in the database??

Spudgun

It's strange laserlight. The db field is set to be varchar with a max length of 8000 charcters - and the data is correct in the db. It's just when returning it to the page, for some reason it is truncating.

Any help would be really appreciated.
Thanks

tsinka

Hi,

there is a post on the online php manual at php.net describing exact the same problem.

To get around it you can use

convert(text,fieldname)

http://si.php.net:8888/manual/en/function.mssql-query.php

It's the post by spotspaperdoll at yahoo dot com to give the credits to the right person 🙂

Spudgun

Thanks Tsinka! You've saved my life here!