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