Full data not being displayed

[ober0330]

I'm using the following to grab some data:

    $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.

[ober0330]

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.