> I wasn't aware that you could do stored procedures in MS Access 2000.
> Although I know you can save a query and call it as if it were a
> regular table via ODBC, I don't know of a way to pass that query
> variables. I would need to pass in a few variables for the WHERE
> statement of the query. Is this possible to do with MS Access? Am
> I missing something here?
With CF 4.0.1 and the CFSTOREDPROC tag, you can call Access parameter
queries as if they were stored procedures. There's more info about this on
our CFUG site:
http://www.figleaf.com/figleafhome/cfug/CFUGfeb99.zip
Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
voice: (202) 797-5496
fax: (202) 797-5444
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
