Subject Re: TIME Configuration...
Author luluzynha13
this is what it prints...

adofetchobj Object (
[DATA] => 2007-09-09
[HORA_INICIO1] => 17:39:24
[HORA_FIM1] => 17:39:24
[HORA_INICIO2] => 17:39:24
[HORA_FIM2] => 17:39:24
[HORA_INICIO3] => 17:39:24
[HORA_FIM3] => 17:39:24
[QTD_HE] => 0.5 )

adofetchobj Object (
[DATA] => 2007-09-10
[HORA_INICIO1] => 17:39:24
[HORA_FIM1] => 17:39:24
[HORA_INICIO2] => 17:39:24
[HORA_FIM2] => 17:39:24
[HORA_INICIO3] => 17:39:24
[HORA_FIM3] => 17:39:24
[QTD_HE] => 7.19999980927
)

If you execute the same query in EMS, this is what is shown...

[DATA] => 2007-09-09
[HORA_INICIO1] => 3:00:00 PM
[HORA_FIM1] => 11:30:00 PM
[HORA_INICIO2] => 12:00:00 AM
[HORA_FIM2] => 12:00:00 AM
[HORA_INICIO3] => 12:00:00 AM
[HORA_FIM3] => 12:00:00 AM
[QTD_HE] => 0.5


[DATA] => 2007-09-10
[HORA_INICIO1] => 8:00:00 AM
[HORA_FIM1] => 11:13:00 PM
[HORA_INICIO2] => 12:00:00 AM
[HORA_FIM2] => 12:00:00 AM
[HORA_INICIO3] => 12:00:00 AM
[HORA_FIM3] => 12:00:00 AM
[QTD_HE] => 7.19999980927




So I figure out that the values are being correctly recorded... and
the problem is in retrieving them...

Thank you guys for trying to help me... I have no experience with
database and web programming... Everything is new for me.
any suggestion will be much welcome!


--- In firebird-php@yahoogroups.com, Lester Caine <lsces@...> wrote:
>
> luluzynha13 wrote:
> > //echo $sql;
> > if ($rs = $db->Execute($sql))
> > { while ($o = $rs->FetchNextObject()) {
>
> Drop in a
> print_r($o);
> And see what is actually in the $o array.
> Check the case of the field names ;)
>
> --
> Lester Caine - G8HFL
> -----------------------------
> Contact - http://home.lsces.co.uk/lsces/wiki/?page=contact
> L.S.Caine Electronic Services - http://home.lsces.co.uk
> MEDW - http://home.lsces.co.uk/ModelEngineersDigitalWorkshop/
> Firebird - http://www.firebirdsql.org/index.php
>