teemu_selkala
Occasional Contributor
Joined 13 years ago
User Profile
User Widgets
Contributions
Detecting batcher end on DOS command window
Hi, I execute a batch file on a server via command window. Is there a way to detect when the batch file has completed it's run? I mean only thing that happens is that input comes available in the command window again. Currently I am only adding so long delay that it for sure has run the batch but it would be naturally better if I could somehow verify the completition - any hints for that how to manage? Cheers12KViews0likes0CommentsRe: Unable to get selectNode to work =/
I added following and now it returns a node: Doc.setProperty("SelectionNamespaces","xmlns:rs='urn:schemas-microsoft-com:rowset'") But do I always have to do this manually? Add selectionnamespaces from actual xml before I can use selectNodes?796Views0likes0CommentsUnable to get selectNode to work =/
Hi, I have rather large xml file with schema included. I would like to use selectNode to reduce the amount of choises instead of going through each node in the xml file. in my XML file I have a node group as follows: <rs:data> <this and that> </rs:data> but when I try to use selectNode as follows... nodes = Doc.SelectNode("//rs:data") I get an object calling error always. I tried to follow example from: http://support.smartbear.com/viewarticle/32705/ Error is "msxml6.dll reference to undecleared namespace prefix: 'rs' any ideas how to fix that? Cheers14KViews0likes2CommentsUnable to store database tablet values to excel
Hi, I have (again) a problem :) - sorry for flooding the forums. I have a scenario where I have a large set of SQL queries stored in an excel. I would like to run through them and store the values to a new excel but I feel quite dump since I seemingly cannot get a working solution how to get all those tables from DB stored up for saving. Code follows... code runs but I don't get anything when I try to log the results - any hints, should i resturcture completely or anything really is appriachiated a lot :). function checkout() { var Excel = Sys.OleObject("Excel.Application") var searchSQL var result ="" Excel.Workbooks.Open("c:\\MyExcel.xlsx") var RowsCount = Excel.ActiveSheet.UsedRange.Rows.Count; Log.Message(RowsCount) for(i=1;i<RowsCount;i++) { searchSQL = Excel.Cells(i,1); result = result + RunQuery(searchSQL); } RecSet = result; RecSet.Save("c:\\MyAnother.xml",1) Excel.Quit() } function RunQuery(aSQL) { var Conn; Conn= ADO.CreateConnection() Conn.ConnectionString="my connection string"; Conn.Open(); Cmd = ADO.CreateCommand(); Cmd.ActiveConnection = Conn; Cmd.CommandType = adCmdText; Cmd.CommandText = VarToStr(aSQL) RecSet = Cmd.Execute(); var Result = RecSet Log.Message(RecSet) Conn.Close(); return(Result); }15KViews0likes3CommentsError - ORA-00911: invalid character
Hi, I have a list of queries in SQL in an excel to be executed in order to test our database. I try to read them out and do the queries with following code but keep getting this error on subject on bolded part, any ideas why? function checkout() { var Conn var Excel = Sys.OleObject("Excel.Application") Conn= ADO.CreateConnection() Conn.ConnectionString="My connection String"; Conn.Open(); Cmd = ADO.CreateCommand(); Cmd.ActiveConnection = Conn; Cmd.CommandType = adCmdText; Excel.Workbooks.Open("c:\\querys.xlsx") var RowsCount = Excel.ActiveSheet.UsedRange.Rows.Count; for(i=1;i<RowsCount;i++) { Cmd.CommandText = Excel.Cells(i,1) Log.Message(Cmd.CommandText = Excel.Cells(i,1)) // Line below gives the error RecSet = Cmd.Execute(); } RecSet.Save("c:\\tietokanta.xml",1) Conn.Close(); Excel.Quit() }16KViews0likes2Comments