I thought of <cfexecute>, however, the command needs to be executed on
an Oracle server, which is a separate box from the ColdFusion server.
Do you think this might still work?  I guess I could set up a batch file
on the CF server that points to a command on the Oracle server?

Anyway, I'm on vacation starting now and all next week.  I'll check in
then.  Thanks!


ed

----------------------------------------------------------------------
Ed Szwedo

Web Development Team Lead
CSC
E-mail: [EMAIL PROTECTED]
919-541-3955  (Voice)
919-685-3395  (Fax)


                                                                        
             "Gurevich, Gerry                                           
             (NIH/NIEHS) [C]"                                           
             <[EMAIL PROTECTED]                                        To 
             .nih.gov>                <[email protected]>            
             Sent by:                                                cc 
             [EMAIL PROTECTED]                                            
                                                                Subject 
                                      RE: [ACFUG Discuss] Running a     
             09/06/2007 04:26         system command from ColdFusion    
             PM                                                         
                                                                        
                                                                        
              Please respond                                            
                    to                                                  
             [EMAIL PROTECTED]                                           
                   .org                                                 
                                                                        
                                                                        




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: [email protected]
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 <[email protected]>
             [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
-------------------------------------------------------------







-------------------------------------------------------------
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
-------------------------------------------------------------



Reply via email to