|
| |
|
|
Loert
Posts: 19
From: Atlanta, GA, USA
Status: offline
 |
Using Checkboxes to modify Query - 6/11/2001 14:57:00
I would like to use a check box in my DRW search page to modify the query but I'm not sure how to go about it. What I would like to do is this: If check box A is checked, then any items in Column_A in the DB that are NOT NULL will be included in the results. I've searched all over the place to figure out how to do this but I haven't any luck. Any help would be greatly appreciated. Thanks.Loert
|
|
|
|
Spooky
Posts: 26599
Joined: 11/11/1998
From: Middle Earth
Status: offline
|
RE: Using Checkboxes to modify Query - 6/11/2001 18:54:00
Hmmm. Im thinking not really unless you customise it. With a check box you are supplying a value which may not work in SQL.Perhaps : "select from table where column is ::forminput::" and check boxes could be "Null" or "Not Null" ------------------
§þððk¥
"I am Spooky of Borg. Prepare to be assimilated, babycakes!"
Subscribe to OutFront News
Database / DRW Q & A
The Spooky Login!
| |
|
 New Messages |
 No New Messages |
 Hot Topic w/ New Messages |
 Hot Topic w/o New Messages |
 Locked w/ New Messages |
 Locked w/o New Messages |
|
Post New Thread
Reply to Message
Post New Poll
Submit Vote
Delete My Own Post
Delete My Own Thread
Rate Posts
|
|
|
Printable Version 
