Disabling CANCEL button during shell file copy

TheMSsForum.com: The Microsoft Software Forum

The MSS Forum ‹ VBscripts
- Archive
  - Biz
  - MCSE
  - CRM
  - Drivers
  - Framework
  - ADO
  - ASP
  - Compact
  - Forms
  - Dotnet
  - C#
  - VB
  - FontpageGen
  - Excel
  - WorkSheet
  - Exchange
  - Setup
  - Fox
  - Fontpage
  - ASP
  - IIS
  - Entourage
  - Money
  - Messanger
  - PocketPC
  - Powerpoint
  - Project
  - Publisher
  - Excel
  - VB
  - Security
  - Portal
  - Services
  - SQLServerDev
  - SVCS
  - SQLServer
  - VB
  - VC
  - MFC
  - ExcelGen

- Previous
  - 1
    - username and computer name in vbscript/asp/java/wsh? Hi, I have seen this topic come up many times but have never really seen a concise answer to the problem. Basically what I have is an asp page that is using ado to do some database queries. I have an activity log table in my database that I would also like to update when certain events are triggered on the webpage. In this activity log I wanted to have the network username and the computer name of the person that was using the webpage. I thought VBScript would be best for this because it runs client-side but I have not found a solution yet. Though this webpage will be running on my company's intranet, we are a company of 6000 and I have absolutely NO control over the server it will be running on. Any help would be awesome. Thanks! -Jeremy Tag: Disabling CANCEL button during shell file copy Tag: 141805
  - 2
    - transfering data from .csv to .xls Hi, I am using Activex scripts in SQL Server DTS Packages to read from a .csv file and write it to a Excel file. The actual problem is the leading zeroes are being truncated in the XL file. Hence, I use ActiveSheet.QueryTables.Add method to define the formating properties that I require. It creates the Excel file successfully but it neither transfers the data nor does it format the cells. Below is my code. Pls. let me know if I am going with the right approach. VERY URGENT. If any of you can suggest me an alternate way on how I can transfer the data from .csv to .xls without loosing the leading zeroes, I would be really grateful. with regards, Ram Function Main() Dim Xcl Dim strDestinationFileName Dim strSourceFileName 'strDestinationFileName = "D:\_Clients_Data\Monument\Order\vipul2.xls" strSourceFileName = DTSGlobalVariables ("Data_File_Path")&DTSGlobalVariables("Data_File_Name") strDestinationFileName = DTSGlobalVariables ("Schema_File_Path")&DTSGlobalVariables ("Schema_File_Name") Set Xcl = CreateObject("Excel.Application") Xcl.Visible = true Set newBook = Xcl.Workbooks.Add newBook.Worksheets(1).Name="My First WorkSheet" newBook.Worksheets(2).delete newBook.Worksheets(2).delete newbook.Worksheets(1).Activate 'importing the .csv file With ActiveSheet.QueryTables.Add (Connection:= "TEXT; D:\_Clients_Data\Monument\Order\09- 03_Order_Monument.csv", Destination:= Range ("A1") ) .Name = strDestinationFileName .FieldNames = True .RowNumbers = False .FillAdjacentFormulas = False .PreserveFormatting = True .RefreshOnFileOpen = False .RefreshStyle = xlInsertDeleteCells .SavePassword = False .SaveData = True .AdjustColumnWidth = True .RefreshPeriod = 0 .TextFilePromptOnRefresh = False .TextFilePlatform = xlWindows .TextFileStartRow = 1 .TextFileParseType = xlDelimited .TextFileTextQualifier = xlTextQualifierDoubleQuote .TextFileConsecutiveDelimiter = False .TextFileTabDelimiter = False .TextFileSemicolonDelimiter = False .TextFileSpaceDelimiter = False .TextFileColumnDataTypes = Array(2, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1) .Refresh BackgroundQuery:= False End With newBook.SaveAs strDestinationFileName Xcl.Visible = false Set Xcl = nothing Main = DTSTaskExecResult_Success End Function Tag: Disabling CANCEL button during shell file copy Tag: 141804
  - 3
    - writing text file in ASP hello All. i am using the FSO to write a text file derived from a database.. see code. however i am getting a 'permission denied' error message: Error Type: Microsoft VBScript runtime (0x800A0046) Permission denied /invoice/nv_rebuild.asp, line 101 what an i doing wrong here?.. or maybe someone has some example code that works!. Help!.. _____code starts here________ <%@ LANGUAGE="vbscript" %> <% Option Explicit Response.Buffer = TRUE Dim strSqlTxt Dim strInvoiceNo Dim strInvoiceDate Dim strDivisionCode Dim strCustCode Dim strLaborHours Dim strLaborCost Dim strEstimateNo Dim strAmount Dim strEquipNo Dim strWorkOrderNo Dim strMaterialCost Dim strEstimateLaborHours Dim strEstimateLaborCost Dim strEstimateMaterialCost Dim strTotalWorkCost Dim conntemp Dim rstemp Dim strStreamLine Dim objFSO Dim objTStream Dim objFileObject RebuildInvoices() Sub RebuildInvoices() SetSqlRebuildInvoices() OpenInvoiceConnect() Do Until rstemp.EOF SetInvoiceValues() WriteValues() OpenOutFile() StreamOutFile() rstemp.MoveNext Loop objTStream.Close CloseInvoiceConnect() End Sub Sub SetSqlRebuildInvoices() strSqlTxt = "SELECT " strSqlTxt = strSqlTxt & "a.invoice_no, " strSqlTxt = strSqlTxt & "a.invoice_date, " strSqlTxt = strSqlTxt & "a.division_code, " strSqlTxt = strSqlTxt & "a.cust_code, " strSqlTxt = strSqlTxt & "a.labor_hrs, " strSqlTxt = strSqlTxt & "a.labor_cost, " strSqlTxt = strSqlTxt & "a.material_cost, " strSqlTxt = strSqlTxt & "a.amount, " strSqlTxt = strSqlTxt & "b.estimate_no, " strSqlTxt = strSqlTxt & "b.work_order_no, " strSqlTxt = strSqlTxt & "c.equip_no, " strSqlTxt = strSqlTxt & "c.labor_hrs AS estimate_labor_hours, " strSqlTxt = strSqlTxt & "c.labor_cost AS estimate_labor_cost, " strSqlTxt = strSqlTxt & "c.material_cost AS estimate_material_cost " strSqlTxt = strSqlTxt & "FROM " strSqlTxt = strSqlTxt & "gblsql.tradedepot.dbo.invoice_header A, " strSqlTxt = strSqlTxt & "gblsql.tradedepot.dbo.work_order B, " strSqlTxt = strSqlTxt & "gblsql.tradedepot.dbo.equip_damage_list C " strSqlTxt = strSqlTxt & "WHERE " strSqlTxt = strSqlTxt & "a.invoice_no BETWEEN '310801' AND '310850' " strSqlTxt = strSqlTxt & "AND a.invoice_no = b.invoice_no " strSqlTxt = strSqlTxt & "AND c.estimate_no = b.estimate_no " strSqlTxt = strSqlTxt & "ORDER BY " strSqlTxt = strSqlTxt & "a.invoice_no " End Sub Sub SetInvoiceValues() strInvoiceNo = rstemp("invoice_no") strInvoiceDate = rstemp("invoice_date") strDivisionCode = rstemp("division_code") strCustCode = rstemp("cust_code") strLaborHours = rstemp("labor_hrs") strLaborCost = rstemp("labor_cost") strMaterialCost = rstemp("material_cost") strAmount = rstemp("amount") strEstimateNo = rstemp("estimate_no") strWorkOrderNo = rstemp("work_order_no") strEquipNo = rstemp("equip_no") strEstimateLaborHours = rstemp("estimate_labor_hours") strEstimateLaborCost = rstemp("estimate_labor_cost") strEstimateMaterialCost = rstemp("estimate_material_cost") strTotalWorkCost = Cint(strEstimateLaborCost) + Cint(strEstimateMaterialCost) End Sub Sub OpenOutFile() Set objFSO = Server.CreateObject ("Scripting.FileSystemObject") Set objTStream = objFSO.CreateTextFile ("C:\downloads\invoice.txt", True, False) End Sub Sub StreamOutFile() strStreamLine = strInvoiceNo & strInvoiceDate & strDivisionCode & strCustCode & strLaborHours & strLaborCost & strMaterialCost & strAmount & strEstimateNo & strLaborCost & strAmount & strWorkOrderNo & strEquipNo & strEstimateLaborHours & strEstimateLaborCost & strEstimateMaterialCost & strTotalWorkCost objTStream.Writeline strStreamLine End Sub Sub WriteValues() response.write strInvoiceNo response.write strInvoiceDate response.write strDivisionCode response.write strCustCode response.write strLaborHours response.write strLaborCost response.write strMaterialCost response.write strAmount response.write strEstimateNo response.write strLaborCost response.write strAmount response.write strWorkOrderNo response.write strEquipNo response.write strEstimateLaborHours response.write strEstimateLaborCost response.write strEstimateMaterialCost response.write strTotalWorkCost response.write "<br>" End Sub Sub OpenInvoiceConnect() set conntemp = server.createobject("adodb.connection") conntemp.Open "Provider=sqloledb;Data Source=GBLSQL;Initial Catalog=tradedepot;User Id=tradedepot;Password=tradedepot" set rstemp = conntemp.execute(strSqlTxt) End Sub Sub CloseInvoiceConnect() rstemp.Close Set conntemp = NOTHING End Sub %> _______code ends here _______________ Tag: Disabling CANCEL button during shell file copy Tag: 141799
  - 4
    - Highlight Text in Control Greetings, I am not sure if this is possible, but within ArcPad Studio 6.0.1.2OU (ArcPAd is basically pared down desktop GIS software for PDAs). I am doing my development on a Windows 2000 machine, but the resultant code is placed on an IPaq handheld. I have an edit control in a form. The control is bound to a DBF file and shows data if it is populated or "0" (integer field in the DBF) if it is not. I want to be able to highlight whatever text is in that control (i.e. background of selected text is navy blue, the text is white, and the caret/cursor is all the way to the right of the selected string). The tools that are being written are for handheld devices that field workers will be utilizing with a stylus. The fewer the clicks/taps they must make with the stylus, the more efficient their use of our tool. Any idea then, on how to highlight text in a VBScript edit control ? Best regards, Jason Ramirez ...I know, I'm garrulous :) Tag: Disabling CANCEL button during shell file copy Tag: 141791
  - 5
    - Could not load type '****.Global' I'm working my way through the .net Mappoint Web services sample code, but I keep experiencing this error - "Could not load type '****.Global'" (where **** is the application name). I've had a look through the news group for similar problems but I've had no luck with of the suggested solutions. For the record I've checked that the projects been built, the web service is correctly named and the application is set up in IIS. Any other suggestions? Tag: Disabling CANCEL button during shell file copy Tag: 141786
  - 6
    - Output PDF I have the following code ... Const ForReading = 1, ForWriting = 2, ForAppending = 8 Const TristateUseDefault = -2, TristateTrue = -1, TristateFalse = 0 Dim fso, f, ts Set fso = CreateObject("Scripting.FileSystemObject") strPhyPath = Server.MapPath("/paysonnelCE/Misc/Bernard") Set f = fso.GetFile(strPhyPath & "\test.pdf") Set ts = f.OpenAsTextStream(ForReading, TristateUseDefault) Response.Buffer = True Response.ContentType = "application/pdf" Response.BinaryWrite ts.ReadAll Response.Flush the purpose is to stream a pdf to client... but all I get is the details, ascii codes of the pdf ... anyway I can get a pdf instead of ascii text display ? Tag: Disabling CANCEL button during shell file copy Tag: 141782
  - 7
    - Remote comuter access + FileSystemObject? Hi! :-) I'd like to know if it's possible to access the FileSystemObject on a remote machine. In this case to check the remainging space on the HDs of my file server. Right now I can only access the local machine with: Set objFileSystem = CreateObject("Scripting.FileSystemObject") For Each objDrive In objFileSystem.Drives If objDrive.DriveType = 2 Then 'Local Disc WScript.Echo objDrive.Path WScript.Echo "Size: " & objDrive.TotalSize WScript.Echo "Free: " & objDrive.FreeSpace ... End If Next And check the directory sizes with: Set objFolder = objFileSystem.GetFolder(strPath) WScript.Echo strPath & " " & objFolder.Size Is it at all possible to do this on a remote mashine and if so, how? Thanks a million! :-) /Sofia Engvall AB Ångpanneföreningen Tag: Disabling CANCEL button during shell file copy Tag: 141781
  - 8
    - convert an html form post to a script Hi I have a form that posts to a CGI script. I would like to automatically send multi posts to the CGI Script. Can anyone point me in the direction of how to I can emulate the form post from inside a Script? Regards and Thanks!!! Meir Tag: Disabling CANCEL button during shell file copy Tag: 141780
  - 9
    - How to delete all jobs in a print queue by vbs? Hi there, Does anyone know how to delete all jobs in a print queue by vbs? When I restart one of my Company's printer, all old print jobs will print again, so I want to write a script to fix it. Thank you in advanced. Regards, Stanley Tag: Disabling CANCEL button during shell file copy Tag: 141775
  - 10
    - find a string in a file Hello, I am writing a VBString, what is the fastest way to open a file and search a string and read a few characters after that string? Thanks, Jim. Tag: Disabling CANCEL button during shell file copy Tag: 141768
  - 11
    - Displaying line number with custom error message? Hello; I'm trying to create a custom error capturing function that writes VBScript errors to the computer's Event Log. I've been able to do most of what I want so far, but I can't figure out how to write the line number of where the error occurred... is that even possible? Sincerely, Todd M. Taylor Tag: Disabling CANCEL button during shell file copy Tag: 141760
  - 12
    - How to read a text file from web server Hi guys, Does anybody know how to read a text file from web server? For example, read test.txt file from: http://abc/test.txt Any comments will be highly appreciated. Thanks Tag: Disabling CANCEL button during shell file copy Tag: 141755
  - 13
    - Computer name Hello all, I want to use a list of computers that I have serial numbers and corresponding asset numbers for to rename the computers. I have the compname.exe that works great but want to go a step further. Is there a way to have vbscript detect the serial number of a computer then use a list that associates a different name to the serial number and have the script rename based on that? Step 1: Identify & Capture serial number Step 2: Compare serial number to list ie serial number asset number 123456 abcdefg Step 3: Rename the computer so that if serial number = 123456 then computername = abcdefg. Thanks in advance for any help. Tag: Disabling CANCEL button during shell file copy Tag: 141753
  - 14
    - [newbie] Status of ActiveX-based web apps? Hi, We're currently checking out all our options to move from VB-written dedicated apps to web applications, and that obviously includes pages that include ActiveX and VBScript. I took a look on Amazon, and noticed the dearth of books on the subject. Hence my question : Apart from the fact that the ActiveX + VBScript is an MS-only solution (which is not an issue with our customers)... why so much exposure for Java or .Net, and so little for this alternative? Are there technical issues that we'll see later as we investigate further? Thx for any feedback JD. Tag: Disabling CANCEL button during shell file copy Tag: 141751
  - 15
    - Copy folder and progress bar. Does anyone know of an efficient way of reporting the status (% complete) of the folderobject.copy method? I'm using the following to copy fair amounts of data (700 - 1000 Mb) in a complexe directory structure. ******************* Set fso = CreateObject("Scripting.FileSystemObject") Set folderObject = fso.GetFolder("D:\somepath") folderObject.Copy "e:\",TRUE ****************** I need to be able to show progress in either a progress bar or at the vey least by feeding a percentage completed to a log windows.(wihich I already have built using IE and an hta form. Thanks Pierre Tag: Disabling CANCEL button during shell file copy Tag: 141749
  - 16
    - WSH 5.6 debugging is available now! Script Debugger IDE supports WSH debugging now! New features you can see here: http://www.script-debugger.com/products/scrdebugger/debugwsh.asp Tag: Disabling CANCEL button during shell file copy Tag: 141743
  - 17
    - Script problems (write routine) Hello I have a VBScript that sometimes works fine but often sucks - problem in combination with WSH? 1st here is the part of the script making trouble: (note: following URL is an example) private function writefile() GetURL = www.someurl.com\index.php3?TYPE=Right Dim Http Set Http = CreateObject("Microsoft.XMLhttp") Http.Open "GET",GetURL,False Http.Send HtmlResult = Http.ResponseText HtmlResult = right(HtmlResult, len(HtmlResult) - instr(HtmlResult, "")) HtmlResult = left(HtmlResult, len(HtmlResult) - instr(HtmlResult, "</body>")) Set Http = Nothing set fs=CreateObject("Scripting.FileSystemObject") set f1=fs.CreateTextFile("test.tmp",true) f1.write(HtmlResult) f1.close set f1=nothing set fs=nothing writefile = "Tempfile written." end function OK however the script only works when: - I installed WSH 5.6 (is there a localized version oder only english?) and reboot - and run this script (in a Application supporting VBS-files) and it works fine but - after next reboot the Script terminates and also the application script is running in terminates unexpected without promting or an failure message. Only when I re-install the WSH and after 1st reboot script also works. So is this a WSH-Bug or where's the problem? Note: I guess, the problem is the .write - routine because when the script terminates, no such file has been written. Kind regards, Torsten -- "Outside is where the pizza comes from" Tag: Disabling CANCEL button during shell file copy Tag: 141738
  - 18
    - Generalized Time How to read out the AD-property "createTimeStamp" (data type GeneralizedTime) of an user object and convert to a readable string like dd/mm/yyyy ? Thanks for help Tag: Disabling CANCEL button during shell file copy Tag: 141733
  - 19
    - send SMS Hi at all! Could anyone to say me how to send SMS using ASP/VBSCRIPT page? Thanks Tag: Disabling CANCEL button during shell file copy Tag: 141730
  - 20
    - Server.MapPath Hello, I have an ActiveX-DLL (using VB-script) that creates some files. When I use a direct path ("c:\wwwroot\...), the script works fine (see below) But if I use the Server.MapPath() there is an error: "Object required" When I use the code in an ordinary .asp-file the Server.MapPath works fine. ' ----- Create the .fil-file Set fs = CreateObject("Scripting.FileSystemObject") Set f = fs.CreateTextFile("c:\inetpub\wwwroot\catalog\" & temp & "\" & fname & ".fil", True) ' Set f = fs.CreateTextFile(Server.MapPath(temp & "\" & fname & ".fil", True)) Anyone know what I can do? Regards, /Mikael S Tag: Disabling CANCEL button during shell file copy Tag: 141729
  - 21
    - IP Address (Simplest script possible) I want to put in my websote to grab the clients IP address and write it out. Any help would ne great thanks! Tag: Disabling CANCEL button during shell file copy Tag: 141720
  - 22
    - how to debug .vbs script? I'm running win2000 sp3 - and have VS.NET 2003 installed - as well as Visual Studio - and the script debugger. I'd like to be able to open a test.vbs script in a debugger (not run it in IE, but as a stand alone ap) and set a breakpoint and run it - but how to accomplish this simple task eludes me. What is the best way to do this? I've got some .vbs scripts (that go with some MS .NET sample code) that do not seem to work - and I'd like to fix them rather than wait on MS. -- Thanks in advance, Les Caudle Tag: Disabling CANCEL button during shell file copy Tag: 141719
  - 23
    - write to a file Hello, I do not know anything about VBScript yet. How can I write a vbs file in windows 2000 that handles the following? 1. Open a text file 2. jump a few lines 3. read the rest of lines and write to another file 4. exit Any Help? Thanks Jim. Tag: Disabling CANCEL button during shell file copy Tag: 141716
  - 24
    - GetFile Method, ASP 3.0 & VBScript, Win NT 4.0 Server This line of code is causing IIS 4.0 on Win NT 4.0 server to hang infinately... set objFile = objFSO.GetFile(strPhysicalPath) The code works as expected on IIS 5.0/Win 2000 server. When I comment out that line the page will display with no problem. I have reinstalled the scripting runtime library 3 times (scr56en.exe). Is there an issue with the GetFile method of the FileSytemObject on Win NT 4.0 that I need to know about? Please advise. thanks, Ron p.s. the server has Service Pack 6a, and all security patches as of today. Tag: Disabling CANCEL button during shell file copy Tag: 141708
  - 25
    - SQL VBscript Class help needed Hi All. Win 2kpro, sql server 2k, iis5 vbscript asp Learning vbscript I was wondering if anyone could help me with a VBscript CLASS I have that I use for connecting to our database and execute stored procs. I've included my CLASS to this message. Could someone please take a look at it and possibly correct & alter it to make it better. One bit I would like added is to beable to RETURN a value from a Stored Procedure rather than a recordset using the class. I've tried to comment it as much & clear as I can. If anyone has any useful vbscript CLASS code that they wouldn't mind sharing - I'd appreciate it. Thanks for all the help & tips in advance. Al <% '|¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯| '| Class : clsDBErrorChecker | '| Language : VBscript | '| Description : Used for checking DB for errors & Executing SQLs | '| Copyright : (c) 2003 Alan Spencer (Harag) | '|---------------------------------------------------------------------------------------------------------------------| '| Properties : TotalErrors (read) | '| : AnyErrors (read) | '| : ExtraInfo (Write) | '| : InFunction (write) | '| : ConnectAs (write) | '|---------------------------------------------------------------------------------------------------------------------| '| Methods : OpenDBConnection | '| : CloseDBConnection | '| : BeginTrans | '| : CommitTrans | '| : RollbackTrans | '| : Execute (sql, ReturnRS? T/F) | '| : OpenRS (sql, cursortype, locktype, options) | '| : OpenIntoArray (sql, Rows,Start,Array(fileds)) | '| : ClearErrors | '| : GetFullError(x) | '| : GetAllFullErrors | '| : GetUserDefinedError | '| : SetInfo | '| : ResetInfo | '|---------------------------------------------------------------------------------------------------------------------| '| Private : (S) ReportConnectionClosed | '| : (F) IsConnectionOpen | '| : (S) UpdateConnectionString | '|______________________________________________________________________________| '|¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯| '| Options : adCmdText, adCmdStoredProc, adExecuteNoRecords | '|______________________________________________________________________________| '| EXAMPLE OF USAGE (copy the text below and uncomment all the first rem) | '¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯ ' In Global.asa file: ' ***user*** & ***pass*** are altered via the DBclass ' Application("sDBConnection") = "Provider=SQLOLEDB; Data Source=(local); Initial Catalog=dbnamehere; User ID=[***USER***]; Password=[***PASS***]; Persist Security Info=True" ' --------------------------------------------------------------------------------------------------------------------- ' ' 'Declare class ' DIM clsDBCheck, oRSfoobar ' set clsDBCheck = new clsDBErrorChecker ' ' Set the connection username ' clsDBCheck.ConnectAs = CONNECTAS_VSUser ' CONNECTAS_VSUser is the default ' ' ' Setup info code incase of error ' clsDBCheck.SetInfo "YourFunctionName", "Some info for finding line in code easier. eg a linenumber or section header" ' ' create SQL string ' sSQL="usp_TEST_DisplaySecurityLevelUsers 16" ' ' ' run SQL string ' set oRSfoobar = clsDBCheck.OpenRS (sSQL, adOpenKeySet, adLockPessimistic) ' ' ***OR *** ' set oRSfoobar = clsDBCheck.Execute (sSQL, true) ' return records ' ' ***OR *** ' clsDBCheck.Execute (sSQL, false) ' return no records ' ' ***OR *** ' MyArray = clsDBCheck.OpenIntoArray (sSQL, 0, 0, "") ' ' ' if any errors then report the errors else do stuff with record set. ' if clsDBCheck.AnyErrors then ' Out clsDBCheck.GetAllFullErrors ' else ' ' SQL ran with no errors. ' if not oRSfoobar.BOF and not oRSfoobar.EOF then ' do ' ' Do some stuff here ' oRSfoobar.MoveNext ' loop until oRSfoobar.EOF ' end if ' oRSfoobar.Close ' end if ' ' ' Finally close & free memory ' clsDBCheck.CloseDBConnection ' set clsDBCheck = nothing '_______________________________________________________________________________ '|XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX| '¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯ '|¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯| '| S T A R T O F T H E C L A S S | '|______________________________________________________________________________| CONST NO_EXTRA_INFO = "<B><I>***None***</B></I>" ' default extra info text (const) CONST IN_FUNCTION = "<B><I>***Main***</B></I>" ' default function text (const) ' these are for DB security to connect using different login names CONST CONNECTAS_User =1 CONST CONNECTAS_Admin =2 CONST CONNECTAS_Executive =3 CONST CONNECTAS_MAX=3 CLASS clsDBErrorChecker '_____________________________________ '| Declare some PRIVATE variables for the class | '¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯ PRIVATE msConnString ' String holding the actual Connection info PRIVATE moConnection ' Connect object to the DB - ADODB.Connection PRIVATE mbIsConnectionOpen ' Boolean True if connetted to DB PRIVATE miConnectAs ' Username/password ID for connecting to DB PRIVATE maConnectAsArray(3,1) ' Array of users & Passwords PRIVATE msExecutedSQL ' The executed SQL PRIVATE msExtraInfo ' Extra info for the error results PRIVATE msInFunction ' stores the function name set for error results '|¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯| '| I N I T I A L I Z E F U N C T I O N S | '|______________________________________________________________________________| ' Initialize the class, set up default variables erc. PRIVATE SUB Class_Initialize msExtraInfo = NO_EXTRA_INFO msInFunction = IN_FUNCTION mbIsConnectionOpen=false ' set the default user to connect as (public) miConnectAs= CONNECTAS_User ' load all the username & passwords into an array maConnectAsArray (CONNECTAS_User, 0) = "publicusernamehere" maConnectAsArray (CONNECTAS_User, 1) = "userpasswordhere" maConnectAsArray (CONNECTAS_Admin, 0) = "siteadminusername" maConnectAsArray (CONNECTAS_Admin, 1) = "adminpassword" maConnectAsArray (CONNECTAS_Executive, 0) = "dbousernamehere" maConnectAsArray (CONNECTAS_Executive, 1) = "executivepasswordhere" UpdateConnectionString ' Create The connection Object for the class set moConnection = Server.CreateObject ("ADODB.Connection") END SUB '|¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯| ' When class is terminated also terminate the connection to the DB to free up resources PRIVATE SUB Class_Terminate ' Close the connection Object and clear it CloseDBConnection set moConnection=nothing END SUB '|¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯| '| P R O P E R T I E S | '|______________________________________________________________________________| ' will return 0 if none or >0 if there is any. PUBLIC Property get AnyErrors if TotalErrors >0 then AnyErrors=true else AnyErrors=false end if End Property '|¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯| ' returns the number of DB errors ' If warnings then reduces the number. ' eg "Cursor Type Changed" PUBLIC Property get TotalErrors DIM TotErr, NatErr, x, xx TotErr = moConnection.Errors.Count if TotErr > 0 then xx = TotErr - 1 for x = 0 to xx NatErr = moConnection.Errors.Item(x).NativeError if NatErr = 0 then TotErr = TotErr - 1 end if Next end if TotalErrors=TotErr End Property '|¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯| ' changes the connection string to a new username & password as some Stored procs have ' different permissions from "public" PUBLIC Property let ConnectAs (ByVal iNewConnect) if iNewConnect <1 or iNewConnect > CONNECTAS_MAX then iNewConnect = CONNECTAS_user end if ' if changing to a new connect user then close DB and reset ConnectionStr if miConnectAs <> iNewConnect then miConnectAs =iNewConnect UpdateConnectionString CloseDBConnection end if End Property '|¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯| ' stores a string incase error is found and displayed, put handy info to find line in code PUBLIC Property let ExtraInfo (ByVal sInfo) sInfo=trim(sInfo) if sInfo="" then msExtraInfo = NO_EXTRA_INFO else msExtraInfo = sInfo end if End Property '|¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯| ' If Executing a SQL/stored proc in a FUNCTION then set this to the FUNCTION name for ease of finding error PUBLIC Property let InFunction (ByVal sInfo) sInfo = trim(sInfo) if sInfo = "" then msInFunction = IN_FUNCTION else msInFunction = sInfo end if End Property '|¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯| '| F U N C T I O N S / S U B S | '|______________________________________________________________________________| ' Opens up a connection to the DB - String must be valid connection str. 'eg: "Provider=SQLOLEDB; Data Source=ServerName; Initial Catalog=DBName; User ID=UserName; Password=UserPassowrd; Persist Security Info=True" ' this string is altered using the "connectAs system" PUBLIC SUB OpenDBConnection(ByVal sConnectionString) moConnection.Open sConnectionString mbIsConnectionOpen = true END SUB '|¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯| ' Closes a connection to the DB PUBLIC SUB CloseDBConnection () if mbIsConnectionOpen then moConnection.Close mbIsConnectionOpen = false end if END SUB '|¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯| ' Begin a DB transaction PUBLIC SUB BeginTrans() if IsConnectionOpen then moConnection.BeginTrans end if END SUB '|¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯| ' Commit the transaction PUBLIC SUB CommitTrans() if IsConnectionOpen then moConnection.CommitTrans End if END SUB '|¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯| ' Rollback the DB transaction PUBLIC SUB RollbackTrans() if IsConnectionOpen then moConnection.RollbackTrans End if END SUB '|¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯| ' Execute a SQL/storedproc on the DB ' NOTE: returns with a CursorType of FORWARD_ONLY - if you want a different cursor type then ' use the "OpenRS" function PUBLIC FUNCTION Execute (ByVal sSQL, ByVal bReturnRS) DIM rs, lOptions lOptions = adCmdUnknown if IsConnectionOpen then if not bReturnRS then lOptions = lOptions+adExecuteNoRecords end if msExecutedSQL=sSQL on error resume next set rs = moConnection.execute (msExecutedSQL, ,lOptions) on error goto 0 if TotalErrors>0 then if not lOptions AND adExecuteNoRecords then set Execute = Server.CreateObject ("ADODB.Recordset") end if else if not lOptions AND adExecuteNoRecords then set Execute=rs end if end if end if set rs=nothing END FUNCTION '|¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯| ' set oRSfoobar = clsDBCheck.OpenRS (sSQL, adOpenKeySet, adLockPessimistic) ' CursorType, LockType, Options ' Allows you to set a cursor type to override executes default PUBLIC FUNCTION OpenRS (ByVal sSQL, ByVal iCursorType, ByVal iLockType) ' adOpenKeySet, adLockPessimistic DIM rs if IsConnectionOpen then set rs=Server.CreateObject ("ADODB.Recordset") rs.CursorLocation=adUseClient msExecutedSQL=sSQL on error resume next rs.Open msExecutedSQL, moConnection, iCursorType, iLockType on error goto 0 if TotalErrors>0 then set OpenRS = Server.CreateObject ("ADODB.Recordset") else set OpenRS=rs end if end if set rs=nothing END FUNCTION '|¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯| ' Run an SQL/StoredProc and load the recordset into an array. PUBLIC FUNCTION OpenIntoArray (ByVal sSQL, iRows, iStart, aFieldsArray) DIM rs if IsConnectionOpen then if iRows=0 then iRows=adGetRowsRest ' get all rows if iStart=0 then iStart=adBookmarkfirst ' start at the begining msExecutedSQL=sSQL set rs= OpenRS (msExecutedSQL, adOpenStatic, adLockPessimistic) if TotalErrors>0 then OpenIntoArray = "" ' return a string so user can check for (IsArray) else if not rs.BOF and not rs.EOF then if IsArray(aFieldsArray) then OpenIntoArray = rs.getrows(iRows, iStart, aFieldsArray) else OpenIntoArray = rs.getrows(iRows, iStart) end if else OpenIntoArray=null end if end if end if set rs=nothing END FUNCTION '|¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯| ' clear the errors if your want... not really needed PUBLIC SUB ClearErrors moConnection.Errors.clear END SUB '|¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯| ' returns a string of ONE error in an HTML format. PUBLIC FUNCTION GetFullError(ByVal iErr) DIM Tot, sTemp, En, errErrors ' 3621 = The statement has been terminated Tot=TotalErrors set errErrors = moConnection.Errors.Item(iErr) if Tot>0 and iErr>=0 and iErr<=Tot-1 then sTemp="" En=errErrors.NativeError if en <50000 then if en <> 3621 then sTemp=sTemp & "<P STYLE=""text-align:left""><SPAN STYLE=""color:#990000""><B>DB ERROR:</B></SPAN> <B>[File: </B>"&Request.ServerVariables ("SCRIPT_NAME")&"<B>]</B> " sTemp=sTemp & "<BR><B>[User:</B>"&maConnectAsArray (miConnectAs, 0) &"<B>]</B><B>[Func: </B>"&msInFunction&"<B>]</B><B>[xInfo: </B>"&msExtraInfo&"<B>]</B>" sTemp=sTemp & "<BR><B>[ERR SRC: </B>" & errErrors.source &"<B>]</B>" sTemp=sTemp & "<BR><B>[NativeError: </B>" & errErrors.NativeError &"<B>]</B> <B>[Err Number: </B>"&errErrors.number & "<B>]</B> <B>[SQLstate: </B>"&errErrors.SQLState & "<B>]</B>" sTemp=sTemp & "<BR><B>[Desc: </B>"& errErrors.Description&"<B>]</B>" sTemp=sTemp & "<BR><B>[SQL: </B>"&msExecutedSQL&"<B>]</B>" end if else sTemp=GetUserDefinedError end if end if set errErrors = nothing GetFullError=sTemp END FUNCTION '|¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯| ' returns a string of all the errors found in HTML format. PUBLIC FUNCTION GetAllFullErrors DIM tot, x, sTemp Tot=TotalErrors sTemp="" if tot>0 then for x = 0 to Tot-1 sTemp=sTemp & GetFullError(x) next end if GetAllFullErrors=sTemp END FUNCTION '|¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯| ' if use "RAISERROR ("some text",16,1) in an SQL Stored Proc then this will return just the ' "Some Text" part of the error to a string. PUBLIC FUNCTION GetUserDefinedError DIM tot, x, sTemp Tot=TotalErrors sTemp="" if Tot>0 then for x = 0 to Tot-1 if moConnection.Errors.Item(x).NativeError >=50000 then sTemp=sTemp & "<BR><B>[NativeError: </B>" & moConnection.Errors.Item(x).NativeError &"<B>]</B>" sTemp=sTemp &"<B>[ERROR: </B>"& moConnection.Errors.Item(x).Description&"<B>] </B>" 'sTemp=sTemp &"<B>[ERROR: </B>"& mid(moConnection.Errors.Item(x).Description, InstrRev(moConnection.Errors.Item(x).Description,"[SQL Server]")+12)&"<B>] </B>" end if next end if GetUserDefinedError=sTemp END FUNCTION '|¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯| ' A Quick way to set the ExtraInfo & InFunction parameters. PUBLIC SUB SetInfo (ByVal sWhatFunction, ByVal sWhatInfo) InFunction = sWhatFunction ExtraInfo =sWhatInfo END SUB '|¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯| ' This resets the ExtraInfo & InFunction strings to the default values. ' Best place to run this is at the end of a function/sub PUBLIC SUB ResetInfo ExtraInfo ="" InFunction = "" END SUB '|¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯| '| ***P R I V A T E*** F U N C T I O N S / S U B S | '|______________________________________________________________________________| ' If connection is closed then see if there is an application connection string ' if so open a connection automatically PRIVATE FUNCTION IsConnectionOpen if not mbIsConnectionOpen then if not IsEmpty(msConnString) then OpenDBConnection msConnString else ReportConnectionClosed end if end if IsConnectionOpen = mbIsConnectionOpen END FUNCTION '|¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯| ' If connection is closed then report error. PRIVATE SUB ReportConnectionClosed() DIM sTemp sTemp= "<P STYLE=""text-align:left""><SPAN STYLE=""color:#990000""><B>DB ERROR:</B></SPAN> <B>[File: </B>"&Request.ServerVariables ("SCRIPT_NAME")&"<B>]</B> " sTemp=sTemp & "<BR><B>[Func: </B>"&msInFunction&"</B>]</> <B>[xInfo: </B>"&msExtraInfo&"<B>]</B>" sTemp=sTemp & "<BR><B>[Desc: </B>THE DB CONNECTION HAS NOT BEEN OPENED!!!!<B>]</B>" sTemp=sTemp & "<P>You need the following 2 lines when accessing the DB:" sTemp=sTemp & "<BR>set g_clsDBCheck = new clsDBErrorChecker" sTemp=sTemp & "<BR>Application(""sDBConnection"")= ""Your Connection string here"" " sTemp=sTemp & "<BR><BR>Eg ""Provider=SQLOLEDB; Data Source=ServerIP; Initial Catalog=DBname; User ID=Username; Password=password; Persist Security Info=True""" Response.Write sTemp END SUB '|¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯| PRIVATE SUB UpdateConnectionString() msConnString=Application("sDBConnection") msConnString = replace (msConnString, "[***USER***]", maConnectAsArray(miConnectAs,0)) msConnString = replace (msConnString, "[***PASS***]", maConnectAsArray(miConnectAs,1)) END SUB '|¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯¯| '| E N D O F T H E C L A S S | '|______________________________________________________________________________| END CLASS %> Tag: Disabling CANCEL button during shell file copy Tag: 141690
- Next
  - 1
    - Changing components,,, Hi All, I am doing an asp page. What I want is to use the same page I use to enter data to display data in labels. This means that when the user wants to insert a record input boxes must be displayed, but when the user wants to delete a record then only labels must be displayed to confirm the deletion. Thanks in advance Roberto Tag: Disabling CANCEL button during shell file copy Tag: 141684
  - 2
    - snmp wmi scripting Using VBScript, or natively, is it possible to utilise WMI which includes an SNMP provider to manage a datacomms device such as a network switch which has an SNMP agent? Or, does the managed device need to have WMI capability built in which of course datacomms devices do not normally have? Tag: Disabling CANCEL button during shell file copy Tag: 141674
  - 3
    - when to write <%@ Language="VBScript" %>? Since ASP server scripts use VBScript by default, does it mean it is redundant to put the following in ASP page? Then when do we need to use this? In client-side VBScript? <%@ Language="VBScript" %> Thanks! John Tag: Disabling CANCEL button during shell file copy Tag: 141662
  - 4
    - Time Hi all <script language=vbscript> document.write (Time()-1) document.write ("<BR>") document.write (Time()) document.write ("<BR>") document.write DateDiff ("h",Date,23) </script> I want to display The Current time and also Current time -1 hr ( I mean theTime should be Less then 1 hr from Current time.) ???????????????? Thanks Naveen Tag: Disabling CANCEL button during shell file copy Tag: 141654
  - 5
    - Instr function Based on the code below, why does the variable pos keep coming up to 1 (indicating a match) when there is no obvious match between the contents of variable 'transit' and second element contained in myarray? Function CompareOSDTransitsToOriginator() dim myArray OSDTransits = "44444,33333,55555,22222" transit = "00968" myArray = Split (OSDTransits,",") msgbox myArray(1) ' which is "33333" pos = instr(1, myArray(1), transit, 1) if pos > "0" then msgbox("Match found...") else msgbox("NO Match...") end if msgbox pos End Function Tag: Disabling CANCEL button during shell file copy Tag: 141651
  - 6
    - Executing vbscript function from anchor tag I am trying the execute a VBscript function from an anchor tag, but seem to be unable to get the syntax correct. Following is a simple web page that diplays a msgbox. It works from the button, but not from the Anchor. Can you you help me? <HTML> <INPUT id="cmdWrite" onclick="vbscript:WriteFile('Hello')" type="button" value="Write File"><BR><BR> <A HREF="vbscript:WriteFile('Hello')">Say Hello</A> <SCRIPT LANGUAGE=VBSCRIPT> Sub WriteFile(Value) Msgbox "Value=" & Value End Sub </SCRIPT> </HTML> Tag: Disabling CANCEL button during shell file copy Tag: 141650
  - 7
    - Share Permissions Hi, I am working on a script, which will list all shares on a given computer and the permissions for each share. I would then remove the Everyone permissions if there is one and replace it with something else. My problem is I cannot figure out how to list the permissions. I can enumerate computers and list shares, but how to you list the permissions for each share? Thanks, Scott Tag: Disabling CANCEL button during shell file copy Tag: 141649
  - 8
    - Script error - script incl. - Release variables/objects? ?????????????????????????????????????????????????????????????????????????= ?????????????????????????????????????????????????????????????????????????= ?????????????????????????????????????????????????????????????????????????= ?????????????????????????????????????????????????????????????????????????= ?????????????????????????????????????????????????????????????????????????= ????????>????????????????????????????????????????????????????????????????= ?????????????????????????????????????????????????????????????????'>??????= ???????????????????????>????????????????>????????????????????????????????= ?????????????????????????????????????????????????????????????????????????= >?<??????????????????????????????>????????????????????????????>??????????= ????>??????????????>?????????????????????????????????????????????????????= ???????????????????????????????????????????????????????????>?<???????????= ???????????????????>?????????????????????????????????????????????????????= ?????????????????????????????????????????>???????????????????????????????= ????????????????????????????????????????????????????????????????????????>= ?????????????????????????????????????????????????????????????????????????= ?????????????????????????????????????????????????????????????????????????= ???????????????????????????????????>?????????????????>????????????>??????= ???`?????????????????????????????????????????????????????????????????????= ????????????'????????????????????????????????????????????????????????????= ?????????????????????????????????????????????????????????????????????????= ?????????????????????????????????????????????????????????????????????????= ?????????????????????????????????????????????????????????????????????????= ?????????????????????????????????????????????????????????????????????????= ?????????????????????????????????????????????????????????????????????????= ?????????????????????????????????????????????????????????????????????????= ?????????????????????????????????????????????????????????????????????????= ?????????????????????????????????????????????????????????????????????????= ?????..???????????????????..????????????????????..???????????????????????= ???.?..??.?.?.???????.???????????????????????????????????????.???????????= ?????????????????????????????????????????????????????????????????????????= ?????????????????????????????????????????????????????????????????????????= ???????????????????????.?????????????????????????????????????????????????= ?????????????????????????????????????????????????????????????????????????= ?????????????????????????????????????????????????????????????????????????= ?????????????????????????????????????????????????????????????????????????= ?????????????????????????????????????????????????????????????????????????= ?????????????????????????????????????????????????????????????????????????= ?????????????????????????????????????????????????????????????????????????= ?????????????????????????????????????????????????????????????????????????= ?????????????????????????????????????????????????????????????????????????= ?????????????????????????????????????????????????????????????????????????= ???????????????????????????????????????????????????????????????????????..= ?????.???????????????????????????????????????????..??????.???????????????= ?????????????????????????????????????????????????????????????????????????= ?????????????????????????????????????????????????????????????????????????= ??????????????????????????'??????????????????????????????????????????????= ?????????????????????????????????????????????????????????????????????????= ?????????????????????????????????????????????????????????????????????????= ?????????????????????????????????????????????????????????????????????????= ?????????????????????????????????????????????????????????????????????????= ?????????????????????????????????????????????????????????????????????????= ???????????????????????????????????????????????????????????????????>?????= ??????????????????????????????????????????????????????????????????>..????= ????????.????????????????????????????????????????????????????????????????= ?????????????????????????????????????????????????????????????????????????= ?????????????????????????????????????????????????????????????????????????= ?????????????????????????????????????????????????????????????????????????= ?????????????????????????????????????????????????????????????????????????= ?????????????????????????????????????????????????????????????????????????= ?????????????????????????????????????????????????????????????????????????= ?????????????????????????????????????????????????????????????????????????= ??????????????????????????????????????????????????????????????????.??????= .????????????????????????????????????????????????????????????????????????= ?????????????????????????????????????????????????????????.???????????????= ?????????????????????????????????????????????????????????????????????????= ?????????????????????????????????????????????????????????????????????????= ???????????.?????????????????????????????????????????????????????????????= ?????????????????????????????????????????????????????????????????????????= ?????????????????????????????????????????.???????????????????????????????= ??????????????????????????.?..???????????????????????????????????????????= ??????????????????????????????????????????????.?..???????????????????????= ?????????????????????????????????????????????????????????????????????????= ?..??????????????????????????????????????????????????????????????????????= ???..????????????????????????????????????????????????????????????????????= ?????????????????????>..??????.??????????????????????????????????????????= ?????????????????????????????????????????????????????????????????????????= ???????????????????????>..??????.????????????????????????????????????????= ????????????????????????????????????????????????????? Tag: Disabling CANCEL button during shell file copy Tag: 141648
  - 9
    - NTFS File Ownership lost, how to reset ? I writed a vbscript to set ntfs permission recursively. It use AdsSecurity.dll. But when a file have lost owner information, script close with no error. With WMI, I can detect the problem : Function GetOwner(fileinput) Set Obj = GetObject("Winmgmts://.") On Error Resume Next For each SID in Obj.ExecQuery("ASSOCIATORS OF {Win32_LogicalFileSecuritySetting='" & fileinput & "'} WHERE AssocClass=Win32_LogicalFileOwner ResultRole=Owner") GetOwner = SID.AccountName Next If VarType(GetOwner)=0 Then GetOwner = "error" End If End Function Function return error and I can avoid to make a "GetSecurityDescriptor". Then, how can I take ownership of the file (local or remote) without use "GetSecurityDescriptor" using WMI or AdsSecurity ? Tag: Disabling CANCEL button during shell file copy Tag: 141647
  - 10
    - VBS modeless status/progress/log dialog I had a little fun building a simple ActiveX EXE based dialog. Very light weight and simple. Available here; with source and sample test.vbs: http://www.geocities.com/jaffadogmon/ Tag: Disabling CANCEL button during shell file copy Tag: 141640
  - 11
    - CDONTS.NewMail Object help Hi All, I'm new to this newsgroup, so please forgive my ignorance, but I have an issue with the NewMail object that I can't seem to resolve. The issue is this: I have the following snippet of code to send out an HTML based e-mail: Dim oEmail Set oEmail = Server.CreateObject("CDONTS.NewMail") oEmail.From = sFromemail oEmail.To = sRecipemail oEmail.Subject = sSubject oEmail.Body = sBody oEmail.BodyFormat = 0 oEmail.MailFormat = 0 oEmail.Send Set oEmail = Nothing However, it seems that by including the MailFormat = 0 bit the sender is removing some of the periods out of my links and image references, always at the very end (www.blah.com/blah.htm becomes www.blah.com/blahhtm and www.blah.com/blah.gif becomes www.blah.com/blahgif). It also seems that even with both the BodyFormat and MailFormat lines removed the object still removes periods from some of my links. I've checked over my HTML several times, but it's completely fine, and is shown properly on a test page I've built. I'm really having trouble figuring this out, so I would really appreciate the help. Thanks, Jon Scolamiero. Tag: Disabling CANCEL button during shell file copy Tag: 141639
  - 12
    - Setting system variable Hello, I need to create a new environment variable on approx 50 2000/XP machines on my network. The system variable (not user variable) is called LANID and variable value is WRKSTN# . I know of the resource kit utility setx but do not think that works remotely. Instead of writing 50 batch files like this: setx lanid wrkstn# -m (# is taken from the numerical portion of the computer's network name: SCBOE01...SCBOE02....SCBOE03...and so on) Does someone know of an easier method? Thanks in advance, Aaron Tag: Disabling CANCEL button during shell file copy Tag: 141636
  - 13
    - Mimic the form POST I have a form that submits to an ASP page (ProcessForm.asp) to update the database. However, the ASP page does a check on one of the fields in the form lets say FirstName to see if ther is already a FirstName in the database that matches the one the user submitted. The ProcessForm page writes some javascript onto the page to alert the user and give them the option to go back or continue with the update. At the moment, I use a hidden form in the process page, and populate a variable strSQL which contains the sql update string. If the user clicks OK, this is submitted to a ProcessSQL.asp page. This is a pretty unsecure way of doing things as ProcessSQL could receive any form value and run the sql string that was passed. Ideally, I would want the ProcessForm page to resend the Request.Form() collection back to itself, with a variable in the querystring to let it know not to do the dupicates check. Is there a way of doing a Response.Redirect (processForm.asp) and mimicking the first form subission so it beahaves like it has just received the POST from the form??? Thnx in advance Paul Tag: Disabling CANCEL button during shell file copy Tag: 141633
  - 14
    - Vbscript to link access tables To administer unto my latest database I need the guys to link to whatever server they are putting the db on. I tried writing a script to do this but just got errors. Can anyone help? Tag: Disabling CANCEL button during shell file copy Tag: 141626
  - 15
    - Charting... hello, I have to develop a site having dynamic line charts that displays data read from serial port. Does anyone know good (and cheap) components that can be used in pure ASP sites? I'm looking for a component with a couple of special features: - capable of drawing dynamic charts based on data read from serial port (like mentioned above) - dynamic x- and y-axis, and scrolling in case of x-axis (= showing e.g. 300 values at a time, older values can be seen be scrolling to left...) - clickable objects, e.g. lines (e.g. user can move min and max limit lines in the chart and the corresponding variables should be changed in ASP site) - etc. All this should work on a pure ASP site (NOT ASP.NET), since I'm working with Windows CE.NET)! UNLESS future versions of Win CE.NET will have support to ASP.NET (but this is another question, which I will post to another newsgroup) THANK YOU VERY MUCH IN ADVANCE FOR ANY ADVICE. Mike Tag: Disabling CANCEL button during shell file copy Tag: 141620
  - 16
    - How to add SMTP adr via ADSI Hi, I wrote a vbscript with HTML frontend to add a new user to our AD using ADSI - a mailbox on our exchange is also created automatically. But how do I now add an additional SMTP address to that user? Our config: W2k Server & AD; Exchange2k Any ideas? Thanks! Tag: Disabling CANCEL button during shell file copy Tag: 141616
  - 17
    - Process-id : How do I determine my own in VBScript I wrote a VB script (+ WMI) to determine PID's of all processes running on my computer. Execution of VB script is identified by the process name of wscript.exe. But when multiple scripts are simultaneously running, how do I determine what's my own process id (PID) so I can take some programmatic action? Thanks in advance for your help. Tag: Disabling CANCEL button during shell file copy Tag: 141614
  - 18
    - getting out of a loop. This is a multi-part message in MIME format. ------=_NextPart_000_0124_01C36840.7D2C3270 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable I'm having trouble resetting an invalid input value. The input string is = tested for a single digit, positive integer from 0 to 4. The code works = except for when the first invalid entry is done, then if a valid entry = is entered after it, the script returns saying the input is still = invalid. I must be missing where to reset the last value entered while = in the conditional loop. Thanks for any help. -CPsharp Call Main_Menu() Function Main_Menu() Dim k, selaction, choose_str, Array_selaction(4), Patern Array_selaction(0) =3D "Create An Administrative Account" Array_selaction(1) =3D "Delete An Administrative Account" Array_selaction(2) =3D "Reset A Password" Array_selaction(3) =3D "Force Change Password for an" & vbCrLf & vbTab & = vbTab & "Account at Next Login" Array_selaction(4) =3D "Enumerate All Accounts and Their" & vbCrLf & = vbTab & vbTab & "Properties" For k =3D 0 to 4 Step 1 choose_str =3D choose_str & vbTab & (k) & "." & " " choose_str =3D choose_str & Array_selaction(k) & vbCrLf Next Patern =3D "^[0-4]{1}+$" Set selaction =3D Nothing selaction =3D InputBox(choose_str,"Select Action", 4) Do Until RetVal =3D True Set regEx =3D New RegExp regEx.Pattern =3D Patern retVal =3D regEx.Test(selaction) If retVal Then wscript.echo "The value is valid." RetVal =3D True Exit Do Else wscript.echo "wrong Input Value" Call Main_Menu() End If Loop k =3D selaction Select Case k Case "0" Call Add_User() ' Call the Add User Function Case "1" wscript.echo "hello 1"=20 Case "2" wscript.echo "hello 2"=20 Case "3" wscript.echo "hello 3" Case "4" wscript.echo "hello 4" Case Else Wscript.Quit End Select set k =3D Nothing set choose_str =3D nothing set selaction =3D nothing End Function ------=_NextPart_000_0124_01C36840.7D2C3270 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <HTML><HEAD> <META http-equiv=3DContent-Type content=3D"text/html; = charset=3Diso-8859-1"> <META content=3D"MSHTML 6.00.2730.1700" name=3DGENERATOR> <STYLE></STYLE> </HEAD> <BODY bgColor=3D#ffffff> <DIV><FONT face=3DArial size=3D2>I'm having trouble resetting an invalid = input=20 value. The input string is tested for a single digit, positive integer = from 0 to=20 4. The code works except for when the first invalid entry is done, then = if a=20 valid entry is entered after it, the script returns saying the input is = still=20 invalid. I must be missing where to reset the last value entered while = in the=20 conditional loop. Thanks for any help.</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>-CPsharp</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>Call Main_Menu()</FONT></DIV> <DIV> </DIV> <DIV><FONT face=3DArial size=3D2>Function Main_Menu()</FONT></DIV> <DIV> </DIV> <DIV><FONT face=3DArial size=3D2>Dim k, selaction, choose_str, = Array_selaction(4),=20 Patern</FONT></DIV> <DIV> </DIV> <DIV><FONT face=3DArial size=3D2>Array_selaction(0) =3D "Create An = Administrative=20 Account"<BR>Array_selaction(1) =3D "Delete An Administrative=20 Account"<BR>Array_selaction(2) =3D "Reset A = Password"<BR>Array_selaction(3) =3D=20 "Force Change Password for an" & vbCrLf & vbTab & vbTab = &=20 "Account at Next Login"<BR>Array_selaction(4) =3D "Enumerate All = Accounts and=20 Their"  & vbCrLf & vbTab & vbTab &=20 "Properties"<BR></FONT></DIV> <DIV><FONT face=3DArial size=3D2>For k =3D 0 to 4 Step = 1<BR>    =20 choose_str =3D choose_str & vbTab & (k) & "." & " =20 "<BR>     choose_str =3D choose_str & = Array_selaction(k)=20 & vbCrLf<BR>Next</FONT></DIV> <DIV> </DIV> <DIV><FONT face=3DArial size=3D2>Patern =3D "^[0-4]{1}+$"<BR>Set = selaction =3D=20 Nothing<BR>selaction =3D InputBox(choose_str,"Select Action", = 4)</FONT></DIV> <DIV><FONT face=3DArial size=3D2><BR>Do Until RetVal =3D=20 True<BR>        Set regEx =3D New=20 RegExp<BR>        regEx.Pattern =3D=20 Patern<BR>        retVal =3D=20 regEx.Test(selaction)<BR>    If retVal=20 Then<BR>        wscript.echo "The = value is=20 valid."<BR>        RetVal =3D=20 True<BR>        Exit = Do<BR>  =20 Else<BR>        wscript.echo "wrong = Input=20 Value"<BR>        Call=20 Main_Menu()<BR>   End If<BR>Loop</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>k =3D selaction<BR></FONT><FONT = face=3DArial=20 size=3D2></FONT></DIV> <DIV><FONT face=3DArial size=3D2>Select Case k<BR>  Case = "0" Call=20 Add_User()    ' Call the Add=20 User Function<BR>  Case "1" wscript.echo "hello=20 1" </FONT></DIV> <DIV><FONT face=3DArial size=3D2>  Case "2" wscript.echo = "hello=20 2" </FONT></DIV> <DIV><FONT face=3DArial size=3D2>  Case "3" wscript.echo = "hello=20 3"<BR>  Case "4" wscript.echo "hello = 4"<BR>  Case=20 Else Wscript.Quit<BR>End Select</FONT></DIV> <DIV> </DIV> <DIV><FONT face=3DArial size=3D2>set k =3D Nothing<BR>set choose_str =3D = nothing<BR>set=20 selaction =3D nothing</FONT></DIV> <DIV> </DIV> <DIV><FONT face=3DArial size=3D2>End Function</FONT></DIV></BODY></HTML> ------=_NextPart_000_0124_01C36840.7D2C3270-- Tag: Disabling CANCEL button during shell file copy Tag: 141613
  - 19
    - McAfee Version Anyone have any idea how I can find out what version of McAfee each computer in my OU's have? TIA Gavin... Tag: Disabling CANCEL button during shell file copy Tag: 141606
  - 20
    - Server Excel process is not terminating I am writing a server side script which performs the following actions: 1. Opens an Excel document 2. Unprotects/ Protects the worksheets 3. Closes the Excel document The problem is that my script creates an Excel process on the server, and this Excel process does not die unless you manually terminate the process from within Task Manager. There will be several users activating the script on the server, and the abundance of Excel processes may bring the Server down over time. I have searched the web for this problem, and there are still a couple of things that l would still like to try. However the line will is coming up with a compilation error. The listing is provided below. How can l find out which version of VBScript is running on the Server? Can anybody suggest another way to deal with the Excel process not remaining? One website suggested that unreferenced references may be causing the problem. However, l cannot see any inside the script. Help! ========================================================== The line is: Dim oWB As Object Dim oApp As Object On Error Resume Next 'THIS LINE WILL NOT COMPILE Set oApp = GetObject(,"Excel.Application") If Err.Number = 429 Then 'Excel is not open On Error GoTo 0 Set oApp = CreateObject ("Excel.Application") End If On Error GoTo 0 oApp.Application.Visible = True oApp.Application.DisplayAlerts = False Set oWB = oApp.Workbooks.Open(strFullFileName) Dim intSheetCount, intCounter As Integer 'Get number of worksheets inside the Workbook intSheetCount = owB.Worksheets.Count 'Check if Protect or Unprotect If intOnOff = FILE_EXCEL_PROTECT Then For intCounter = 2 To intSheetCount 'Password, DrawingObjects, Contents, Scenarios oWB.Worksheets (intCounter).Protect strPassword, True, True, True Message "Protected " + oWB.Worksheets(intCounter).Name Next intCounter Else For intCounter = 1 To intSheetCount oWB.Worksheets (intCounter).Unprotect strPassword oWB.Worksheets (intCounter).Unprotect LCase(strPassword) Message "Unprotected " + oWB.Worksheets(intCounter).Name Next intCounter End If oWB.Save oWB.Saved = True oApp.Application.DisplayAlerts = True oWB.Close True Set oWB = Nothing oApp.Application.Quit Set oApp = Nothing End Sub Tag: Disabling CANCEL button during shell file copy Tag: 141597
  - 21
    - Difference between using server.createobject and createObject Hi, What Is the difference between doing "Server.createObject" or Just "CreateObject" without the Explicitly adding the "Server" in IIS4 or IIS5? Thanks, David Tag: Disabling CANCEL button during shell file copy Tag: 141576
  - 22
    - SQL insert new record help Thank you Richard for helping me with the variable syntax. I know I have a valid query now, but what am I doing wrong with the insert statement? Set Att_rs = Server.CreateObject("ADODB.Recordset") NewEntry="SELECT StudentID, AttendanceTimeIn, AttendanceTimeOut, AttendanceDate, CourseID, AttendanceVerified, AttendanceTimeStamp FROM Attendance WHERE StudentID = " & StuID & ";" Att_rs.Open NewEntry, Db_Conn, 2, 3, 2 Att_rs.AddNew Att_rs("StudentID")=StuID Att_rs("AttendanceTimeIn")=Request.Form("ti") Att_rs("AttendanceTimeOut")=Request.Form("to") Att_rs("AttendanceDate")=CurDate Att_rs("CourseID")=Request.Form("cc") Att_rs("AttendanceVerified")="False" Att_rs("AttendanceTimeStamp")=CurTime Att_rs.Update ' Close Connection to ATTENDANCE Att_rs.Close Set Att_rs = Nothing ' Close Connection to CBLC_Acs Db_Conn.Close Set Db_Conn = Nothing This gives me this error: Microsoft OLE DB Provider for ODBC Drivers (0x80040E14) [Microsoft][ODBC Microsoft Access Driver] Syntax error in FROM clause. /attendance/AttendanceForm.asp, line 178 Line 178 is the Att_rs.Open statement. BTW I tried it with "adOpenStatic, adLockOptimistic" and kept getting too few argument errors. I have included a  at the top of the page, and the file is local to page. Thanks again, Dave Tag: Disabling CANCEL button during shell file copy Tag: 141573
  - 23
    - Ping IP ranges Hello all, Has anyone created a script that pings an IP range and dumps the alive machines to a file?? Been trying to get one to work but no luck as of yet. Thanks Jack Tag: Disabling CANCEL button during shell file copy Tag: 141571
  - 24
    - another dictionary question - want to convert all the keys to uppercase I have a dictionary with mixed-case strings as keys, and I want to convert them all to uppercasce. What am I doing wrong? for each elem in objUseThisDic objUsethisDic.Key(elem) = UCase(elem) next when I display it on screen I still get mixed-case keys - what am I doing wrong? thanks in advance, Sandy Tag: Disabling CANCEL button during shell file copy Tag: 141559
  - 25
    - MS03-026 and language difference Hello all, I'd like to automate the installation of the above mentioned security patch from MS. My environment has 2 languages: English and Japanese. I noticed that MS has made the patches available in both languages also. How do I programmatically differentiate between languages when using the patch? I need to make sure that I use the English patch for the English OS and the Japanese patch for the Japanese OS. All OSes are W2K. Thanks in advance. Craig. Tag: Disabling CANCEL button during shell file copy Tag: 141558

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

I'm using the following script to copy files which provides a copy progress
dialog box. What I want to do is disable the CANCEL button during the copy.
Does anyone know of any way to do this?

Thanks,

Chris

SCRIPT:

'Respond with "Yes to All"(16) + Display dialog but no files(256) + Do not
confirm the creation of directory(512)
Const FOF_CREATEPROGRESSDLG = 784
ParentFolder = "D:\DATABACK"
Set objShell = CreateObject("Shell.Application")
Set objFolder = objShell.NameSpace(ParentFolder)
objFolder.CopyHere "D:\TESTING", FOF_CREATEPROGRESSDLG
-----BEGIN PGP SIGNATURE-----
Version: PGP 8.0
Comment: Public PGP key for Chris Lynch

iQA/AwUBP0uLDG9fg+xq5T3MEQIBiACfbvKo6gvf6s4eLrlVbdxRuy6QUGUAnRJD
08BGtfO9xjqlWQqF1sTxHYfL
=7O0m
-----END PGP SIGNATURE-----

Top

Re: Disabling CANCEL button during shell file copy by Fosco

Fosco
Wed Aug 27 23:55:58 CDT 2003

"Chris Lynch"
> I'm using the following script to copy files which provides a copy progress
> dialog box. What I want to do is disable the CANCEL button during the copy.
> Does anyone know of any way to do this?

Autoit (free) prevents users input (keyboard & Mouse)
http://www.hiddensoft.com/AutoIt/
--
Fosco

Top