mark
|
| Posted: 09/28/2002, 8:22 AM |
|
I have a search form that will query a large oracle database
It is trying to execute SQL on page load
|
|
|
 |
Ken Hardwick
|
| Posted: 09/28/2002, 10:21 AM |
|
Using ASP, I do the following...
In the close event of the Search form...I have the following formula
for each search item...
if fldSearch = "" then
session("Search") = "XXXXXXXXXXXX"
else
session("Search") = fldSearch
end if
Then, I use the session variable as a "required" input parameter
in the grid. This way, you get an empty record set until a valid search
item is executed.
Another way, would be in the open event of the search form, modify the where statement...like
if getparam("Search") = "" then
sWhere = sWhere & " 1=2 "
end if
|
|
|
|
Ken Hardwick
|
| Posted: 09/28/2002, 1:32 PM |
|
Another way, would be in the open event of the "search" s/b "Grid" form, modify the where statement...like
if getparam("Search") = "" then
sWhere = sWhere & " 1=2 "
end if
|
|
|
|
|
