doh, got to read better :( Sorry man,
Tim -----Original Message----- From: Critz [mailto:[EMAIL PROTECTED] Sent: Thursday, July 24, 2003 2:20 PM To: CF-Talk Subject: Re: Funky Column Names oi Tim!! that's not the query though: out_queryTable is the query... oh well for now this will work Eek!: <cfloop query="out_queryTable"> <cfset selSet = listAppend(selSet,evaluate("SDE.DBO.TMLS_PARCELS.PIN"))> </cfloop> t'ain perdy but she's a werkin naw ------------------------------------ Thursday, July 24, 2003, 2:03:28 PM, you wrote: HT> myQuery = SDE.DBO.TMLS_PARCELS; HT> pin = myQuery.pin; HT> Timothy Heald HT> Information Systems Specialist HT> Overseas Security Advisory Council HT> U.S. Department of State HT> 571.345.2235 HT> -----Original Message----- HT> From: Critz [mailto:[EMAIL PROTECTED] HT> Sent: Thursday, July 24, 2003 1:54 PM HT> To: CF-Talk HT> Subject: Re: Funky Column Names HT> oi webguy!! HT> it's an ArcIMS query... I get what it spits out.. HT> ------------------------------------ HT> 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 HT> column......I w>> do not have control over w>> that.. w>> Crit w>> --- w>> [This E-mail scanned for viruses by Declude Virus] w>> HT> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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 Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
