If it's a sql query you could select order-id as orderId etc -----Original Message----- From: Jim Wright [mailto:[EMAIL PROTECTED] Sent: Thursday, November 16, 2006 1:14 PM To: CF-Talk Subject: Re: Stupid Field Names
James Smith wrote: > While processing Amazon report files I notice that they have labelled most > of their fields with "-" in. For example order-id and payments-date. > > Having queried this file how am I going to be able to refer to the field, > obviously #order-id# won't work as it will try to evaluate the var order > minus the var id. > > I have tried #[order-id]# and #'order-id'# with no success, any ideas? > > -- > Jay It sounds kind of like you have this in a query...so you could use... <cfoutput query="myquery"> #myquery["order-id"][currentrow]# </cfoutput> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:260732 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
