Is this something you could run from a command line? If so, then you can set it all up in a batch file to trigger it and also direct output to another file (maybe). Then you would use <cfexecute> to kick off the batch file.
------------------------------------ Gerry Gurevich Application Development NIEHS ITSS Contractor Lockheed Martin Information Technology 919-361-5444 ext 311 -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Thursday, September 06, 2007 4:21 PM To: discussion@acfug.org Subject: re: [ACFUG Discuss] Running a system command from ColdFusion Worth a shot, but no. Same error. I'm pretty sure it's choking on the "Exec" keyword. ed ---------------------------------------------------------------------- Ed Szwedo Web Development Team Lead CSC E-mail: [EMAIL PROTECTED] 919-541-3955 (Voice) 919-685-3395 (Fax) Mischa Uppelschoten ext 10 To <Mischa.Uppelsch Web Site <discussion@acfug.org> [EMAIL PROTECTED] cc m> Sent by: Subject [EMAIL PROTECTED] re: [ACFUG Discuss] Running a system command from ColdFusion 09/06/2007 04:17 PM Please respond to [EMAIL PROTECTED] .org : <cfset variables.plsql = "exec DBMS_WM.GoToWorkspace('edsWorkspace')" > SWAG: throw in a PreserveSingleQuotes? /m ------------------------------------------------------------- Annual Sponsor FigLeaf Software - http://www.figleaf.com To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com ------------------------------------------------------------- ------------------------------------------------------------- Annual Sponsor FigLeaf Software - http://www.figleaf.com To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com ------------------------------------------------------------- ------------------------------------------------------------- Annual Sponsor FigLeaf Software - http://www.figleaf.com To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com -------------------------------------------------------------
