RE: Hyphen in a variable name?

2003-06-13 Thread Bryan F. Hogan
If your using MX cfset Variabes['my-name']='Jim' cfoutput#Variabes['my-name']#/cfoutput -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

RE: Hyphen in a variable name?

2003-06-13 Thread Matt Kornguth
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

Re: Hyphen in a variable name?

2003-06-13 Thread James Blaha
Bryan, Thanks, does this work in CF 5? Regards, JB Bryan F. Hogan wrote: If your using MX cfset Variabes['my-name']='Jim' cfoutput#Variabes['my-name']#/cfoutput -Original Message- From: James Blaha [mailto:[EMAIL PROTECTED] Sent: Friday, June 13, 2003 11:49 AM To: CF-Talk Subject:

RE: Hyphen in a variable name?

2003-06-13 Thread Bryan F. Hogan
' -Original Message- From: James Blaha [mailto:[EMAIL PROTECTED] Sent: Friday, June 13, 2003 12:14 PM To: CF-Talk Subject: Re: Hyphen in a variable name? Bryan, Thanks, does this work in CF 5? Regards, JB Bryan F. Hogan wrote: If your using MX cfset Variabes['my-name']='Jim' cfoutput#Variabes

RE: Hyphen in a variable name?

2003-06-13 Thread Bryan F. Hogan
you can not do a cfset my-name='Joe' -Original Message- From: Bryan F. Hogan [mailto:[EMAIL PROTECTED] Sent: Friday, June 13, 2003 12:30 PM To: CF-Talk Subject: RE: Hyphen in a variable name? No but you can create your own variable scope structure such as cfset myVariables=StructNew

Re: Hyphen in a variable name?

2003-06-13 Thread James Blaha
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

RE: Hyphen in a variable name?

2003-06-13 Thread Matt Kornguth
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

RE: Hyphen in a variable name?

2003-06-13 Thread Costas Piliotis
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_usview=sn10 5viewName=Exchange%20Search. Should

RE: Hyphen in a variable name?

2003-06-13 Thread Matt Kornguth
, 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

RE: Hyphen in a variable name?

2003-06-13 Thread Costas Piliotis
, 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

RE: Hyphen in a variable name?

2003-06-13 Thread Matt Kornguth
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

Re: Hyphen in a variable name?

2003-06-13 Thread James Blaha
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