I need to be able to parse the application log file and send a team member a
list of all error or issues.
I have installed the MS logparser application and I am trying to connect to it
using the cfexecute.
When I run the script from the command promote it works fine and I get the
information, but when I try to use the cfexecute it runs the exe file but only
the default help information is returned.
I believe it has to do with the (") in the string, I have tried to use
#chr(32)# and double quotes but nothing is working.
Anythoughs would be helpful.
Here is what I have now.
<cfoutput><cfsavecontent variable="querytouse">logparser "select * from
C:\ColdFusion8\logs\application.log" -i:csv</cfsavecontent></cfoutput>
<!--- <cfsavecontent variable="querytouse">logparser -h -c</cfsavecontent> --->
<cfexecute name = "C:\Program Files\Log Parser 2.2\logparser.exe"
arguments = "#querytouse#"
variable="items"
timeout = "1">
</cfexecute>
<cfoutput>#items#<cfoutput>
Matt Friedman
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;203748912;27390454;j
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:308488
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
