Ask questions. Get answers. Find technical product solutions from passionate experts in the NXLog community.
SQL_Fetch not getting the info in the DB
YvanG created
Hi,
This is my sql_fetch command :
$Retval = sql_fetch("SELECT ServerName, Transmission FROM dbo.SrvAuth WHERE ServerName = ?", $MachineCourt);
This command does find the right record based on ServerName but it is always putting the second field, $Transmission, to the value FALSE.
Here is the MS SQL table definition :
Colum Name Data Type Allow Nulls
ServerName varchar(50) Unchecked
Transmission bit Unchecked
Depending of the record that it is fetch, the DB contains about a third of TRUE and 2 third of FALSE for the Transmission field.
Question :
Why do I always fetch FALSE for the Transmission field?
Thanks
YvanG created