|
BeTheBall -> 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.
|
|
|
|
