You can also use native JDBC drivers and a java-esk JDBC connection to get
back
more info than CF gives you. Don't know if it would work in this case...
:Denny
On 8/16/06, Dan Plesse <[EMAIL PROTECTED]> wrote:
>
> 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:250094
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
