It sure sounds like you need a socket with a listener. I would find an
example already
on the web and use that or add a request for CF 8 to add a feature to tags
which allows
for internal objects to be extended <cfquery name="hello" extended="
com.new.feature">
Override addlisterner() method.
On 8/16/06, powell @ nauticom. net powell @ nauticom. net <
[EMAIL PROTECTED]> wrote:
>
> I'm trying to automate some of an application's database maintentance
> tasks via a CF script that will check to see if it's time for a defrag,
> index rebuild, etc. I know that I can put a DBCC statement in a CFQUERY,
> but what's got me scrambling is how to retrieve any output that the DBCC
> might generate. If I feed CFQUERY something like
> DBCC SHOWCONTIG ('activitylog')
> I'd like to be able to get at the 10 or so lines of of output that it
> would normally generate interactively. But no result set is even created by
> such a query, and I cannot see how to get to the data. I've tried
> variations of EXECUTE and subqueries, all with no luck. Is this an
> impossible dream?
>
> thanks
> Reed
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four
times a year.
http://www.fusionauthority.com/quarterly
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:250031
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
