Why do i always forget about Verity? Sorry for the dumb post.
At 04:03 PM 5/23/2002 +0100, you wrote: >Would Verity be better for this? Or indexing? > >-----Original Message----- >From: chad [mailto:[EMAIL PROTECTED]] >Sent: 23 May 2002 16:02 >To: CF-Talk >Subject: SQL search with related tables > > >Im writing a SQL statement to take a search word and go through the >database to find records that match. > >Well i want to search all the related tables of the products. The database >is kind of the standard product database. Category Table that relates to a >SubCategory Table, that relates to the Product Table. > >So im trying to Join all the tables then use a LIKE to find the search word >in the database. > >Is there a better way to search the database for matches? > >Thanks > > > > ______________________________________________________________________ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.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