transact(ms sql) VS PL SQL(Oracle)

2002-06-11 Thread Amanda Stern

Does anyone have a good article or experiences on the
differences between ms sql and oracle databases...

thanks,


--- phumes1 [EMAIL PROTECTED] wrote:
 I don't know whats happening...
 
 The contents of my output.txt file still contains
 the following. The output 
 to the screen (console) is totally different and
 this is what I want dumped 
 into the output file. The executable is a compiled
 Perl script. Does anyone 
 know how to dump the output of the perl script to a
 file?
 
 
 C:\tempsetlocal
 C:\tempc:
 C:\tempcd c:\temp
 c:\tempc:\program\runme.exe c:\temp\filename
 printer
 
 
 At 11:19 AM 6/7/2002 +0100, you wrote:
   C:\temptest.bat  output.txt
 
 I'd suggest putting a location before the
 output.txt, something like
 
 Test.bat  c:\output.txt
 
 I'm not sure where CFEXECUTE calls the file from...
 
 Philip Arnold
 Technical Director
 Certified ColdFusion Developer
 ASP Multimedia Limited
 Switchboard: +44 (0)20 8680 8099
 Fax: +44 (0)20 8686 7911
 
 www.aspmedia.co.uk
 www.aspevents.net
 
 An ISO9001 registered company.
 

**
 This email and any files transmitted with it are
 confidential and
 intended solely for the use of the individual or
 entity to whom they
 are addressed. If you have received this email in
 error please notify
 the system manager.

**
 
 
   -Original Message-
   From: phumes1 [mailto:[EMAIL PROTECTED]]
   Sent: 06 June 2002 18:27
   To: CF-Talk
   Subject: cfexecute
  
  
   Hi,
  
   This is what I put in my batch file:
  
   test.bat
   
  
   setlocal
   c:
   cd C:\temp
   c:\tempc:\program\runme.exe c:\temp\filename
 printer
  
   Then from the command prompt I did:
  
   C:\temptest.bat  output.txt
  
   The programs run just fine. The program displays
 the
   processing to the screen.
   When I open the file output.txt this is what it
 contains:
  
   C:\tempsetlocal
   C:\tempc:
   C:\tempcd c:\temp
   c:\tempc:\program\runme.exe c:\temp\filename
 printer
  
   I don't know whats going on.
  
   The output.txt file should contain the output
 thats dumped to
   the screen
   but it doesn't.
  
   The executable file is a Perl script which was
 compiled to a
   .exe file.
   Could there be something in the Perl script
 thats stopping
   the output to a
   file?
   Its works to the screen so I can't figure out
 whats happening.
  
   Any ideas?
  
  
  

The bat file seem to be working exactly as you
 tell them to.

In the instance below, when you are calling
 the exe
   directly, you are
rerouting the screen output to the p.log file.

It is routing the ouput of the runme command
 to the log file.

In the CFExecute example you posted earlier,
 you are
   routing the output
from the BAT file to the log file. Not quite
 the same thing.

Try changing the call in the BAT file to match
 your example below,
including the redirected output stream.

(and what are the command switches -e /q /v
 doing for you in the
CFExecute example? Is /q quiet mode, which
 supresses all
   bat file output?)

Now you've got me curious
Jerry Johnson

  [EMAIL PROTECTED] 06/05/02 02:27PM 
Why is my output file empty?

The filename is passed to the executable for
 processing but
   shen I specify
the output to be redirected to a file its
 empty. Why?

Run from command prompt:

c:\tempc:\program\runme.exe c:\temp\filename
 printer  p.log



  
  
  

+-
   --+
  
   Philip Humeniuk
   [EMAIL PROTECTED]
   [EMAIL PROTECTED]
  

+-
   ---+
  
  
  
 


__
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



RE: transact(ms sql) VS PL SQL(Oracle)

2002-06-11 Thread Bryan Love

What do you want to know?

+---+
Bryan Love
  Macromedia Certified Professional
  Internet Application Developer
  Database Analyst
Telecommunication Systems
[EMAIL PROTECTED]
+---+

...'If there must be trouble, let it be in my day, that my child may have
peace'...
- Thomas Paine, The American Crisis



-Original Message-
From: Amanda Stern [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, June 11, 2002 1:52 PM
To: CF-Talk
Subject: transact(ms sql) VS PL SQL(Oracle)


Does anyone have a good article or experiences on the
differences between ms sql and oracle databases...

thanks,


--- phumes1 [EMAIL PROTECTED] wrote:
 I don't know whats happening...
 
 The contents of my output.txt file still contains
 the following. The output 
 to the screen (console) is totally different and
 this is what I want dumped 
 into the output file. The executable is a compiled
 Perl script. Does anyone 
 know how to dump the output of the perl script to a
 file?
 
 
 C:\tempsetlocal
 C:\tempc:
 C:\tempcd c:\temp
 c:\tempc:\program\runme.exe c:\temp\filename
 printer
 
 
 At 11:19 AM 6/7/2002 +0100, you wrote:
   C:\temptest.bat  output.txt
 
 I'd suggest putting a location before the
 output.txt, something like
 
 Test.bat  c:\output.txt
 
 I'm not sure where CFEXECUTE calls the file from...
 
 Philip Arnold
 Technical Director
 Certified ColdFusion Developer
 ASP Multimedia Limited
 Switchboard: +44 (0)20 8680 8099
 Fax: +44 (0)20 8686 7911
 
 www.aspmedia.co.uk
 www.aspevents.net
 
 An ISO9001 registered company.
 

**
 This email and any files transmitted with it are
 confidential and
 intended solely for the use of the individual or
 entity to whom they
 are addressed. If you have received this email in
 error please notify
 the system manager.

**
 
 
   -Original Message-
   From: phumes1 [mailto:[EMAIL PROTECTED]]
   Sent: 06 June 2002 18:27
   To: CF-Talk
   Subject: cfexecute
  
  
   Hi,
  
   This is what I put in my batch file:
  
   test.bat
   
  
   setlocal
   c:
   cd C:\temp
   c:\tempc:\program\runme.exe c:\temp\filename
 printer
  
   Then from the command prompt I did:
  
   C:\temptest.bat  output.txt
  
   The programs run just fine. The program displays
 the
   processing to the screen.
   When I open the file output.txt this is what it
 contains:
  
   C:\tempsetlocal
   C:\tempc:
   C:\tempcd c:\temp
   c:\tempc:\program\runme.exe c:\temp\filename
 printer
  
   I don't know whats going on.
  
   The output.txt file should contain the output
 thats dumped to
   the screen
   but it doesn't.
  
   The executable file is a Perl script which was
 compiled to a
   .exe file.
   Could there be something in the Perl script
 thats stopping
   the output to a
   file?
   Its works to the screen so I can't figure out
 whats happening.
  
   Any ideas?
  
  
  

The bat file seem to be working exactly as you
 tell them to.

In the instance below, when you are calling
 the exe
   directly, you are
rerouting the screen output to the p.log file.

It is routing the ouput of the runme command
 to the log file.

In the CFExecute example you posted earlier,
 you are
   routing the output
from the BAT file to the log file. Not quite
 the same thing.

Try changing the call in the BAT file to match
 your example below,
including the redirected output stream.

(and what are the command switches -e /q /v
 doing for you in the
CFExecute example? Is /q quiet mode, which
 supresses all
   bat file output?)

Now you've got me curious
Jerry Johnson

  [EMAIL PROTECTED] 06/05/02 02:27PM 
Why is my output file empty?

The filename is passed to the executable for
 processing but
   shen I specify
the output to be redirected to a file its
 empty. Why?

Run from command prompt:

c:\tempc:\program\runme.exe c:\temp\filename
 printer  p.log



  
  
  

+-
   --+
  
   Philip Humeniuk
   [EMAIL PROTECTED]
   [EMAIL PROTECTED]
  

+-
   ---+
  
  
  
 



__
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
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists