Ok so here's the deal, I work with a number of people who have trouble with SQL and typos. Some of you may be managers who have the same type of staff. I developed a stored procedure in Oracle to build a component for each table w/ the common Insert, update, delete, select all, select one, select based on FK activities. Things look good, but my real world experience with CFCs has been quite limited.
I wanted to toss a couple of questions out there: A) what is the accepted best practice for dealing with scopes and datasources? Because these CFCs will really just be saving users typos I expect they will live on the same machine as the app. I believe I can use application scope for that reason, but I know that's not a best practice if people are using globals, etc. B) I'm using query as my returntype but most of you use structs. I am not heavy into structs yet, is there an article or info that explains why that's the way to go? C) Have other people done this and what was their experience? Thanks, don ---------------------------------------------------------- You are subscribed to cfcdev. To unsubscribe, send an email to [EMAIL PROTECTED] with the word 'unsubscribe cfcdev' in the message of the email. CFCDev is run by CFCZone (www.cfczone.org) and supported by Mindtool, Corporation (www.mindtool.com). An archive of the CFCDev list is available at www.mail-archive.com/[EMAIL PROTECTED]
