> I've run into a strange query-of-query issue and wondering if > anyone else has seen this or knows of a work-around. > Basically, I'm passing a query into a CFC and then running this QoQ: > > <cfquery name="qryGetItems" dbtype="query"> > SELECT DISTINCT Item_ID, Related_Items FROM > arguments.theQuery </cfquery> > > Related_Items is a text field with a list of IDs. The problem > I am having is that when this runs, if Related_Items just has > a single ID (or none), it works fine. But if it has several > items in the list, the QoQ doesn't return the list, it > apparently is converting it to a date field.
Does the original query passed to the CFC come from a database itself, or are you creating it some other way? Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 & MX7 integration & create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:269599 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
