Ive got a database that holds the page title and the page content. Currently the asp performs a query to find the matches within the page title and then another query on the page content. This way the asp dispays all the title matches before it displays the page contenet results. Is there a way these two querys could be joined as i want to add a database paging function.
Thanks Kev
This Question has been solved and asker verified All Experts Exchange premium technology solutions are available to subscription members.
Experts Exchange has been collecting answers to technology questions since 1996…3 million and counting! If you have a question, chances are we already have your answer.
If you can't find the exact answer you're looking for, ask our exclusive community of 50,000 experts. You’ll get a personalized answer from a trusted professional.
Thousands of free tech tips, tricks, how-to’s and tutorials are available in our peer reviewed articles section. See for yourself how smart our experts are, no login required.
Save solutions to your questions, answers you’ve discovered through searching plus helpful articles in your personal knowledgebase for easy future access.
Access the answers to your technology questions today.
30-day free trial. Register in 60 seconds.
Members of the expert community talk about why the experience at Experts Exchange is different than what you will find anywhere else.
Try it out and discover for yourself.
30-day free trial. Register in 60 seconds.
Join the community of experts here and help other tech pros by answering question in your area of expertise. You can earn FREE access to all Experts Exchange's premium features and resources.
Hi
Thing is i want the query to return the records where the search string has matched the title first
followed by records that contain the seachstring within the content. This way the most relevant pages will be shown at the top as the page title has matched the query string followed by the least relevant as the query string has only been found in the page content
Thanks
Kekitelely -
One method would be to use a Union query.
Here is my suggestion, using the SQL from rcmb
select 1 as Sequence, * from table where title = '" & request("title") & "'
Union
select 2 as Sequence, * from table where OR content = '" & request("content") & "'
Order by Sequence
The union operator will throw out dupes. The order by statement will put the title matches first, then the content matches. You could put additional items in the sort, such as title, price, ect, depending on how you want them ordered.
You should also include the "Like" statements that RCMB suggested, unless you plan on people entering in a complete match on the title or the content.
On second thought, this union will keep dupes, b/c the sequence number column will make them unique, so try this instead.
select 1 as Sequence, * from table where title LIKE '%" & request("title") & "%'"
Union
select 2 as Sequence, * from table where content LIKE '%" & request("content") & "%' and title NOT LIKE '%" & request("title") & "%'"
Order by Sequence
The second select returns only those records that match on content, but do not match on title.
That should do it.
Business Accounts
Answer for Membership
by: KeKiteleyPosted on 2004-11-12 at 08:20:00ID: 12567239
oh i also dont want any records to be displayed twice