Posted by Thorak on 10/24/06 14:41

//---------------------------------------------------
//--------------------------------------------

# SQL Statement.
$qry = 'SELECT OD.OrderID,
OD.CustomerID,
OD.SalePersonID,
OD.DueDate,
OD.DueTime,
EMP.EmployeeID,
EMP.FirstName
FROM "Order.DB" OD, "Employee.DB" EMP
WHERE EMP.EmployeeID = OD.SalePersonID;

$qry = odbc_prepare($db, $qry);
$exe_id = odbc_execute($qry);

while(odbc_fetch_row($qry)){

$DueDate = odbc_result($qry,'DueDate');
$DueTime = odbc_result($qry,'DueTime');

}

echo $DueDate.' - '.$DueTime;

Rik wrote:
> Thorak wrote:
> > 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?!
>
> Most likely a problem in the query, which we cannot check when you don't
> give us the info we need, like the query used and the logic afterwards.
>
> Also, have you checked/tried this:
> http://www.php.net/manual/en/ref.paradox.php
>
> --
> Grtz,
>
> Rik Wasmus

[Back to original message]