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:316826 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
