<cfqueryparam cf_sql_type="varchar" value="#ValueList(Query1.prodID)#" list="true" />
At least, I believe that would have worked.
But, as someone else mentioned, it is best to use a single trip ala Nested Query in this particular example.
Bill
On 4/15/05, Rob Brooks-Bilson <[EMAIL PROTECTED]> wrote:
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]
--
[EMAIL PROTECTED]
http://blog.rawlinson.us
If you want Gmail - just ask. ----------------------------------------------------------
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]
