> -----Original Message-----
> From: Dave Carabetta [mailto:[EMAIL PROTECTED]
> Sent: Thursday, July 24, 2003 1:57 PM
> To: CF-Talk
> Subject: Re: Funky Column Names
>
> >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..
> >
>
> Have you tried bracket notation instead of dot notation? I have no idea if
> that works, but it's a thought:
>
> #valueList(out_queryTable["SDE.DBO.TMLS_PARCELS"].pin, ",")#
If the whole messy thing ("SDE.DBO.TMLS_PARCELS.PIN") is actually the column
name then bracket notation should work but it would probably be something
like this:
#valueList(out_queryTable["SDE.DBO.TMLS_PARCELS.pin"], ",")#
I would do a CFDUMP of the query to determine what CF thinks things are.
Jim Davis
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
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
