| Thorak 2006-10-30, 7:02 pm |
| I cant seem to get my odbc_result to work with a Paradox database TIME
field. My result always comes back as a date of 1899-12-30.... this is
driving me nuts, thats not a time... thats a date! It also always
returns the exact same date even if the time is different. All the
other odbc_results return the proper information..... just not the TIME
field.
Does anyone know what is going on?!
(This DB was not created by me, so i have to work with the existing
system. Paradox doesnt seem to have a Date/Time field. It seems to be
seperated into two types... DATE or TIME). When I open the Database
using Paradox Viewer i see a value in the TIME field as 04:00:00 pm.
I changed the value of the first data record to be 01:00:00pm to see if
the result from PHP would change to a different date.... but it was the
same date.
Im using PHP 4 (and cant change to 5 to use the Paradox DB PEAR
library)
my code:
//-----------------------------------------------
$db=odbc_connect($ODBC_name,$ODBC_user,$
ODBC_pass) or die ("Could not
connect");
# SQL Statement.
$qry = 'SELECT OD.OrderID,
OD.CustomerID,
OD.CustomerName,
OD.Description,
OD.OrdererFirstName,
OD.OrdererLastName,
OD.OrdererPareaCode,
OD.OrdererPhoneNumber,
OD.OrdererPhoneExtention,
OD.OrdererFaxNumber,
OD.OrdererEmailAddress,
OD.SalePersonID,
OD.Status,
OD.OnHold,
OD.DueDate,
OD.DueTime,
OD.ProofDate,
OD.OrderNotes,
OD.SalesTotal,
EMP.EmployeeID,
EMP.FirstName
FROM "Order.DB" OD, "Employee.DB" EMP
WHERE EMP.EmployeeID = OD.SalePersonID
AND OD.Status NOT LIKE 'Closed'
AND OD.Status NOT LIKE 'Voided'
AND OD.Status NOT LIKE 'Built'
AND OD.Status NOT LIKE 'Picked-Up'
AND EMP.FirstName LIKE ''.$_SESSION['CSR'].''
ORDER BY OD.DueDate, EMP.FirstName, OD.OrderID';
$qry = odbc_prepare($db, $qry);
$exe_id = odbc_execute($qry);
while(odbc_fetch_row($qry)){
// Define vars
//----------------------
$OrderID = odbc_result($qry, 'OrderID');
$CustomerID = odbc_result($qry, 'CustomerID');
$CustomerName = odbc_result($qry, 'CustomerName');
$OrderNotes = odbc_result($qry, 'OrderNotes');
$Description = odbc_result($qry, 'Description');
$OrdererFirstName = odbc_result($qry, 'OrdererFirstName');
$OrdererLastName = odbc_result($qry, 'OrdererLastName');
$OrdererPhoneNumberArea = odbc_result($qry,
'OrdererPareaCode');
$OrdererPhoneNumber = odbc_result($qry, 'OrdererPhoneNumber');
$OrdererFaxNumber = odbc_result($qry, 'OrdererFaxNumber');
$OrdererEmailAddress = odbc_result($qry,
'OrdererEmailAddress');
$Status = odbc_result($qry, 'Status');
$DueDate = odbc_result($qry,'DueDate');
$DueTime = odbc_result($qry,'DueTime');
$ProofDate = odbc_result($qry,'ProofDate');
$SalePersonID = odbc_result($qry, 'SalePersonID');
$SalePerson = odbc_result($qry, 'FirstName');
$SalesTotal = odbc_result($qry, 'SalesTotal');
var_dump($DueDate);
var_dump($DueTime);
}
Echo RESULTS:
string(10) "2006-06-15"
string(10) "1899-12-30"
string(10) "2006-07-07"
string(10) "1899-12-30"
string(10) "2006-08-21"
string(10) "1899-12-30"
string(10) "2006-08-23"
string(10) "1899-12-30"
string(10) "2006-09-08"
string(10) "1899-12-30"
string(10) "2006-09-13"
string(10) "1899-12-30"
|