|
| |
|
|
BeTheBall
Posts: 6336
Joined: 6/21/2002
From: West Point Utah USA
Status: offline
 |
RE: Database Pages (this should bring a result) - 8/3/2004 21:54:12
The next question is do you really want users to search by all those fields? Here is the SQL statement from your code:
fp_sQry="SELECT * FROM Results WHERE (event_name LIKE '%::event_name::%' AND Host LIKE '%::Host::%' AND Date = '::Date::' AND Time = '::Time::' AND event_details LIKE '::event_details::%')"
In order to get a match, the user must enter the event name, the host, the date and time and event details. If the user enters a wrong value for any of those fields, no result will be returned. You need to ask yourself, "What field(s) is the user likely to search on?" Then adjust your page to include only those items in the search criteria. I would begin with Date and event_name only. Also, I would use OR instead of AND so the user will get results based on the Date or the event.
You can do this by right-clicking within the database results region and choosing "Database Results Properties". Proceed to Step 3 of the wizard and choose "More Options" and then select r criteria. First, delete all the criteria you currently have. Then, begin again. Choose Date - Equals - Date and change the And/Or value to "Or". Then add a new criteria for event_name of event_name - contains - event_name. Then finish the wizard and see if you have a little more success.
_____________________________
Duane
Some people are like Slinkies . . . Not really good for anything . . . . . But they still bring a smile to your face when you push them down a flight of stairs.
|
|
|
|
pipwax
Posts: 35
Joined: 10/3/2003
Status: offline
|
RE: Database Pages (this should bring a result) - 8/3/2004 22:09:57
Thanks a lot
| |
|
|
|
pipwax
Posts: 35
Joined: 10/3/2003
Status: offline
|
RE: Database Pages (this should bring a result) - 8/3/2004 22:20:19
I guess it is easy when you know how thanks a million
| |
|
|
|
pipwax
Posts: 35
Joined: 10/3/2003
Status: offline
|
RE: Database Pages - 8/4/2004 6:29:44
check out this page and tell me what you think? http://ruff-ryders.org/search.htm
| |
|
|
|
BeTheBall
Posts: 6336
Joined: 6/21/2002
From: West Point Utah USA
Status: offline
|
RE: Database Pages - 8/4/2004 8:55:48
Appears there is a problem with the server extensions. Report it to your host.
_____________________________
Duane
Some people are like Slinkies . . . Not really good for anything . . . . . But they still bring a smile to your face when you push them down a flight of stairs.
| |
|
|
|
pipwax
Posts: 35
Joined: 10/3/2003
Status: offline
|
RE: Database Pages - 8/4/2004 12:42:10
That's what I thought.
| |
|
|
|
pipwax
Posts: 35
Joined: 10/3/2003
Status: offline
|
RE: Database Pages - 8/4/2004 16:47:00
On the events page in the details column how do I make this come out a link? http://ruff-ryders.org/events.asp
| |
|
 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 
