Most people say not to build your tables as objects and your objects to match them. I tend to do just that even though I do not really think of it that way. I think of an application from the database side first and then build around that thought. I cannot find a link but there was a presentation to the DFW CFUG last week that was on OO and he was one of the people I have heard say to not even think about your database but to first build your CFC objects and go from there. If you organize your SPs into packages and go from there then it can make them manageable to a point. I never have used a tool that made the task easier on me, maybe the newer versions of Toad do.
On Sat, Dec 13, 2008 at 9:45 AM, Shane Heasley <[email protected]>wrote: > > I would have to politely disagree, maybe, with Robert on philosophical > grounds. Stored procedures have their place when speed is critical. > Otherwise, business logic should be kept in the middleware, in > components, where it can be properly and easily managed. A few SP's > are not a problem. Get a few hundred and management is a nightmare. > Get a few thousand and - well I have two friends who are getting rich > with a consulting firm that specializes in removing SP's and putting > the logic back into ColdFusion or .net. They have told me that on > several occasions the companies that hired them were close to breaking > down because they had lost control over their software. One very > large manufacturing firm actually shut down for 6 weeks. > > That all seems a bit extreme but I have to say I don't know of good > tools to manage SP's. That could be ignorance on my part, but, build > your tables as objects, build components (objects) to match them with > CRUD and other needed methods, and life is easy. > > As to the OPs original problem: CF typing doesn't match up perfectly > with all the different databases. Just try some other, similar, > datatypes until one of them works. > > > > -- Aaron Rouse http://www.happyhacker.com/ --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the "Houston ColdFusion Users' Group" discussion list. To unsubscribe, send email to [email protected] For more options, visit http://groups.google.com/group/houcfug?hl=en -~----------~----~----~----~------~----~------~--~---
