Amro
|
| Posted: 08/05/2002, 5:07 AM |
|
Hi
I have a search form with a list box and a grid that shows the results.
In CCS you can't force list box to search for *ALL* entries if you are using "SQL" as the grid source instead of "Table"... The problem is that you have to assign "Defualt Value" for each parameter you use in your SQL statment ! So you can't search for all .
Can anybody help me please? How can I search for all/any and show the results in a grid that uses hand written SQL statments ??
Thanks
|
|
|
 |
Berry
|
| Posted: 08/06/2002, 2:31 AM |
|
Hmm... I'm facing the same problem. default value of SQL parameter is needed.
|
|
|
|
Nicole
|
| Posted: 08/07/2002, 4:06 AM |
|
Amro,
as CCS requires Default value for the table/sql parameters the workaround is to remove Where clause at all in case you want to list all the possible records.
Create Before Build Select event. Here is sample code for ASP and PHP that replaces Where clause with custom one:
ASP
EventCaller.Where = ""
PHP
global $form_name;
$form_name->ds->Where = "";
|
|
|
|
|
