CodeCharge Studio
search Register Login  

Visual PHP Web Development

Visually Create Internationalized Web Applications, Web Reports, Calendars, and more.
CodeCharge.com

YesSoftware Forums -> Archive -> CodeCharge.Discussion

 ?How to: filter s_SearchVar between func(field1) and func(field2)

Print topic Send  topic

Author Message
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


   


These are Community Forums for users to exchange information.
If you would like to obtain technical product help please visit http://support.yessoftware.com.

PHP Reports

Visually create Web Reports in PHP, ASP, .NET, Java, Perl and ColdFusion.
CodeCharge.com

Home   |    Search   |    Members   |    Register   |    Login


Powered by UltraApps Forum created with CodeCharge Studio
Copyright © 2003-2004 by UltraApps.com  and YesSoftware, Inc.