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 -~----------~----~----~----~------~----~------~--~---
