The generated SQL has the <cfqueryparam> tags in it???? There's something wrong with that picture. How are you writing that query?
On Tue, Dec 16, 2008 at 3:13 PM, Mike Little wrote: > jake this is the actual dump... > > SELECT P.pid, P.price, P.price_sale, P.bid, P.display, P.views, PD.ptitle, > PD.availability > FROM product P > INNER JOIN product_description PD ON P.pid = PD.pid > INNER JOIN product_to_categories PTC ON P.pid = PTC.pid > INNER JOIN categories C ON PTC.cid = C.cid > INNER JOIN categories_description CD ON C.cid = CD.cid > INNER JOIN brand B ON P.bid = B.bid > WHERE ((P.code LIKE <cfqueryparam cfsqltype="cf_sql_varchar" > value="%tents%">) OR (PD.ptitle LIKE <cfqueryparam > cfsqltype="cf_sql_varchar" value="%tents%">) OR (PD.pdesc LIKE <cfqueryparam > cfsqltype="cf_sql_varchar" value="%tents%">) OR (PD.fill_type LIKE > <cfqueryparam cfsqltype="cf_sql_varchar" value="%tents%">) OR (PD.summary > LIKE <cfqueryparam cfsqltype="cf_sql_varchar" value="%tents%">) OR > (PD.features LIKE <cfqueryparam cfsqltype="cf_sql_varchar" value="%tents%">) > OR (CD.ctitle LIKE <cfqueryparam cfsqltype="cf_sql_varchar" > value="%tents%">) OR (B.btitle LIKE <cfqueryparam cfsqltype="cf_sql_varchar" > value="%tents%">)) > AND P.display = 1 > GROUP BY P.pid > ORDER BY PD.ptitle ASC > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:316827 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
