Can anyone point me to the error in this code and the generated query? I am kind of stuck right now as it all looks ok to me.
Thanks --S ^ [Macromedia][SequeLink JDBC Driver][ODBC Socket][DataDirect][ODBC Progress OpenEdge Wire Protocol driver][OPENEDGE]Syntax error in SQL statement at or about "prodcode) from product where product.man" (10713) The error occurred in C:\htdocs\couponchek.com\barcode\pdf_bc_results.cfm: line 191 Called from C:\htdocs\couponchek.com\barcode\pdf_bc_results.cfm: line 123 Called from C:\htdocs\couponchek.com\barcode\pdf_bc_results.cfm: line 1 Called from C:\htdocs\couponchek.com\barcode\pdf_bc_results.cfm: line 1 Called from C:\htdocs\couponchek.com\barcode\pdf_bc_results.cfm: line 191 Called from C:\htdocs\couponchek.com\barcode\pdf_bc_results.cfm: line 123 Called from C:\htdocs\couponchek.com\barcode\pdf_bc_results.cfm: line 1 Called from C:\htdocs\couponchek.com\barcode\pdf_bc_results.cfm: line 1 189 : not variables.stError.v008.occurred> 190 : AND product.famcode = '#scan.famcode#' ) 191 : </cfif> 192 : </cfquery> 193 : </cfif> SQL select distinct(count prodcode) from product where product.manufid = '030030' AND product.famcode2 = '111' and product.famcode > '000' and product.prodcode not in (select prodcode from product where manufid='030030' AND product.famcode = '111' ) -- Jean Anouilh - "What you get free costs too much." ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:320554 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4