Bud
You are right Im probably confusing the two, this is the first time I have
tried to do this.
Little more detail:
I am trying to run a query(s) that will transfer data from one table
to another on a monthly bases and would like to automate it. I am on a
development server, no domain name so the url is:
http://localhost/website/subdir/cfpage.cfm , my mistype below we are not
running SSL on the server, that was one of the possible errors CF admin was
throwing at me.
I have created the querys in Access and they run fine. I have tried to call
them using <CFSTOREPROC> but cant seem to get them to run. the same querys
(using <CFQUERY>) also run fine from a .cfm page that can be ran manually
from the web site. I'm stuck on how to get this to be run from the
scheduler. Is there a way to do this??
thanks again
-----Original Message-----
From: Bud [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, August 01, 2001 3:54 PM
To: CF-Talk
Subject: Re: Stored Procedures
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
