Well the CF Help files themselves have quite a bit of info on how to use that tag. Also check Allaires Knowledge base and support forums for more info. Kelly www.webdiva.org
-----Original Message----- From: Steven Lancaster [mailto:[EMAIL PROTECTED]] Sent: Friday, November 02, 2001 11:50 AM To: CF-Talk Subject: RE: Newbie question Do you know of a resource that I can look at to give me more info.? Steven Lancaster WebMaster Core Laboratories 6316 Windfern Houston, TX 77040 mailto:[EMAIL PROTECTED] http://www.corelab.com -----Original Message----- From: Douglas L. Brown [mailto:[EMAIL PROTECTED]] Sent: Friday, November 02, 2001 10:49 AM To: CF-Talk Subject: Re: Newbie question Take a look at using verity and <CFCOLLECTION> Doug ----- Original Message ----- From: "Steven Lancaster" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Friday, November 02, 2001 8:09 AM Subject: Newbie question > I new to this list and new to CF. I have a question though. I have a > very small search engine I am trying to create. I am using CF 5 and I am > using Access as the database. I can get it to find the entries, but it > only sees the first keyword and nothing after that. Here is my code see > if you can help me PLEASE! I also need to be able to shoot an error if > they enter a keyword that is not listed. I am completely lost about what > I am doing wrong. > > <CFQUERY NAME="search" DATASOURCE="search"> > SELECT ID, title, Description, hyperlink, keywords > FROM search > WHERE keywords = keywords > <cfif keywords IS NOT ""> > AND keywords LIKE '#keywords#%' > <CFELSE> > <h3>You did not enter a keyword!!</h3> > </cfif> > > </CFQUERY> > <html> > <head> > <title>Untitled</title> > </head> > > <body> > <cfoutput query="search"> > <strong>#search.RecordCount# Results</strong><br><br><br> > <table cellspacing="2" cellpadding="2" border="0"> > <tr> > <td></td> > </tr> > <tr> > <td>#title#</td> > </tr> > <tr> > <td>#Description#</td> > </tr> > <tr> > <td><a href="#hyperlink#">Test</a></td> > </tr> > </table> > > </cfoutput> > > Steven Lancaster > WebMaster > Core Laboratories > 6316 Windfern > Houston, TX 77040 > > mailto:[EMAIL PROTECTED] > > http://www.corelab.com > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists