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