Joe,
Just read the article on the link, interesting stuff, but the example
scenario you have used is making the app db independant, but then you use
this code in your front end .cfm
<cfset userDAO = createObject("component",
"UserDAO_MSSQL") />
Now your front end is still hardcoded for MSSQL? And the only way (other
than doing a massive find/replace) to shift the entire app to another DB
easily is by modifying the userDAO_MSSQL.cfc so that it no longer is MSSQL?
Kerry
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Behalf Of Joe Rinehart
Sent: 18 November 2004 02:50
To: [EMAIL PROTECTED]
Subject: Re: [CFCDev] Process for Updating Database Records
Hey Dan,
You may want to run a google for "CFC DAO" (dao = "Data Access
Object"), check out the mach-ii developer's guide for it, or read the
introduction to using Data Access Objects I posted a few days ago on
my blog:
http://clearsoftware.net/client/index.cfm?mode=entry&entry=3D1115E7-E081-2BA
C-6953DA4394855DDB
Happy coding,
Joe
On Wed, 17 Nov 2004 13:00:38 -0800, Daniel Short <[EMAIL PROTECTED]> wrote:
> Hi everyone,
>
> I'm working on making my database layers a bit more abstract, and I'm just
> curious how you all handle inserting and updating to tables through your
> CFCs. I've gotten quite good at breaking out the SELECT pieces via
> getMyRecordset type functions, but can't quite figure out the best way to
> abstract INSERT and UPDATE statements. My biggest question is how to get
all
> of the FORM data into the CFC without relying on FORM.whatever. The only
> thing I can think of at the moment is to actually pass each form variable
in
> as an argument, but I can imagine how that could quickly get out of hand
> with some of the rather large tables I need to maintain (I don't really
want
> to define 30 or more arguments in my CFCs).
>
> Any ideas would be greatly appreciated.
>
> Regards,
>
> Daniel Short
> Lead Developer
> Cartweaver Development Team
> Application Dynamics, Inc.
>
> ----------------------------------------------------------
> 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
[EMAIL PROTECTED]
>
--
For Tabs, Trees, and more, use the jComponents:
http://clearsoftware.net/client/jComponents.cfm
----------------------------------------------------------
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
[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
[EMAIL PROTECTED]
