I am try to qury queries. Do not know wy the below funtion is not working?
Any help be appreciated. Thank you Dave CLay www.trusjoist.com <cfquery datasource="#Request.App.datasource#" name="Searchitems"> SELECT ItemID,ItemNumber,type,ProdName, QSPriceUS,CUQty FROM Items </cfquery> <cfquery datasource="#Request.App.datasource#" name="SearchLititems"> SELECT ItemID,ItemNumber,type,ProdName, QSPriceUS,CUQty FROM ItemsLit </cfquery> <CFSET form.searchterms="Cap"> <cfquery name="combinedQ" dbtype="query"> SELECT ItemID,ItemNumber,ProdName, QSPriceUS,CUQty FROM SearchItems, SearchLitItems WHERE (ProdName like '#form.searchTerms#%' OR ItemNumber like '#form.searchTerms#%') ORDER BY ProdName </cfquery> ______________________________________________________________________ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation � $99/Month � Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb 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
