Subject | Re: TIME Configuration... |
---|---|
Author | luluzynha13 |
Post date | 2007-08-14T16:26:53Z |
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!
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
>