using concat function?

[gtbikerider]

I want my product_name to be displayed with a following hyphen. I thought the following code would work, but it causes an error. Any advise on how to do this?

#concat(product_Name, "-")#

--
John

 

[GUJUm0deL]

Coldfusion has no CONCAT function.

Why not concat product_name with the hyphen directly from the database? If you're using SQL Server you can something like:

select (product_name+ '-') from products

http://livedocs.macromedia.com/coldfusion/6.1/htmldocs/fm2.htm

____________________________________
Just Imagine.

http://www.imajinarts.com

 

[TruthInSatire]

if you're just displaying a - why not just do in the output, its just text..

<cfoutput query = "queryname">
#queryName.Product_name#-<br>
</cfoutput>

We've heard that a million monkeys at a million keyboards could produce the complete works of Shakespeare; now, thanks to the Internet, we know that is not true.

 

[gtbikerider]

Because I only want the hyphen to display when the variable is not "" and by doing it this way I save a load of CFIFs. That was the thinking anyway, but I think that was flawed.

--
John

 

[GUJUm0deL]

gtbikerider, why would there be "loads of CFIFs"? It should only be one, like:

<cfif len(Product_name) gt 0>
  #Product_name# -
<cfelse>
  <!--- do nothing --->
</cfif>

Unless you have other variables at play here.....


____________________________________
Just Imagine.

http://www.imajinarts.com

 

[imstillatwork]

Because I only want the hyphen to display when the variable is not "" and by doing it this way I save a load of CFIFs. That was the thinking anyway, but I think that was flawed.

you should be able to do that in the query with mySQL or MSSQL