Actually, you can. Sort of. http://intersuite.com/client/index.cfm/2007/11/8/Stupid-MS-Access-Tricks
This was tested on CF 7, but I would think that it would work with CF 5 Hope this helps! Eric Chad Gray wrote: > 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 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 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>? >>> >>> >>> >> > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:295763 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

