Hi all,
I have build several xsp:pages which contain forms holding textboxes and
dropdownboxes. The dropdownboxes are filled with values from a query.
I will explain my problem with a real life example. The form offers a way
to search/filter for, let's say, trouble tickets. A trouble ticket is of a
certain type (incident, change or problem). It also has a severitycode (low,
middle, heavy) and it has a description for example.
Suppose I have a form with two dropdownboxes (ddb)
* ddbType has following options : (SELECT DISTINCT TYPE FROM TROUBLES)
* -- any type
* incident
* change
* problem
* ddbSeverityCode has following options: (SELECT DISTINCT
SEVERITYCODE FROM TROUBLES)
* -- any severity code
* low
* middle
* heavy
* tbDescription (is empty)
Now i want depending of the userinput to run following query :
String MyDynamicQuery = "SELECT TROUBLEID FROM TROUBLES "
<!-- conditional If any parameters are filled in -->
+ " WHERE "
<!-- conditional if ddbType contains valid value (this means not
empty and not starts with '--' -->
TYPE = ?
<!-- conditional if ddbType contains valid value (this means not
empty and not starts with '--' -->
<!-- conditional if ddbSeverityCode contains valid value (this
means not empty and not starts with '--' -->
SEVERITYCODE = ?
<!-- conditional if ddbSeverityCode contains valid value (this
means not empty and not starts with '--' -->
<!-- conditional if tbDescription contains valid value (this means
not empty -->
DESCRIPTION LIKE %?%
<!-- conditional if tbDescription contains valid value (this
means not empty -->
<!-- conditional If any parameters are filled in -->
Did anyone already do some nice work on this issue ?? I'm looking for ways
to do this kind of thing without having to do a lot of coding. Any
suggestions, please post it !!
Robby Pelssers
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
