Frank Rocco
|
| Posted: 08/01/2002, 7:07 AM |
|
Hello,
I have a page that has a Search form and a grid.
The search form has a dropdown box of names passing the integer value to the
grid.
The default is Any with a value of blank
The grid has SQL coded to select records based on the value passed from the
Search form.
How can I display all records in the grid when the value is Any?
Thanks
Frank
|
|
|
 |
Geert van der Ploeg
|
| Posted: 08/05/2002, 12:36 AM |
|
add an "OR" statement in your sql:
select blablabla from bloebloebloe where
.... your conditions ...
OR '{s_keyword}' = 'NULL'
This is an ugly solution, but it works.
This is because CCS defaults empty params to the string 'NULL'.
HTH,
Geert van der Ploeg
Triple IT
----- Original Message -----
From: "Frank Rocco" <farocco@hotmail.com>
Newsgroups: codechargestudio.discussion
Sent: Thursday, August 01, 2002 4:10 PM
Subject: How to default grid to all records when search is empty
> Hello,
>
> I have a page that has a Search form and a grid.
> The search form has a dropdown box of names passing the integer value to
the
> grid.
> The default is Any with a value of blank
>
> The grid has SQL coded to select records based on the value passed from
the
> Search form.
> How can I display all records in the grid when the value is Any?
>
> Thanks
> Frank
>
>
|
|
|
|
|
