Need help here: I dont understand why I am only getting output from ItemsLit and not Items. Code below.
<cfquery name="Merchitems" dbtype="ODBC" datasource="TJTools"> SELECT ItemID,SecID,Type,ItemNumber,ProdName,QSPriceUS,QSPriceUS1,CUPriceUS,CUQty FROM Items WHERE (ProdName LIKE '%#form.searchTerms#%' OR ItemNumber LIKE '%#form.searchTerms#%') </cfquery> <cfquery name="LitItems" dbtype="ODBC" datasource="TJTools"> SELECT ItemID,SecID,Type,ItemNumber,ProdName,QSPriceUS,QSPriceUS1,CUPriceUS,CUQty FROM ItemsLit WHERE (ProdName LIKE '%#form.searchTerms#%' OR ItemNumber LIKE '%#form.searchTerms#%') </cfquery> <cfquery name="combinedQ" dbtype="query"> SELECT ItemID,SecID,Type,ItemNumber,ProdName,QSPriceUS,QSPriceUS1,CUPriceUS,CUQty FROM Merchitems,LitItems ORDER BY ProdName,Type </cfquery> ______________________________________________________________________ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
