On 8/1/01, Bruce, Rodney penned:
>I am using ACCESS, NT and IIS. I am trying to run a set of queries
>as a stored procedure.
> I have created a page of all the queries and have tried to add it to
>the CF Administrator Scheduled tasks. But when I try to run it, CF admin
>gives me a long list of possible reasons it can't run the task, all
>dealing with URL. it can't be resolved, needs the / at the end of domain
>(which it is not : /website/subd/cfpage.cfm), URL is SSL. and others.
>
>Hope someone can help, I am lost!
Sounds like you may be confusing Stored Procedures, which can't be
done in Access (actually, you can save a query in Access and call it
using cfstoredproc, but I don't believe you can pass variables to
it), with Scheduled Tasks.
If you put a full URL (https://secure.mydomain.com/page.cfm) in the
the Scheduled task window it should work fine. Maybe I'm missing
something?
--
Bud Schneehagen - Tropical Web Creations
_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/
ColdFusion Solutions / eCommerce Development
[EMAIL PROTECTED]
http://www.twcreations.com/
954.721.3452
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
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
