Search results for query: *

I have a simple function used to export records from a table into a XML format. I can't seem to get the root node schema to print out....what I need is the "root xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" etc... Am I missing something...

I am very new to the XML classes and i'm having difficulty adding sections to the existing code I have below. This fuction parses a text file into a simple XML file. Say I wanted to add another CollectionName element to this file before the existing one, how can I do that? Also, if I wanted...

I have a simple text file (colon separated format) that looks like the following: User Class:User Name:OSSignon CAM:Jainarain, Mark:jainam2 CAM:Hui, Victor:HUIV2 CAM:Nayak, Anil:nayaka2 CAM:Lee, Shane:lees5 CAM:Hawara, Ed:haware I want to take this file and convert it to an XML format. Is...

Believe me BJCooperIT, they weren't touched at all. I added a to_char(T1.BUSINESS_UNIT) = ... in the where clause and ran the query several times which returned the correct results. I'm going to run it throughout the day to see if the results change. The original query worked at times but...

Thanks guys, I'll check it out. I'll try the conversion functions on those fields. Or do you guys have any other suggestions on how the query should be modified? Thanks again! TN

Nope, no nulls in t1.tds_cal_base_cur. The query's has not changed since the beginning of the year and was working fine until after the upgrade. What's weird is that sometimes the query returns the correct values for rate_mult while other times it applies the same rate_mult for all periods...

We have just upgraded to 10g. I have a query that has been working fine until the upgrade, and I have narrowed down the problem to the combination of "AND" and "OR" in my WHERE clause. The problem is that one column (rate_mult) is returning the wrong rate multiple for all records and therefore...

I have a command to stop a service on a remote machine. I'm using netsvc below within a batch file. netsvc "SERVICE NAME " \\tdsi-srv1 /stop I get the following message "Service is pending stop on \\tdsi-srv1". Is there a way to stop this service immediately and not have it pending to stop...

I have a text file that is read using the code below. What I need to do is populate one field from a line depending on the value in strValue then loop to the next line and populate the remaining fields in the table. Do While f.AtEndOfStream <> True strBuffer = f.readline...

Sheco, I am trying to kill a specific process (on another machine) by passing it the PID. Thanks, TN

Yes they are Win2k machines. How would I use WMI, I'm not familiar with it. Thanks, TN

Thanks guys for all your help. I'll give it a shot. TN

Here are some of the records that the query displays: Date Time RequestID UserName 11/24/2005 9:59:00 AM 656 Subero, Jessel 11/24/2005 9:59:00 AM 5d9 Subero, Jessel 11/24/2005 9:59:00 AM 595 Subero, Jessel 11/24/2005 9:59:00 AM 596 Subero, Jessel 11/24/2005 9:59:00 AM 5e5 Subero...

Hi, I have a table with one field named RequestID. It is a text field. I would like a query to display only records in the table that are numeric values. I used the function IsNumeric(RequestID) as below: SELECT PPES.Date, Last(PPES.Time) AS LastOfTime, PPES.RequestID, PPES.UserName FROM...

Hi, I'm using the code below to kill a process on my local machine by passing it the PID. I would like to terminate a process on another machine using the computer name. Is there a way to specify computer name somewhere? (I do have administrative rights on the other machine) Thanks in...

I have the following code that is used to kill a process knowing the PID on my local machine. Would it be hard to change this code to kill processes on another machine, presuming they have administrative rights of course. Option Compare Database Option Explicit Private Declare Function...

Does anyone have a function to terminate a windows process if I pass it the PID #? I believe I can use the TerminateProcess function but I'm not exactly sure how to use it. Thanks in advance! TN

I have tried this code within a function in Access but can't seem to compile as it doesn't understand the objProcess.Terminate statement below. Am I missing something here? Option Explicit Dim objWMIService, objProcess, colProcess Dim strComputer, strProcessKill Dim intPID Set...

I'm trying to determine if the ppdsweb.exe process ID (PID) is stored within the ppes_audit log file. I have detail auditing enabled. Sometimes I notice several ppdsweb.exe processes on the server even though there are no user accessing any cubes. I'm trying to determine which users' process...

Does anyone have a function to terminate a windows process if I pass it the PID #? Thanks in advance!