Forums

Extract and edit multiple rows from dB using CF?

profotoweb 09 Mar, 2014
Hi!

I wonder if it is possible to extract multiple rows of data from a database,
present it in a form/table so that the visitor can edit those records. One at the time.

Ex. A visitor has entered products with serial numbers under his/her email address and userid.

I'd like to present a form where he/she can interact with already saved data
(multiple rows of products registered under the same 'email' and/or 'userid'

I have the mechanism for new registrations in place and it works fine... I even managed to pre-populate this New registration form with the user 'name' and 'email' ..using Load User Info Action. (thnx GH!! :-)
... but now want to let visitor edit the records too. (After they have logged in of course)

Any tips, pointers and snippets of code greatly appreciated!

/Akerman
GreyHead 11 Mar, 2014
Answer
Hi Akerman,

There are two ways to do this:

+ The simplest may be to use a DB Multi-Record Loader to get the data you want and then to display it using a Custom Element in a form.

+ The more complex, but more powerful one is to use ChronoConnectivity to build a list.

Bob
profotoweb 19 Mar, 2014
ChronoConnectivity is great!

/Akerman
This topic is locked and no more replies can be posted.