myQuery = SDE.DBO.TMLS_PARCELS; pin = myQuery.pin; Timothy Heald Information Systems Specialist Overseas Security Advisory Council U.S. Department of State 571.345.2235
-----Original Message----- From: Critz [mailto:[EMAIL PROTECTED] Sent: Thursday, July 24, 2003 1:54 PM To: CF-Talk Subject: Re: Funky Column Names oi webguy!! it's an ArcIMS query... I get what it spits out.. ------------------------------------ Thursday, July 24, 2003, 1:48:04 PM, you wrote: w> Can you change the query ? w> select SDE.DBO.TMLS_PARCELS.PIN AS pin w> FROM table w> .... w> -----Original Message----- w> From: Critz [mailto:[EMAIL PROTECTED] w> Sent: 24 July 2003 18:39 w> To: CF-Talk w> Subject: Funky Column Names w> oi CF-Talk,!! w> I've got a query that returns a column: SDE.DBO.TMLS_PARCELS.PIN w> and if I attempt valueList(out_queryTable.SDE.DBO.TMLS_PARCELS.PIN) w> I get a nice error..... w> Parameter 1 of function ValueList which is now w> "out_queryTable.SDE.DBO.TMLS_PARCELS.PIN" must w> be pointing to a valid query name w> any ideas how I can get around this (besides renaming the column......I w> do not have control over w> that.. w> Crit w> --- w> [This E-mail scanned for viruses by Declude Virus] w> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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