To quote someone else: "Every time you store a comma-delimited list in a database field God kills a kitty."
The main problem with your situation is that there shouldn't be a list in a database field. There should be a separate table that creates the one-to-many or many-to-many relationship. By doing that, your problems would be solved. Hope that helps. Matt On 2/12/07, Mary Jo Sminkey <[EMAIL PROTECTED]> wrote: > > 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. > > Any ideas? > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:269600 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
