Thanks Denny, Nice late night post - I could virtually hear your eyes closing as I read! :-)
Thanks for the ideas I'll investigate those a bit further. Enjoy the Hot Dogs! On 6/10/06, Denny Valliant <[EMAIL PROTECTED]> wrote: > > On 6/9/06, Michael Traher <[EMAIL PROTECTED]> wrote: > > > > I'm wondering if there is a CRUD generator out there that is more > > lightweight than say Reactor or PLUM? > > > Ok, last post for me for a bit, really: > > I've seen a couple of "DAO" generators, but I'm nut sure if that's what > you mean. I think so tho... lemmme check delicious... umm.. > old, but maybe this: *http://tinyurl.com/gxrzy > > *Here's what I do, and comments are welcome. Probably lots of folks > do it this way too (or did in the past, more likely ;). > > I pass a structure of fields, that match DB columns, and a table name > to a function that does a "DESCRIBE #table#". > > It loops through the fields, using the data returned from the DB, so > I know if nulls are acceptable, if it's a varchar or a numeric, how long > is the max, etc., all maintained in the db), then I cfparam it all up > in a query and execute. > > Now I know it's not very good for tons of inserts and updates (although > it's been fast enough when I've tried it), but how do people feel about > this method? If anyone feels anything at all. > > I bet you could use an existing thing like Plumb to build DAO and > just use the DAO, instead of all the nifty Plumb features, but I don't > know. > > Is a DAO "better" than the aformentioned function? I would think on > enterprise stuff, probably, as good ones do nifty cache stuff and > whatnot... > > It's been so easy using my function, (basically a custom cfinsert tag), I > haven't bothered to look into DAO too much. Webservices are sounding > interesting tho, as they're not CF-centric, neh?... Hrm... > > Well, enough nonsense, I gotta get ready to cook some hot-dogs. > Mmmm... hot dogs... (also my first wysiwyg web page editor, IIRC..) > :D > > What I'm thinking would be useful is something that would generate a basic > > form and a CFC with CRUD methods for table. No XML config, no setters > and > > getters just pass the form as an argument collection. > > > > After the basic code was generated you would and most likely would want > to > > change it, but a lot of tedious typing would be done. > > > > I have googled for a while, but just wondered if anyone knows of a tool > > like > > this? > > > > -- > > Mike T > > Blog http://www.socialpoints.com/ > > This e-mail may contain privileged and confidential information and/or > > copyright material and is intended for the use of the addressee only. If > > you > > receive this e-mail by mistake please advise the sender immediately by > > using > > the reply facility in your e-mail software and delete this e-mail from > > your > > computer system. You may not deliver, copy or disclose its contents to > > anyone else. Any unauthorised use may be unlawful. Any views expressed > in > > this e-mail are those of the individual sender and may not necessarily > > reflect the views of The Collinson Group Ltd and/or its subsidiaries. > > > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:243132 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
