Matt, Your solution worked great for my Sun One Directory LDAP server thanks!
Regards, JB Matt Kornguth wrote: >Progress database. If you've never heard of it, you're not alone. Our >fulfillment system is completely in Progress. > >And I could be wrong, but I don't think it is a rdbms limitation in my >case, but rather a limitation of the OpenLink driver used to connect to >it. > >Very possible that James could simply use aliasing ... I had jumped to >the conclusion, maybe incorrectly, that he had already tried aliasing. > > > >-----Original Message----- >From: Costas Piliotis [mailto:[EMAIL PROTECTED] >Sent: Friday, June 13, 2003 1:21 PM >To: CF-Talk >Subject: RE: Hyphen in a variable name? > > >With what database? I mean, every rdbms out there should support >aliased fields... That's been around like forever... At list since the >Ansi-88 standard... > >Heck, even MS Access allows you to alias fields... > >-----Original Message----- >From: Matt Kornguth [mailto:[EMAIL PROTECTED] >Sent: Friday, June 13, 2003 10:17 AM >To: CF-Talk >Subject: RE: Hyphen in a variable name? > > >Don't want to speak for James, but the aliasing never worked for me. And >I tried every possible combination ... But then again that might have >just been a limitation of the ODBC driver I need to use. > >-----Original Message----- >From: Costas Piliotis [mailto:[EMAIL PROTECTED] >Sent: Friday, June 13, 2003 1:09 PM >To: CF-Talk >Subject: RE: Hyphen in a variable name? > > >...or why not just alias that column name in your query? > >Select [product-code] as productcode >>From .... > >Wouldn't that save some processing time? Keep the load off cf? > >Best practice to just avoid hyphens and spaces in column names. Use >camelCase to denote extra words. > >-----Original Message----- >From: Matt Kornguth [mailto:[EMAIL PROTECTED] >Sent: Friday, June 13, 2003 10:00 AM >To: CF-Talk >Subject: RE: Hyphen in a variable name? > > >Do a search for 'renamequerycolumns' at >http://www.macromedia.com/cfusion/exchange/index.cfm#loc=en_us&view=sn10 >5&viewName=Exchange%20Search. Should be the only resulting file. Also, >you may need the CFX_QueryColumns tag as well (also available at MM). > >If you have any problems, let me know, I'll forward to you separately. > >Matt > >-----Original Message----- >From: James Blaha [mailto:[EMAIL PROTECTED] >Sent: Friday, June 13, 2003 12:47 PM >To: CF-Talk >Subject: Re: Hyphen in a variable name? > > >Matt, > >Looks interesting. Where can I get the tag from MM? > >Regards, >JB > >Matt Kornguth wrote: > > > >>James, >>Don't know if this will help, but take a look at the RenameQueryColumns >> >> > > > >>custom tag. Called like this: >> >><CF_RenameQueryColumns >> QUERY="getProductName" >> ACTION="MAKESAFE" >> NEWQUERY="getProductNameRenamed" >> MAKEUNIQUE="Yes" >> USEUNDERSCORE="No"> >> >>This will turn product-code into productcode. Works really well. I need >> >> > > > >>to use it constantly as I connect via ODBC to a Progress db that uses >>hyphens all over the place. >> >> >> >> >>-----Original Message----- >>From: James Blaha [mailto:[EMAIL PROTECTED] >>Sent: Friday, June 13, 2003 11:49 AM >>To: CF-Talk >>Subject: Hyphen in a variable name? >> >> >>Hello All: >> >>Does anyone know how to use a hyphen in a variable name for a cfoutput? >> >>For example: >><cfset my-name = "Jim"> >><cfoutput>#my-name#</cfoutput> >> >>I'm outputting a field in a LDAP server that has a hyphen in its name >>and I can't seem to output it in ColdFusion. >> >>Regards, >>James Blaha >> >> >> >> >> >> > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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
