Peter Hiemenz
|
Posted: 10/01/2002, 10:46 AM |
|
I want to setup a filter which uses a database conversion function
Search Filter to search rows in a range of years comparing to an oracle date
attribute:
Name: Year
Variable: s_Year
Database attributes: dttmstart (startdate) dttmend (enddate)
Database: Oracle (9.2)
Language: ASP.NET (C#)
Where clause to create: <s_year> between to_char(dttmstart, 'YYYY') and
to_char(dttmend, 'YYYY')
=> example: "2000 beween to_char(dttmstart,'YYYY') and to_char(dttmend,
'YYYY')
I tried to set up a search using "expression" and different parameters but
never succeeded. Also tried to directly code in <table>_listDataProvider.cs.
But how can I get the contents of a search Form variable??
TIA,
PH
|
|
|
|