If you are developing a truly nTiered application, can you achieve it if your data access in mixed in to your application? I like stored procs because they make the line between application server and dB a bit crisper (more crisp)? Just my two cents =) Not to mention that a compiled sp is quite a bit faster than <CFQUERY>
-----Original Message----- From: adam [mailto:[EMAIL PROTECTED] Sent: Thursday, July 08, 2004 2:01 PM To: [EMAIL PROTECTED] Subject: RE: [CFCDev] data abstraction layer ideas? - diff db's (was Serialization of CFCs) >2. Do you use SQL SELECT/INSERT/UPDATE/DELETE statements or stored procs? I don't see the value of using SPs for such basic operations, to be honest. Maybe on an insert so as to return the PK, but in our situation, we specify the PK ourselves (createUUID()), so we've no need for this. But if you're just doing a SELECT statement from one table... Why use a SP (serious question... Like I've said before... I'm a SP bunny, so might be missing something). >3. What if you only need to return a single column from a multi-column table? Do you specify which columns are returned which, in turn, would create a dynamic SQL statement? Our get() method has a selectFields arguments. This defaults to * (I wish, I'd defaulted it to just returning the PK, and encourage users more to think about what they want to return; but it's done now). >4. Can someone post an example CFC that performs these SQL actions? I can't post some actual code because my boss would shoot me, but I'll get some pseudo code sorted out later on today. Adam ---------------------------------------------------------- You are subscribed to cfcdev. To unsubscribe, send an email to [EMAIL PROTECTED] with the words '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] ---------------------------------------------------------- You are subscribed to cfcdev. To unsubscribe, send an email to [EMAIL PROTECTED] with the words '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]
