Les, You want to use quotedValueList() instead of valueList since ProdID is not numeric.
-Rob Les Mizzell <[EMAIL PROTECTED]>@cfczone.org on 04/15/2005 02:54:53 PM Please respond to [email protected] Sent by: [EMAIL PROTECTED] To: [email protected] cc: Subject: [CFCDev] One more query question Two queries from different tables. Query1: Select myDATA from myTABLE Query2: Select myDATA2 from myTable2 WHERE prodID NOT IN (#ValueList(Query1.prodID)#) But that's throwing an error. prodID is not numeric, so that's perhaps the problem. Can't seem to get the syntax just right though... Pointers? -- ----------- 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] ---------------------------------------------------------- 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]
