SQL query not working w/ number columns

wacook

When using a SQL query I get no errors if the fields selected are "text" fields, or number fields with few digits. If I include a "number" field with many digits in the select script I get "Premature end of script headers: c:/php/php.exe" in my error log.

The script works great as long as no numeric fields are in the select line.

I noticed that the columns that do not work have data like 0.03336698532

If I try a column with data like 0.005 this numeric column works.

$SQL="select Test_Date, SerialNumber, Part, Platform, Machine ";
///the above line works if no number fields(or small number of digits in a numeric field) are in it. If I put a number field (that has many digits) in it php bombs.

$SQL="$SQL from gagedata";
$SQL="$SQL where Test_Date = '$sent_datetime'";
$SQL="$SQL and";
$SQL="$SQL Machine like '$mach'";

$result=mssql_query($SQL);

😉

Sxooter

This sounds like a bug in php or mysql. What versions of each are you running?

wacook

php 4.2.2 and microsoft sql 6.5

Sxooter

Are you using freetds or odbc?

Can you switch from one to the other and see if the problem goes away?

Generally, when you see a premature end of headers, the php script crashed and didn't complete delivery of all the info it was sending, and this is usually a problem in php or one of it's built in function libs.

wacook

Are you using freetds or odbc?

I don't know I a have the following connection string set up.

$table = "tablename";
$dbh = mssql_connect("$plant","username","password");
mssql_select_db("database",$dbh);

I think it is odbc but I do not know..

Sxooter

You're using the TDS/MSSQL connector. Try connecting with odbc and see if the same problem comes up. There should be a short section of the PHP manual on the odbc connector (hopefully your server is configured for odbc operation)

wacook

$SQL="$SQL from gagedata";
$SQL="$SQL where Test_Date = '$sent_datetime'";
$SQL="$SQL and";
$SQL="$SQL Machine like '$mach'";

$result=mssql_query($SQL);

If I use a numeric field and convert it as part of the SQL call it works fine. Example that works::::

$SQL="select Test_Date, convert(varchar,height) as height, Part, Platform, Machine ";
// Notice the above converts the SQL data prior to bringing it back from the server. This allows the php mssql software to process it.

$SQL="$SQL from gagedata";
$SQL="$SQL where Test_Date = '$sent_datetime'";
$SQL="$SQL and";
$SQL="$SQL Machine like '$mach'";

$result=mssql_query($SQL);

Thnks for your help.

I didn't try converting every thing to ODBC but I think that would have worked as well.