I am so use to using MX and CFCs that now I have to work on a CF5 server for a
client and
Is there a good way of setting up a DAO in CF5 so I can reuse SQL code and not
have to retype the CFQueryies each time I need them?
Should I use CFModule? CFInclude? A custom tag CF_ProductDAO?
We always used includes, although cfmodule would probably be better. We
just broke each inline query out into an include, then called it as
necessary.
--Ben Doom
Chad Gray wrote:
I am so use to using MX and CFCs that now I have to work on a CF5 server for
a client and
Is there a good
Stored procedures. :-)
On Jan 3, 2008 11:33 AM, Ben Doom [EMAIL PROTECTED] wrote:
We always used includes, although cfmodule would probably be better. We
just broke each inline query out into an include, then called it as
necessary.
--Ben Doom
Chad Gray wrote:
I am so use to using MX
I though about that, but I am forced to use Access and too my knowledge you
can't do Stored Procedures.
-Original Message-
From: Greg Luce [mailto:[EMAIL PROTECTED]
Sent: Thursday, January 03, 2008 11:52 AM
To: CF-Talk
Subject: Re: CF 5 and DAO
Stored procedures. :-)
On Jan 3, 2008
We did cfincludes as well and in this same manner. I have seen where people
have done a cfinclude of a series of UDFs and each UDF is a query more or
less. Seems like it would not be the most efficient of ways to do things.
On Jan 3, 2008 10:33 AM, Ben Doom [EMAIL PROTECTED] wrote:
We always
can't do Stored Procedures.
-Original Message-
From: Greg Luce [mailto:[EMAIL PROTECTED]
Sent: Thursday, January 03, 2008 11:52 AM
To: CF-Talk
Subject: Re: CF 5 and DAO
Stored procedures. :-)
On Jan 3, 2008 11:33 AM, Ben Doom [EMAIL PROTECTED] wrote:
We always used
Personally, I would do it in a way where you can set the name of the
variable that is going to store the query in the calling code. i.e. I would
avoid something like this as it can lead to ambiguity over where the
qry_users variable is set:
cfinclude template=queries/QRY_getusers.cfm
cfloop
I am so use to using MX and CFCs that now I have to work on a CF5
server for a client and
Is there a good way of setting up a DAO in CF5 so I can reuse SQL
code and not have to retype the CFQueryies each time I need them?
Should I use CFModule? CFInclude? A custom tag CF_ProductDAO?
8 matches
Mail list logo