Joe Filipe
|
| Posted: 10/23/2002, 6:00 PM |
|
I have a seach form that contains various selection fields. If the user
does not select one of then (say from a drop down box, the value will remain
"All with a value of ""), I would like to remove this parameter from the SQL
WHERE clause, before it is sumbited for execution.
Any help is appreciated.
Using ASP
Thanks!
Joe Filipe
jofilconsulting@hotmail.com
|
|
|
 |
Alexey Alexapolsky
|
| Posted: 10/24/2002, 2:44 AM |
|
Please use "Before Build Select" event of Grid Form that shows results.
There you can check input parameters with CCGetParam function and if
there are no params you can set FormName.DataSource.Where = ""
--
Alex,
Support Engineer
CodeCharge Team
"Joe Filipe" <jofilconsulting@hotmail.com> wrote in message
news:ap7gn2$q3c$1@news.codecharge.com...
> I have a seach form that contains various selection fields. If the user
> does not select one of then (say from a drop down box, the value will
remain
> "All with a value of ""), I would like to remove this parameter from the
SQL
> WHERE clause, before it is sumbited for execution.
>
> Any help is appreciated.
>
> Using ASP
>
> Thanks!
>
> Joe Filipe
>jofilconsulting@hotmail.com
>
>
|
|
|
|
Richard Duke
|
| Posted: 10/27/2002, 5:23 AM |
|
Alex
i have a similar problem but am having difficulty finding the "Before Build
Select" event of the grid form. Can you explain how i find or define this?
Regards
Richard Duke
"Alexey Alexapolsky" <alexa@codecharge.com> wrote in message
news:ap8fd5$hvr$2@news.codecharge.com...
> Please use "Before Build Select" event of Grid Form that shows results.
> There you can check input parameters with CCGetParam function and if
> there are no params you can set FormName.DataSource.Where = ""
>
> --
>
> Alex,
> Support Engineer
> CodeCharge Team
>
>
> "Joe Filipe" <jofilconsulting@hotmail.com> wrote in message
>news:ap7gn2$q3c$1@news.codecharge.com...
> > I have a seach form that contains various selection fields. If the user
> > does not select one of then (say from a drop down box, the value will
> remain
> > "All with a value of ""), I would like to remove this parameter from the
> SQL
> > WHERE clause, before it is sumbited for execution.
> >
> > Any help is appreciated.
> >
> > Using ASP
> >
> > Thanks!
> >
> > Joe Filipe
> >jofilconsulting@hotmail.com
> >
> >
>
>
|
|
|
|
|
