Hi all,

  I am new to SQL so this is going to be a very steep learning curve for me. I have posted in the general section about a search module I am looking for (but not much response so far). I want users to be able to search my site but I want the search entries to look at the Page Name and then Description (The sections you fill in when creating a new DNN Page).
For example if someone entered a search text of News, I want my seach to look at Page Name and find all pages where "News" in in the name, then look at Description and find all pages where "News" is in the description. Then return results in the form of:

Page name
Description



Where the Page name is the link to the page. I also want the results to be ordered where Page name takes priority. So what I am looking to fins out is what field names I need to query with SQL to find these values. I hope someone can help me.

Thanks

page data is stored in Tabs table.

---

Cheers from Germany,
Sebastian Leupold

   

Speed up your DNN Websites with TurboDNN

You many want to look at the SQL reporting modules like the core Reports module, or modules like SQLView Pro from DNNStuff or even my module SQLGridSelectedView,  All of these modules will accept a T-SQL Command and generate a grid as a result.

So, how you get the user value into a T-SQL command ... some of the modues will allow you to pass a parameter into the T-SQL as a substitution parameter.  For example - with SQLGridSelectedView:

Select tabname as [Page Name] from tabs where description like '%[search:text]%'

Based on a user input of "News" then the above becomes

Select tabname as [Page Name] from tabs where description like '%News%'

This will then return the tabname in a column called "Page Name" where the description contains "News"  Check out the keyword LIKE and the % wlidcard.

I would also create a link by create the appropriate HTML in the T-SQL.  so something like

Select
  tabname as [Page Name] ,
  '<a href="www.mysite.com/tabid/' + cast(tabid as varchar) + '/default.aspx">click here</a>' as Link,  
from 
   tabs
where
   description like '%[search:text]%'

So this would create a two column result of page name and link.  You could combine the two if needed.

Hope this helps.
Paul.