try double quotes around the column name....but I think that may mess with the ValueList() function
HTH Bryan Stevenson B.Comm. VP & Director of E-Commerce Development Electric Edge Systems Group Inc. t. 250.920.8830 e. [EMAIL PROTECTED] --------------------------------------------------------- Macromedia Associate Partner www.macromedia.com --------------------------------------------------------- Vancouver Island ColdFusion Users Group Founder & Director www.cfug-vancouverisland.com ----- Original Message ----- From: "Critz" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Thursday, July 24, 2003 10:38 AM 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 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
