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 gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Discussion forum search problems

Status
Not open for further replies.

Iriel

Technical User
Jun 14, 2003
1
US
I am using ColdFusion MX for a class and coupling it with a MS Access database. This cannot be changed, but I have created a discussion forum composed of a screen name value and comment. What I need to do is create a search engine for the forum that would allow a user to have relavent forum posts displayed. How the heck can I go about this?
 
The short answer is you would use
Code:
<CFQUERY>
to run a SQL command that SELECTs records from your Access database based on criteria WHERE the screen name equals some value.

(and that's the short answer)


-Carl
 
Right, so your code on the form action page might look something like this:

<cfquery name=&quot;searchresults&quot; datasource=&quot;forumdb&quot;>
select tablename.post
from tablename
where tablename.screenname is #FORM.screenname#
</cfquery>


 
Actually, that would be:

<cfquery name=&quot;searchresults&quot; datasource=&quot;forumdb&quot;>
select tablename.post
from tablename
where tablename.screenname = '#FORM.screenname#'
</cfquery>

;-)

Hope This Helps!

Ecobb
- I hate computers!
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top