CF 5 and DAO

2008-01-03 Thread Chad Gray
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?

Re: CF 5 and DAO

2008-01-03 Thread Ben Doom
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

Re: CF 5 and DAO

2008-01-03 Thread Greg Luce
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

RE: CF 5 and DAO

2008-01-03 Thread Chad Gray
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

Re: CF 5 and DAO

2008-01-03 Thread Aaron Rouse
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

Re: CF 5 and DAO

2008-01-03 Thread Eric Cobb
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

Re: CF 5 and DAO

2008-01-03 Thread Dominic Watson
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

Re: CF 5 and DAO

2008-01-03 Thread s. isaac dealey
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?