cobraRed01
Technical User
Hi. I have a ColdFusion/Javascript-based product order form that I am trying to develop and I had a few questions. I am using CF to query a database for transaction information then display it on-screen in an updateable form. It is very important that the on-screen form should:
a) Look and act like a spreadsheet;
b) 3 or 4 fields in each record be editable and calculations that update 4 other fields in each record be done “on-the-fly”;
c) it can show up to 10 columns by up to 200 records;
d) we can re-submit to effectively update the database.
I tried this using CFGRID, which seemed like the perfect solution and I got a basic working model, but I ran into the same Java/browser dialogue problems that others have reported as well. I've heard/read that CFGRID is not a very good solution….
Question? Is there any way to guarantee CFGRID works in all browsers, maybe by prompting and automating an install of the required JAVA elements so all users gets a standard dialogue the first time they run the routine? Is there a standard fix for this that would allow me to use CFGRID consistently?
I am also trying this a different way and would like feedback on whether we are on the right track.
Procedure:
1) Do a CFQUERY to database…determine number of records in query (variable R)
2) Use CFWDDX to convert database data to a JavaScript 2-D array
3) Based on value of R and already knowing the number of columns (C = 10) loop through data and create an HTML table/form “on-the-fly” with form elements in it populated with data on the page
4) Allow user to edit certain form field element values and click on “RECALC”
5) Javascript “recalcs” values in specific form fields and re-displays the results on page
6) Upon completion of all update user clicks on “SUBMIT”
7) Use CFWDDX to convert Javascript array back to ColdFusion
8) Update database on server
Does this sound like a good plan or is there a much easier approach to this that I am missing? If the later, can you suggest the better way...If the former, are we missing anything and can we run some code by you as we progress through the project?
Thanks
a) Look and act like a spreadsheet;
b) 3 or 4 fields in each record be editable and calculations that update 4 other fields in each record be done “on-the-fly”;
c) it can show up to 10 columns by up to 200 records;
d) we can re-submit to effectively update the database.
I tried this using CFGRID, which seemed like the perfect solution and I got a basic working model, but I ran into the same Java/browser dialogue problems that others have reported as well. I've heard/read that CFGRID is not a very good solution….
Question? Is there any way to guarantee CFGRID works in all browsers, maybe by prompting and automating an install of the required JAVA elements so all users gets a standard dialogue the first time they run the routine? Is there a standard fix for this that would allow me to use CFGRID consistently?
I am also trying this a different way and would like feedback on whether we are on the right track.
Procedure:
1) Do a CFQUERY to database…determine number of records in query (variable R)
2) Use CFWDDX to convert database data to a JavaScript 2-D array
3) Based on value of R and already knowing the number of columns (C = 10) loop through data and create an HTML table/form “on-the-fly” with form elements in it populated with data on the page
4) Allow user to edit certain form field element values and click on “RECALC”
5) Javascript “recalcs” values in specific form fields and re-displays the results on page
6) Upon completion of all update user clicks on “SUBMIT”
7) Use CFWDDX to convert Javascript array back to ColdFusion
8) Update database on server
Does this sound like a good plan or is there a much easier approach to this that I am missing? If the later, can you suggest the better way...If the former, are we missing anything and can we run some code by you as we progress through the project?
Thanks
