Hey Scott long time man. Hope you're well. Hey this is just a thought. I really don't have much experience doing QoQ but couldn't you do something like creating a column alias in one of those queries so it doesn't have a space in it in the query itself? Again I may be way off but just thought I would offer that. Dusty
_____ From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Scott Councill Sent: 04/17/2008 4:25 PM To: discussion@acfug.org Subject: [ACFUG Discuss] QoQ question I am writing a query of query where the result set in the original query has spaces in the field names. I know when you are querying a database, you use [Field Name] as the syntax but CF is throwing an error when I do this with the QoQ. Any ideas how I can call the fieldname with spaces in a QoQ? J. Scott Councill Software Engineer II Direct: 404.601.4390 Cell: 804.267.9555 <mailto:[EMAIL PROTECTED]> [EMAIL PROTECTED] Spunlogic Expect More From the Web <http://www.spunlogic.com/?CMP=EMC-OutlookSig> www.spunlogic.com Looking for insights and tips on all aspects of interactive marketing? Visit <http://www.spunlogic.com/blog/?CMP=EMC-OutlookSig> Spunlogic's Blog for a look inside the minds of a leading interactive agency. ------------------------------------------------------------- Annual Sponsor - Figleaf Software <http://www.figleaf.com> To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLink <http://www.fusionlink.com> ------------------------------------------------------------- ------------------------------------------------------------- Annual Sponsor FigLeaf Software - http://www.figleaf.com To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com -------------------------------------------------------------