|
| |
|
|
jk8721
Posts: 2
Joined: 7/16/2007
Status: offline
 |
Please Help, Searching Database, 3 search boxes. - 7/16/2007 11:35:28
Hello all. I've been up all night and still can't get this thing to work. I've been to all the tutorials and have read every single post (well it feels like it anyway). I think it is a simple problem but I just can't make it work. I've got a simple Access Database with one results table with about 8 fields. I created a search page using the DRW with only 3 search boxes/fields, using FP2002. I want to search for just one box (customerLastName) or search for box one and box two (City) or Box one, box two and box 3 (state). The problem is I can't make it work properly. I can use all - Ands - it works if you feel out all the search boxes but I want the surfer to be able to just pick one or two boxes if he/she so chooses. If I set it for all - Or - it gives me all the city and state results, even though they don't match the name results. Finally, I have a lot of Null fields that I allow on purpose. The Null fields should come up if found by one of the other criteria (e.g., CustomerLastName catches a Smith but the city and state are null - this should show in the results). Sorry to be so long winded but it's my first time - be gentle. Any help would be greatly appreciated. Thanks.
|
|
|
|
rdouglass
Posts: 9280
From: Biddeford, ME USA
Status: offline
|
RE: Please Help, Searching Database, 3 search boxes. - 7/16/2007 11:46:56
Hi and Welcome to OutFront.
Are you using just the DRW? I am quite convinced that's probably well outside the capabilities of that.
I suspect you'll need to generate the SQL on-the-fly and will build it based on the field inputs.
What do you have so far?
And once you answer, I'll probably move this post over to the DB forum.
_____________________________
Don't take you're eye off your final destination.
ASP Checkbox Function Tutorial.
| |
|
|
|
jk8721
Posts: 2
Joined: 7/16/2007
Status: offline
|
RE: Please Help, Searching Database, 3 search boxes. - 7/16/2007 18:50:20
Thanks for replying so fast. I don't have a problem with Access, it's FP that I'm pulling my hiar out over. Anyway, I go into the DRW and on step 2 I select custom query edit and I''ve got the following scritp.
SELECT * FROM Results WHERE (CustomerLastName = '::CustomerLastName::' OR City = '::City::' OR State = '::State::')
I've tried it with all -Ands- and seperating the fields with ( ) and I've tried adding % in front of and behind each form field. I've actually tried every way possible known to mankind (well almost). I would be happy to paste some SQL script but I'm not sure where it goes. I tried about 9 of them last night. Maybe I just put them in the wrong spot but couldn't get any to work. Anyway, thanks again for any help.
| |
|
 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 
