There are object-based databases out there, but they don't work with CFCs natively (or I've never seen an adapter that would allow this). There are ways to serialize a CFC and save it to the database, but this usually opens up a ton of issues such as, the main two being that it saves the entire object, including all dependent objects, and that if you change the object later you have an awful synchronization issue since your serialized objects are now all invalid; etc.
Basically you'll need to use one of the CFC-based ORM options like Transfer or Reactor, generate a DAO, or write your own by hand. On Wed, Feb 18, 2009 at 2:13 AM, David Mineer <min...@gmail.com> wrote: > > I have a siteoptions bean which holds session variables that are unique to > each user. I use roobies cfc bean generator to create a bean which gives > me > get and set access to variables which essetially match the form on my > website that I use to collect the information. > > How can I store this information in the database to persist it between > visits for my users? > > The obvious answer would be to have a matching table in the database which > has a corresponding field for each form field. I could use transfer for > this and it would work great and I understand that. But would that be a > good thing? > > Or is there I way I can take the bean and just save it to the database as > one object, easily retrievable for the next session. > > I guess now that I think about it, either way I will have to have a db > table, so there goes that advantage. But if the bean were to grow or > change > The db wouldn't have to if I was able to save the whole object. > > Anyone have any thoughts on these ramblings? > > -- > David Mineer Jr > --------------------- > The critical ingredient is getting off your > butt and doing something. It's as simple > as that. A lot of people have ideas, but > there are few who decide to do > something about them now. Not > tomorrow. Not next week. But today. > The true entrepreneur is a doer. > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319478 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4