Can you change the query ? select SDE.DBO.TMLS_PARCELS.PIN AS pin FROM table
.... -----Original Message----- From: Critz [mailto:[EMAIL PROTECTED] Sent: 24 July 2003 18:39 To: CF-Talk Subject: Funky Column Names oi CF-Talk,!! I've got a query that returns a column: SDE.DBO.TMLS_PARCELS.PIN and if I attempt valueList(out_queryTable.SDE.DBO.TMLS_PARCELS.PIN) I get a nice error..... Parameter 1 of function ValueList which is now "out_queryTable.SDE.DBO.TMLS_PARCELS.PIN" must be pointing to a valid query name any ideas how I can get around this (besides renaming the column......I do not have control over that.. Crit --- [This E-mail scanned for viruses by Declude Virus] ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4