Ben Forta did an article on this some time ago (think it was him). Check out his site at www.forta.com the article should be there somewhere.
-----Original Message----- From: Shawn Regan [mailto:[EMAIL PROTECTED]] Sent: Friday, May 24, 2002 11:31 AM To: CF-Talk Subject: RE: Access SQL stored procs Ok thanks Do you know of any place I can find docs on the syntax? Shawn Regan -----Original Message----- From: Ian Lurie [mailto:[EMAIL PROTECTED]] Sent: Friday, May 24, 2002 10:12 AM To: CF-Talk Subject: RE: Access SQL stored procs Yes, we have. It works quite well: You write your query in Access, then use CFSTOREDPROC to access it. Cut the processing time on a few of our pages from over 4 seconds to just under 400 ms. You can also access a query as a table, of course, but then PROCPARAM is right out... Ian -----Original Message----- From: Shawn Regan [mailto:[EMAIL PROTECTED]] Sent: Friday, May 24, 2002 10:04 AM To: CF-Talk Subject: OT: Access SQL stored procs Hey CF people, Happy Friday!! Well I have a question about access. I thought I saw something or read something about use the access query objects as stored procs. Has anyone done this and if so can you share? TIA Shawn Regan ______________________________________________________________________ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists