bas
|
| Posted: 05/22/2011, 11:53 PM |
|
With a Grid and Record on the same page I want to allow user to Filter based
on Text Box
By text box is called 'sfilter' - how do I include sfilter in my SQL - (the
sFilter is not not in any table - just a Text box on the page)
|
|
|
 |
datadoit
|
| Posted: 05/23/2011, 6:49 AM |
|
If you're not filtering against the dataset, then what are you searching
for? Contents of a file on disk? An outside API?
|
|
|
|
bas
|
| Posted: 05/23/2011, 7:27 AM |
|
No, the TextBox with contain a word such as 'Completed' / 'Active'
(would be nice if it was a List but I'm told you can't get value of Selected
List item)
ie. I want to do something like ....select * from Jobs where status =
sFilter
"datadoit" <admin@datadoit.com> wrote in message
news:irdolm$22l$1@news.codecharge.com...
> If you're not filtering against the dataset, then what are you searching
> for? Contents of a file on disk? An outside API?
|
|
|
|
datadoit
|
| Posted: 05/23/2011, 7:50 AM |
|
When you put a listbox in your search form and the search button is
clicked, the value of that listbox selection will be in the URL as long
as you didn't do something to alter the behavior of your search button
(ie: change the operation from 'Search' to something else such as
'Insert', 'Update', etc.).
So in your results grid, you'll simply check for the value of the URL
parameter 'sFilter', or whatever you named your listbox control.
If you don't have a value for sFilter in the URL after clicking the
search button, then you've done something to the listbox itself so that
it doesn't have a 'Bound Column' value.
|
|
|
|
|
