Three things come to mind. First - you must specify which query that which columns fom from. You cannot do:
SELECT ItemID,ItemNumber,ProdName, QSPriceUS,CUQty Instead you must do: SELECT SearchItems.ItemID AS ItemId, SearchItems.ItemNumber AS ItemNumber, SearchItems.ProdName AS ProdName .... etc. Secondly, you the "WHERE" has some case sensitivity issues and I've had MUCH better luck putting the column name in all uppercase (don't ask me why) within the where clause. AND thirdly - aren't you really looking at a union here? Q of a Q might be the wrong choice in this instance. Mark <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 ______________________________________________________________________ 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
