Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-04-03 : 09:44:18
|
| Garo writes "Im trying to build a activities calender. Im not sure if this is the best way to do it, but im open to sugestions. Description follows...The user can search for a keyword in 3 table fields and refine search by activity type and area (select fields) each on separate table. The three tables are conected by a query table in access.To make the keyword search on its own, or the two select fields its relatively easy to get to work. But to get all 3 to work in combination is becoming a frustrating task. Here is what I im trying...SELECT TITLE, DESCRIPTION, WEBSITE FROM QryDisplayFieldsWHERE AREA= '" + Replace(rsQryCombinedFields__varArea, "'", "''") + "' AND ACTIVITY= '" + Replace(rsQryCombinedFields__varActivity, "'", "''") + "' AND TITLE AND DESCRIPTION AND WEBSITE LIKE '" + Replace(rsQryCombinedFields__varKeyword, "'", "''") + "%' ORDER BY TITLE"The select search works, but not the keyword. I have tryed reading tutorials and looking at diferent aplications, they seem to offer complex solutions wich I have found dificult to aply to this specifik application.Any sugestions? Thanks Garo" |
|
|
Jay99
468 Posts |
Posted - 2002-04-03 : 12:06:36
|
| You have not yet recieved a response because your description isn't very clear. Please repost with your CREATE TABLE statement for the QryDisplayFields table, and the requirements for the search stored procedure including params and expected resultsets. We'll try to help you sort this out . . .Jay<O> |
 |
|
|
|
|
|
|
|
Multiple Search Parameters?