I have a simple page that displays a record from the sql server database. One of the fields is a text field and keeps getting truncated at 3980 characters. I searched and saw someone had reported this as a PDO bug so I'm not using PDO anymore, but I'm still getting the truncation. Anyone know about this or have a work around? Here is the code. It's the body field that is a text field. I've checked the field in the database and it definitely has more data than is displayed.
$cn = mssql_connect($myserver, $myuser, $mypwd);
mssql_select_db($mydb, $cn);
$result = mssql_query("select * from emails where id = $emailid", $cn);
$row = mssql_fetch_array($result, MSSQL_ASSOC);
echo "<ul>";
echo "<li><b>Id:</b> " . $row['id'] . "</li>";
echo "<li><b>From:</b> " . $row['mailfrom'] . "</li>";
echo "<li><b>To:</b> " . $row['mailto'] . "</li>";
echo "<li><b>Cc:</b> " . $row['mailcc'] . "</li>";
echo "<li><b>Subject:</b> " . $row['subject'] . "</li>";
echo "<li><b>Date:</b> " . $row['sentdate'] . "</li>";
echo "<li><b>Body:</b><br> " . nl2br($row['body']) . "</li>";
echo "</ul>";
Thanks for any help.
Regards,
Bruce
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
