Hello Folks,
i have a table with 2 columns (name, timestamp) name is varchar, timestamp is TIMESTAMP (Oracle 9.2i Enterprise)
I want to create a prompt page with 3 dropdowns:
1. all distinct names (works fine, set to autosubmit) parameter: ?name?
2. all timestamps for the name selected at 1. dropdown (works fine) parameter: ?t1?
3. all timestamps that are older than the timestamp selected in 2. parameter ?t2?
when i get to select the first timestamp (2. dropdown), the third dropdown always stays empty (data is ok, and should be displayed)
the 3. dropdown uses the parameter of the first. there are two filters in this query, one for the name-parameter , something like [name]=?name? and a second one [timestamp] < ?t1?
i think reportnet messes around with the timestamp column in the way, data is compared.
if i check the generated sql it says something like
select distinct "C__en__T_TEST"."UNC_PATH" AS "UNC_PATH", "C__en__T_TEST"."T_STAMP" AS "T_STAMP", "C__en__T_TEST"."T_STAMP" AS "T_STAMP1"
from "gosldw"."dbo"."T_TEST" "C__en__T_TEST"
where "C__en__T_TEST"."UNC_PATH" = 'testValue' and {ts '2000-01-01 00:00:00.000'} > "C__en__T_TEST"."T_STAMP"
this is a MSSQL 2000 Server Test-System. Normally, when the t1 value is filled in, it should work.
can anyone help?
thanks a lot,
cheers
-pw