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 Host with the leader in ColdFusion hosting. Voted #1 ColdFusion host by CF Developers. Offering shared and dedicated hosting options. www.cfxhosting.com/default.cfm?redirect=10481 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4