TheConeHead
Programmer
Not sure if this is the right forumn... probably not... but does anyone know of a good serch engine? I need something that will search a very large site that will inclide SQL db's...
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search Engine
- Thread starter TheConeHead
- Start date
- Status
- Thread starter
- #3
- Thread starter
- #4
Doing a site-search with coldfusion is not hard at all...
Follow these steps:
1) Create a dB with the proper fields (like: searchwords, name, link, descriptions, and anything else you might need)
2) Create a search form on a page called search.cfm, pointing to searchresults.cfm page (in the <form action> portion)
3) On the searchresults.cfm page write a query that will search the dB for the words and return any links that it matches. Like this:
SELECT searchwords, name, links, descriptions
FROM myTABLE
WHERE searchwords = '#%form.searchwords%#'
ORDER BY = name
The above query should search the dB in the searchwords field for any words entered in the search textfield (the form on search.cfm page), and then return anything that it matches...
The % is an SQL term that means 'LIKE', so it someone entered part of a word it will still return a correct link. Forget the Nobel Peace prize, I just want to take over the world!!![[hammer]](/data/assets/smilies/hammer.gif "[hammer] [hammer]")
Follow these steps:
1) Create a dB with the proper fields (like: searchwords, name, link, descriptions, and anything else you might need)
2) Create a search form on a page called search.cfm, pointing to searchresults.cfm page (in the <form action> portion)
3) On the searchresults.cfm page write a query that will search the dB for the words and return any links that it matches. Like this:
SELECT searchwords, name, links, descriptions
FROM myTABLE
WHERE searchwords = '#%form.searchwords%#'
ORDER BY = name
The above query should search the dB in the searchwords field for any words entered in the search textfield (the form on search.cfm page), and then return anything that it matches...
The % is an SQL term that means 'LIKE', so it someone entered part of a word it will still return a correct link. Forget the Nobel Peace prize, I just want to take over the world!!
- Thread starter
- #6
TheConeHead
Programmer
how about searching the text of all the pages as well...
What do you mean?? The above example will return any results that match the words type in the textbox on search.cfm sitewide...
Just expand the above example to make it work for you... Forget the Nobel Peace prize, I just want to take over the world!!
Just expand the above example to make it work for you... Forget the Nobel Peace prize, I just want to take over the world!!
- Thread starter
- #8
TheConeHead
Programmer
I mean beyond searching a DB - actually parsing and searching the pages of a site
Whatever types of searching you wanna make, you can do it via either creating a dB for that type and then running a similar query, or use the coldfusion buil-in searching tool, i think its called "Varity" Forget the Nobel Peace prize, I just want to take over the world!!
- Status
Similar threads
- Locked
- Question