You want to use quotedValueList() instead of valueList since ProdID is not numeric.
Works now - thanks!
Here's the complete beastie!
<cfquery name="srch2" datasource="myDATA"> SELECT color.colorCAT, color.colorNAME, color.colorID, colorLOOKUP.itemNUM, colorLOOKUP.colorID, papers.* FROM ( color INNER JOIN colorLOOKUP ON color.colorID = colorLOOKUP.colorID) INNER JOIN papers ON colorLOOKUP.itemNUM = papers.ITEM_NUM WHERE color.colorCAT = '#FORM.SRCH#' OR color.colorNAME = '#FORM.SRCH#' AND colorLOOKUP.itemNUM NOT IN (#quotedValueList(srch.ITEM_NUM)#) </cfquery>
ACK!
Had the rest of it going except for that last line ... mayge my coffee ain't strong enough...
-- ----------- Les Mizzell
---------------------------------------------------------- You are subscribed to cfcdev. To unsubscribe, send an email to [email protected] with the words 'unsubscribe cfcdev' as the subject of the email.
CFCDev is run by CFCZone (www.cfczone.org) and supported by CFXHosting (www.cfxhosting.com).
An archive of the CFCDev list is available at www.mail-archive.com/[email protected]
