CFSTOREDPROC works fine. You need to set up a "paramater query" in Access. There is a db and example here if you need it. http://cfhub.com/forum//index.cfm?FuseAction=Thread&TopicID=2391
> Any specific syntax needed to work or can I call them like SQL stored procedures? Do you use CFQUERY or CFSTOREDPROC? I want to get all the data on this before I move a 400 meg DB file from the HoF server to my home system and back again. And that's just CF-Talk ______________________________________________________________________ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
