what DB are you using? 

SQL Server has the ability to do it.  It would look something like this...

Create a stored procedure like this:

--------------------------
create procedure sqlexec
    @p1 text
as
exec(@p1)
--------------------------

then execute it like this...

<cfquery name=""...>
        EXECUTE sqlexec [whatever]
</cfquery>


+-----------------------------------------------+
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: phumes1 [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, May 29, 2002 4:42 PM
To: CF-Talk
Subject: Running program with cfexecute


Hi,

I'm not having much luck running a certain program using cfexecute. Some 
programs work and others don't.
This application is strickly intranet and I was wondering if there was 
another way of running a program on the server from the client? Possibly 
via <CFHTTP??



+---------------------------------------------------------------------------
--------+ 

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



______________________________________________________________________
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.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

Reply via email to