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
