ColdFusion Query to Flex DataGrid
Kyle Hayes has posted an excellent captivate demo that walks you through hooking up a Flex DataGrid to a ColdFusion query. He covers the complete process from Flex Project creation to writing the ColdFusion CFC. This is an excellent demonstration for folks who are having a hard time wrapping their head around the process.
Captivate Tutorial: Viewing a ColdFusion Query in a Flex DataGrid
By the way - Captivate is incredibly useful. I've used it before and creating tutorials is about as easy as hitting record and just clicking and talking.
Comments
great tutorial, what i'd really like to see is a tutorial on roundtrip submitting a record back to coldfusion as well i've got a basic app which entails a table for viewing records than a detail section to update the values back to the db its currently cf/html but i'd reaaly like to do it in flex then compile it into apollo
# Posted By Daz
| 4/17/07 5:16 PM
What a great tutorial video for beginers like me. I would love to see more tutorial like this on how to do some basic records maintenance like being able to add, delete and edit records and pass it it back to the grid.
# Posted By Sam
| 9/6/07 5:44 AM
I Concure (probably miss spelled) with DAZ. I need to see an example of a datagrid updating a DB (SQL using CF7) soooo bad. I have been looking at this for months
# Posted By George Smith
| 12/11/07 6:17 PM
actually this is really easy, its the same as requesting data you just have to send the data back as a variable similar to coldfusion cfinvoke
# Posted By Daz
| 12/11/07 6:56 PM
Nope. not like that at all. I want to edit a bunch of rows and send that back to the CFC. No where do I see a sample of how to update the DB like that. I have no problem using form fields and adding editing data in one row but to edit a bunch of records in the grid and send that seems impossible (I know its not) no one can seem to showm me. AND I HAVE BEEN ON THIS FOR MONTHS!!!
# Posted By George Smith
| 1/23/08 1:02 PM
No need to shout George. :)So basically you saying you want the ability to edit N rows, and then commit the changes back to the server?
# Posted By Raymond Camden
| 1/23/08 1:40 PM
Yes.My needs are a little more complicated, but I think just knowing how to edit a bunch of rows and press a submit button that would then add the rows to a db. would help
basically I have a query that brings in some data. The edit part is just checkboxs in a column. some get checked and then press "send" a different table then would recieve the checked records.
This is what I have so far...
http://www.youngsmarket.com/youngsmarket/programs/...
Everything works except the checked records dont get added to the db.table
Thanks for looking
# Posted By George Smith
| 1/23/08 1:55 PM
Well, I'd suggest reading up more on Flash Remoting w/n Flex. This is how you would both get and send data. Sending data is just as simple as getting data, you just pass in the arguments. In you case, you would be sending the changed data.
# Posted By Raymond Camden
| 1/24/08 11:54 AM
Ray,Thanks for the response. I have read alot about remoting. I actually do have data records getting added to a db table. If you checked out my app. There is a grid that has a column of check boxs. below that is a "program area" this is whats going on in a peticular group (the accounts checked) of accounts. So a user selects some accounts then adds the program information at the bottom then send. What I get in my DB.table is the program information. Works Great! My big problem is that I cannot seem to get the checked accounts. So that a record in the DB.Table would contain the account number from the grid and the program info. The next record that has a check would contain a different account number from the grid and the same program info. and so on... Not sure if you can help me with this, but since you are responding and I have considered you one of the CF greats (I think I even took a class from you a long time ago)I better see what I can learn. Thanks George
# Posted By George Smith
| 1/24/08 12:05 PM
Ah - no - sorry - I can't provide much help now. Problem of too much stuff to do and too little time. :)
# Posted By Raymond Camden
| 1/24/08 12:58 PM
Here is a tutorial for updating a table using a datagrid in Flex:http://iummug.indiana.edu/docs/tutorials/tutorial1...
Updates are made after the user finishes editing a cell in the datagrid.