If brackets doesn't work, I think you're SOL. However, you can duplicate the columns under a different name by using valueList, listToArray and queryAddColumn, and then run your QofQ on the new column with a legal name. I have no idea what kind of performance implications that'll have, but if you don't have any way to change the original recordset, it might be your best bet.
You might look at doing your QofQ operations manually with loops and stuff, as well. It works, and is reasonably performant, though it's definitly a PITA. cheers, barneyb On Fri, 4 Feb 2005 16:38:52 -0600, Raster, Tim <[EMAIL PROTECTED]> wrote: > I gotta use Query of Query to reference a dynamic recordset where some > fields are multi-word (have spaces in the name). In databases such as > Access or SQL Server, you can put brackets [] around it to treat it as a > single word. QoQ barfs on that. > > How do I reference multi-word field names in a CF MX QoQ? > > P.S. Don't ask. > > -- Barney Boisvert [EMAIL PROTECTED] 360.319.6145 http://www.barneyb.com/ Got Gmail? I have 50 invites. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:10:5147 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/10 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:10 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.10 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
