Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: tnayfeh
  • Order by date
  1. tnayfeh

    XML output function

    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...
  2. tnayfeh

    Parse file to XML

    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...
  3. tnayfeh

    Text to XML format

    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...
  4. tnayfeh

    Combining "And" with "Or"

    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...
  5. tnayfeh

    Combining "And" with "Or"

    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
  6. tnayfeh

    Combining "And" with "Or"

    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...
  7. tnayfeh

    Combining "And" with "Or"

    ..., T1.ACCOUNT, T1.PRODUCT , T1.DEPTID , T1.CHARTFIELD1, T1.CHARTFIELD2, T1.CHARTFIELD3, T1.FISCAL_YEAR , T1.ACCOUNTING_PERIOD , T1.POSTED_BASE_AMT *1, T1.POSTED_BASE_AMT*T2.RATE_MULT , T2.RATE_MULT from SYSADM.PS_TDS_COG_RATE_VW T2, SYSADM.PS_TDS_COG_MTD_VW T1 where...
  8. tnayfeh

    netsvc to stop service

    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...
  9. tnayfeh

    Popluate fields from different lines

    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...
  10. tnayfeh

    Terminate Process

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

    Terminate Process on another machine

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

    IsNumeric function

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

    IsNumeric function

    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...
  14. tnayfeh

    IsNumeric function

    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...
  15. tnayfeh

    Terminate Process on another machine

    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...
  16. tnayfeh

    Terminate Process

    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...
  17. tnayfeh

    Terminate Windows Process

    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
  18. tnayfeh

    Kill process in Windows

    ..._ & "{impersonationLevel=impersonate}!\\" _ & strComputer & "\root\cimv2") Set colProcess = objWMIService.ExecQuery _ ("Select * from Win32_Process Where ProcessID = " & intPID) For Each objProcess in colProcess objProcess.Terminate() Next WSCript.Echo "Just...
  19. tnayfeh

    PowerPlay ppes_audit log file

    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...
  20. tnayfeh

    Terminate Process

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

Part and Inventory Search

Back
Top