Hi Everyone, I have a great ajax/cfgrid mockup working. Sorting, filtering etc.. all working very well. Client has just asked if I can extend it a little more.
Gridrow 1 = "Title" they would like the words "NEW" to be prefixed to the title (and stand out in a bold, coloured font) if the item has a create date that is 3 months from today. I need to do this either at the SQL select or after if I re-parse the recordset and change the field "Title" to include this information. Creating another column in the cfgrid is not an option. So my quesiton. 1. Is this possible in SQL? (using if/then and insert (not insert into table, but insert something into a Select returned field) statements??) I'd need someting like IF create_d between <3 months ago> and <now> Then INSERT(title,0,0,'<span style="font-style:bold;color:#000000;">NEW</span>') AS new_title (the insert syntax is: (field, location, replace x chars, replaced text) OR 2. Can I parse through a recordset in CF 8 (in a CFC) add this where needed and still return a query that the grid is bound to? Anyone have a code sample that does this? Many thanks, Matts ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:305326 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
