Multiple DB fields and CFIF code in a cfgridcolumn?
Posted on 2005-03-17
Is it possible to have multiple DB fields to display in a cfgridcolumn? Also, is it possible to put CFIF code within a cfgridcolumn as well? The code below is just a quick example I put together. Lets say I want to have a CFIF/CFELSE to do different things in the field? ....and include an href IF one of those statements is true....
<cfquery name="OrderCount" datasource="#Portal.WebAppDSN#">
SELECT OrderNumber, Date, Product, TotalNumber
<cfform format="flash" width="700" height="150">
<cfgrid name="OrderGrid" height="100" query="Orders">
<cfgridcolumn name="Product" header="Product">
<cfgridcolumn name="OrderNumber Date" header="Order Number and Date">
<cfgridcolumn name="TotalNumber (if look here)" header="Total">
I haven't been able to find a good example on the web that goes into more detail than the macromedia livedocs.