RE: CF execute HELP

2002-10-07 Thread Craig Dudley

Try writing a batch file that does what you want, then just cfexecute that
instead, I have more luck doing it that way.

Craig.

-Original Message-
From: Terry Troxel [mailto:[EMAIL PROTECTED]] 
Sent: 07 October 2002 16:19
To: CF-Talk
Subject: CF execute HELP


I have never used cfexecute before and could use a few pointers
before I suffer early hair loss.

Here is what I am attempting to do.

I would like to run Access from the command line opening 
a database with a linked table in it that will be copied to another
datasource using an autoexec macro which has a copy object
call as it's action.

The reason I am doing this is my financial package (MAS90) uses
illegal characters in its database table naming that Access can handle,
but not CF. So I am attempting to create a new table everytime I open
the test.mdb. It works fine in windows 2000, but not in a CF template
using the following parameters. This is an intranet app.

cfexecute name = C:\program files\microsoft office\office\msaccess.exe
  arguments = c:\inetpub\databases\test.mdb 
  timeout = 100
/cfexecute

If anyone can show me the correct method to accomplish my task
I would greatly appreciate it.

Terry




~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
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



Re: CF execute HELP

2002-10-07 Thread Jochem van Dieten

Terry Troxel wrote:
 
 The reason I am doing this is my financial package (MAS90) uses
 illegal characters in its database table naming that Access can handle,
 but not CF.

How about:
cfquery
SELECT [illegal ##$@* name] AS allowed_fieldname
FROM   [illegal ##$@* name] allowed_tablename
/cfquery

Jochem

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.