concatenating string in cache query

Hi All,

Thanks for your help. The TotalProfit column in my original query is a numeric field and casting it in the QofQ did the trick. The reason I wanted to add the dollar sign in the query instead of a <cfouput> is I wanted to use the result of the query and bind it to a cfgrid (HTML version). This tag had attributes that allow you to add numberformat / dollarformat, but they're only for the Flash version of the cfgrid. It was unavailable for the HTML version. I considered using the Flash version, but this version did not allow you to bind data to the grid. I wanted the page navigation / column sorting that binding allows.

I'm not too sure why cfgrid have different attributes for different grid types. I kinda wish the binding and the number format both exist at the same time.

Jason

If the concatonation is static text to a db field, a simple way to do it is in the output, not in the query.

I was wondering if I concatenate strings within the query I write in a <cfquery> tag with dbtype="query"? I want to do something similar to the following: <cfquery name="a_query" dbtype="query">      SELECT           ('$ ' + TotalProfit) AS TotalProfit2      FROM SomeCachedQuery </cfquery> I can do this if the query is run on the SQL server, but not with the cached query.If this is not possible

That is quite possible. In fact, it is so common you will come across it all over the place.

Just to confirm: what you're trying to do should be something like

<cfquery name="SomeQuery" datasource="someDSN">
     SELECT TotalProfit
     FROM someTable
</cfquery>

<cfquery name="a_query" dbtype="query">
     SELECT ('$ ' + TotalProfit) AS TotalProfit2
     FROM SomeQuery
</cfquery>

Since you can do it in the original sql, you should.  If you want to do it in ColdFusion, look at the query functions such as queryaddcolumn and querysetcell.