> Quick guess, change
> like ('%' + word + '%')
> to
> like (word)
At least in sql server afaik ( not sure about other db's, but I suspect it's
fairly standard ) using "like word" is the same as using "= word" because
the db is looking for a wildcard % or _ ( single character wildcard in sql
server iirc ) for the like comparison. If you leave them out afaik it
doesn't assume % on either side of the string.
s. isaac dealey 954-776-0046
new epoch http://www.turnkey.to
lead architect, tapestry cms http://products.turnkey.to
certified advanced coldfusion 5 developer
http://www.macromedia.com/v1/handlers/index.cfm?ID=21816
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
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
This list and all House of Fusion resources hosted by CFHosting.com. The place for
dependable ColdFusion Hosting.
