WebDB call a Report from Calendar

From: Greg <actiris_at_loxinfo.co.th>
Date: 2000/06/13
Message-ID: <3945EAEE.140163F7_at_loxinfo.co.th>#1/1


I have call a form from a Calendar to a report Calendar select

select

    START_DAT,
    WHO ||'<BR>'|| WHAT ||'<BR>'|| WHERE,

'BGV.R_EVENT_DETAIL.show?p_arg_names=T_EVENT.START_DAT&p_arg_values='||START_DAT as name_link,

    null,
    null as frame
from BGV.T_EVENT
order by T_EVENT.START_DAT

web call:
http://act01/WebDB/BGV.R_EVENT_DETAIL.show?p_arg_names=T_EVENT.START_DAT&p_arg_values=12-DEC-00

But in the START_DAT field I have also a time saved like
to_date(12.12.2000 19:30, 'DD.MM.YYYY HH24:MI')

but the link finds no records bec of the time

if I save the date like
to_date(12.12.2000 00:00, 'DD.MM.YYYY HH24:MI') or
to_date(12.12.2000, 'DD.MM.YYYY')

then the link works

is there a way to send the date and the time to the query

or do I have to make a new field in the Table for the Time.

hope works whit out.......

tanks alot Greg Received on Tue Jun 13 2000 - 00:00:00 CEST

Original text of this message