if( self is DBA ) {
smile();
smack(SMACK_CONSTANTS.SOFTLY);
} else {
for( var i:int; i<ArrayOfFieldsWithSpacesInNames.length;i++) {
smack(SMACK_CONSTANTS.REALLYHARD);
}
}
:D
DK
On Thu, Apr 17, 2008 at 4:48 PM, John Mason <[EMAIL PROTECTED]> wrote:
> It's annoying that spaces were ever allowed in the first place. I
> would do something like this in the first cfquery so it will work in your
> qoq
>
> select... [Column Name] as ColumnName
>
> A better solution frankly is to eliminate those spaces
>
> John Mason
> [EMAIL PROTECTED]
> 770.337.8363
>
> www.FusionLink.com - ColdFusion and Flex hosting
> Now offering VPS Plans running with VMware technology
> Now offering ColdFusion 8 Enterprise hosting
> FREE Subversion hosting
>
> ------------------------------
> *From:* [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] *On Behalf Of *Scott
> Councill
> *Sent:* Thursday, April 17, 2008 4:25 PM
> *To:* [email protected]
> *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
> [EMAIL PROTECTED] <[EMAIL PROTECTED]>
>
> *Spunlogic
> *Expect More From the Web
> www.spunlogic.com <http://www.spunlogic.com/?CMP=EMC-OutlookSig>
>
> *Looking for insights and tips on all aspects of interactive marketing?
> Visit Spunlogic's Blog <http://www.spunlogic.com/blog/?CMP=EMC-OutlookSig>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 FusionLink <http://www.fusionlink.com>
> -------------------------------------------------------------
>
--
Douglas Knudsen
http://www.cubicleman.com
this is my signature, like it?
-------------------------------------------------------------
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
-------------------------------------------------------------
