>> SELECT * FROM bluegrasscalendar WHERE Title LIKE '%#TITLE#%' >Take out the leading % and your query will work. With both % in there this >returns everything because to SQL, your string is like everything in the >database.
I don't think so. If the variable "TITLE" is "dog", then the where clause is "WHERE Title LIKE '%dog%'" which shouldn't return the entire table. My guess is that "TITLE" ends up being an empty string (WHERE Title LIKE '%%'), which brings back the entire table. Try outputting the variable "TITLE" and see what you get. I'd also recommend scoping the variable, in case there is another variable called Title in your page which is screwing you up. Scott -------------------------------- Scott Brady http://www.scottbrady.net/ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
