> I've got some county data that is returned from ArcIMS > as a query. > > Some of the columns returned are > > #_of_farms(2000) > 1-People_living_in_city_limits(2001) > > etc etc > > I normally grab the columnames then just loop thru those > and do an evaluate to dump the values. > > But evaluate keeps dying on the # and the - > > I can <cfdump> the query, so I am assuming CF can evaluate > the columnames somehow. But I cannot seem to get it sorted. > Any ideas?
The first thing I'd try, if I had access to the SQL queries themselves, is simply to alias the columns. If for some reason you can't do that, you can probably simply escape the pound signs by doubling them. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ______________________________________________________________________ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
