I have a boolean type column in an html cfgrid. The data is stored in the database as 1/0 and is returned from CF as such. I want the user to see Yes/No instead of 1/0. I tried QuerySetCell, and couldn't get it to work. The form is editable, when you double click the cell, the checkboxes show and it updates as it should. The only ...
I have the following: <cfajaximport/> <html> <head> <script> myf = function(data,cellmd,record,row,col,store) { if(data == "Product 4") return "<b>" + data + "</b>"; else return data; } testgrid = function() { mygrid = ColdFusion.Grid.getGridObject('data'); ds = mygrid.getDataSource(); cm = mygrid.getColumnModel(); cm.setRenderer(...
I have a CFGrid with pagination, and have a separate form to add new row to last row of the grid. //Ajax form submit ColdFusion.Ajax.submitForm('form1', 'data.cfc?method=insertRow', formUpdateHandler, formErrorHandler); //Handler function post update function formUpdateHandler() { ColdFusion.Grid.refresh('grid', true)...
hi guys, i have a coldfusion cfc and some methods in it. MethodA will return a cfquery object. now i use cfajaxproxy to call MethodA and get the query result in a cfm page. this cfm page already have a cfgrid there. now my question is how can i display the query result getting from MethodA in the grid which already have data display in i...
Hi All, I have the following cfgrid: <cfgrid format="html" name="grid" pagesize="10" selectmode="row" striperows="yes" bind="cfc:data.getData({cfgridpage},{cfgridpagesize},{cfgridsortcolumn},{cfgridsortdirection})"> <cfgridcolumn name="link" header="Link" href="link.cfm" hrefkey="link_id"> </cfgrid> Since pagesize is ...
(I'm very new to both Flex and CF -- more a .NET/ExtJS guy, so I'm a duck out of water.) I'm tweaking someone else's CFGRID code. It uses Flash format--HTML isn't an option since it would require redesigning the entire interface around the grid. Tha data I want to put in the grid have some very simple HTML elements-- <sub>, <sup>, and ...
ColdFusion 8 I have a cfgrid that that is based on a query. It is not bound to a cfc function because I want a scrolling grid, not a paged grid (you must supply the page number and page size if you use BIND).. I can figure out how to make it filter on one column by using the following code, but I really need to filter on three columns.....
In Coldfusion, I have Master and Detail data that I need to display in two separate cfgrids; like the typical Customers/Orders scenario. My cfgrids are bound to cfc functions which populate the cfgrids. In my current dataset, only one Customer has Orders and when I click on this record in the Master datagrid the Detail datagrid displa...
Hello again! :o I am working with a cfgrid and I'm not sure how to make it so when someone edits data in an entry it saves. <cfform> <cfgrid name = "degrees" query = "getDegrees" insert = "yes" delete = "yes" width = "500" height = "150" insertButton = "New Degree" deleteButton = "Delete Degree" colHeaderBold = "Yes" selectColor = "##...
Hi all, I am encountering a problem using CFGRID with JQuery. Here are the sample codes using the CFARTGALLERY database: gridtest.cfm <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <cfajaximport tags="cf...
I have a CFgrid that was working fine in CF 9.0, but now we have upgraded to 9.0.1, nothing comes up form (form.#GridName#.#Column1Name#) after the form is submitted. I made up some test code (below) which i have tried on a 9.0.1 server, which comes up with empty string in the form, were as on a 9.0 it somes up with all the info for the ...