Full data not being displayed
I'm using the following to grab some data:
PHP Code:
$query = "SELECT * From [Nonconformance Datasheet] WHERE ID = " . $_REQUEST['ID'];
$result = mssql_query($query) or die ("<br/><br/><p class=warn>There was a problem with the SQL query.");
$row = @mssql_fetch_array($result);
Then I echo the fields using " echo $row['fieldname'] ". I have one field that is greater than 255 chars, but when I display it using the above code, it only shows 255 chars. Does anyone know why this might be happening? It's driving me crazy.
Re: Full data not being displayed
I was told on another board that this is a problem with the mssql php libraries and I was pretty much SOL. The only solution was to use ADO or ODBC, so I used ADO to connect and grab the fields that mattered. That seems to work, but it sucks.
