I rant into something like this like 4 years ago, (spaces in the column names) using an access database. I havent used QoQ before so I dont know if this will work. Just a guess.
What I did is use the SQL "AS" function. In the query that you are querying (The first one) use some thing like this: <CFQUERY NAME="Get_Whatever" DATASOURCE="SQLDB"> SELECT Field Name AS FieldName, Field Name2 AS FieldName2 FROM SomeTable </CFQUERY> Let me know if that works. Z ================================ Gerald "Coz" Guido [EMAIL PROTECTED] Coztech Communications http://www.coztech.com 3765 Maria Circle Tallahassee, Fl 32303 phone: 850.443.8277 fax: 904-685-2211 ================================ ----- Original Message ----- From: Barney Boisvert To: CF-Server Sent: Friday, February 04, 2005 5:47 PM Subject: Re: MX QoQ Multi-Word Field Names 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. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:10:5148 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
