[cfaussie] Re: DB field with a space in it

Tue, 21 Mar 2006 14:31:09 -0800

<cfoutput query="qContacts">
#qContacts["First Name"][currentRow]#
</cfoutput>

On 3/21/06, Dale Fraser <[EMAIL PROTECTED]> wrote:

How about

First_Name

> -----Original Message-----
> From: [email protected] [mailto:[email protected] ] On
> Behalf Of Ryan Sabir
> Sent: Tuesday, 21 March 2006 6:20 PM
> To: '[email protected]'
> Subject: [cfaussie] Re: DB field with a space in it
>
>
>
> I'm writing a reusable module that can take a query object and dump it to
> a CSV file, and looking at ways to make the header row of the CSV file
> more user friendly.
>
> I tried the array format and thought it didn't work, but there's a bunch
> of 'evaluate()'s and whatnot around it. I'll give it another go.
>
> Bye!
>
>
> -----Original Message-----
> From: [email protected] [mailto:[email protected]] On
> Behalf Of Dale Fraser
> Sent: Tuesday, 21 March 2006 6:13 PM
> To: [email protected]
> Subject: [cfaussie] Re: DB field with a space in it
>
>
> Two ideas.
>
> 1. Don't put a space in, the as Can be AS 'FirstName'
>
> Or
>
> 2. You can probably access it in the array format.
>
> #qContacts['First Name']#
>
> But I really don't see why you can't do 1.
>
> Regards
> Dale Fraser
>
>
> > -----Original Message-----
> > From: [email protected] [mailto:[email protected] ] On
> > Behalf Of Ryan Sabir
> > Sent: Tuesday, 21 March 2006 18:05 PM
> > To: '[email protected]'
> > Subject: [cfaussie] DB field with a space in it
> >
> > Heya,
> >
> > How would I go about accessing the value of a query object, where
> > there is a space in the field name?
> >
> > e.g.
> >
> > <CFQUERY name="qContacts">
> >     SELECT firstName AS 'First Name'
> >     FROM contacts
> > </CFQUERY>
> >
> > <CFOUTPUT>#qContacts.First Name#</CFOUTPUT>
> >
> > This code breaks obviously. But is there a different way to access
> > this field?
> >
> > thanks...
> >
> >
> >  < http://www.newgency.com/footerImages/logo.gif>    Ryan Sabir
> > Technical Director
> >
> > p: (02) 9274 8030
> > f: (02) 9274 8099
> > m: 0411 512 454
> > w: www.newgency.com <http://www.newgency.com/>
> > <http://www.newgency.com/footerImages/divider.gif >  Newgency Pty Ltd
> > Web | Multimedia | eMarketing
> >
> > 224 Riley St
> > Surry Hills NSW 2010
> > Sydney, Australia
> >
> >
> >
>
>
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "cfaussie" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at http://groups.google.com/group/cfaussie
-~----------~----~----~----~------~----~------~--~---

Reply via email to