TDC Control and Colors

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
    - Updating DAT files with logon script Hello, How can I update new dat files for users with active directory group policy? On winnt4 domain we just run .bat file and it calls for dat.exe file. Maybe I can create logon script .vbs file to call silently for the new dat file? Thank you Eimis Tag: TDC Control and Colors Tag: 143084
  - 2
    - looping I am trying to figure out how to loop inside a script. I am using a .vbs file where I set wshshell = wscript.createobject ("wscript.shell) then I run the user32.dll lockworkstation. I have used For i = 1 to 3 then the lockworkstion code and then next. The script will only run one time. Am I using the wrong syntax for looping? Thanks for your time. Tag: TDC Control and Colors Tag: 143083
  - 3
    - MSHTA - Logon Script I'm using a logon script on a Novell network. This logon script calls a batch file which, in turn, calls mshta with the parameter being the url to the asp.net intranet web site. This works great on all machines (after numerous fixes and tweaks to the hta). The only problems I have seen are, on Windows 2000 machines that have IE 6.0 with no other updates to IE (via Windows Update), the hta hangs. mshta.exe is still listed in the list of processes, but the hta never gets displayed. One of the August, 2003 updates from windows update fixes this problem, but we can't depend on the users to do this to fix it (as they don't want this application running anyways). None of the updates listed in August list anything about HTA's or (afaik) script bugs (other than cross domain exploits that have been fixed and aren't an issue here afaik). So, any other ideas? Thanks, Mythran Tag: TDC Control and Colors Tag: 143080
  - 4
    - installing patch i am trying to deploy Windows2000-KB824146-x86-ENU.exe using psexec in quite mode. i found a problem with the "-u -z" parameters, cos when i execute c:/>psexec \\computername -i \\servername\dir1\patch.exe it runs well. any idea how to include "-u -z" to the command string? Tag: TDC Control and Colors Tag: 143069
  - 5
    - How to remove add-on from MSProject? I've written an add-on to MSProject (dll). It adds some buttons to toolbar in MSProject. When I unregister my addon using regsvr32, buttons still remain on toolbar. Is it possible to remove them programmatically? Thanks in advance. Tag: TDC Control and Colors Tag: 143066
  - 6
    - Unicode to Ascii I have a listbox which items I want to save in a textfile. This one must be ascii but so far as I found out the list elements are all unicode. How can I convert this Unicode ones into good old Ascii ones? I already tried StrConv(...,vbFromUnicode) but there only my debugger strikes? What shall I do? thx 4 any hint chris -- Using M2, Opera's revolutionary e-mail client: http://www.opera.com/m2/ Tag: TDC Control and Colors Tag: 143065
  - 7
    - manipulate binary structs/files Hi group, Is there a way to manipulate binary structs/files in JScript/VBscript. I have in mind some components that would have methods like var buf; // whatever bytearray variant or something more apporpriate f.open(filename); f.read(offset, buf, sizeof(buf)); b.scanf(buf, format= "%c[4]%d ....", v1, v2, ....); b.printf(buf, format= "%c[4]%d ....", v1, v2, ....); f.write(offset, buf, sizeof(buf)); Perl has pack()/unpack() functions that are very alike to the above ones. Thanks! George VS (gogovsh@abv.bg) Tag: TDC Control and Colors Tag: 143063
  - 8
    - Class in vbscript Hi, I'm going to develop a solution in vbscript and I have chosen to use Class in vbscript, but my question is the following: Is there any reason not to prefer Classes use instead of a basical solutions (functions, etc..) ? Thx for your time, Vince. Tag: TDC Control and Colors Tag: 143058
  - 9
    - Simple Code <%@ Language=VBScript %> <% Dim BooKName,Price,BookID Dim lib,rec Dim path,sql path = Server.MapPath("/books/Books.mdb") Set lib = Server.CreateObject("ADODB.Connection") Set rec = Server.CreateObject("ADODB.Recordset") sql = "INSERT INTO OrderList (BookID,BooKName,Price) VALUES (15,'abc',89)" lib.Provider = "Microsoft.Jet.OLEDB.4.0" lib.Open path lib.Execute sql rec.Close lib.Close Set rec = Nothing Set lib = Nothing %> -- Posted via http://dbforums.com Tag: TDC Control and Colors Tag: 143053
  - 10
    - Help on copying Hi all I am trying to copy a file to %USERPROFILE%\start Menu\programs\startup but the script cannot accept the path. Is there a way round this without knowing the actual path?? Thanks Tag: TDC Control and Colors Tag: 143050
  - 11
    - Passing Dictionary object byref Ive created an ASP class that uses a dictionary object which is filled from a recordset. It passes the object to the propterty of another ASP class byref: Public Property Let dicReplaceVars(byref vdicReplaceVars) set p_ReplaceVars = vdicReplaceVars End Property Private p_ReplaceVars where it is used in this other class a few times to replace values in an array: Function ReplaceVars(vArrayItem) '' turn it into an array split at spaces vArrayItem = split(vArrayItem," ") '' loop through the array for count = lbound(vArrayItem) to ubound(vArrayItem) ''See if it is a replacement variable and exists in the dictionary if left(vArrayItem(count),6) = "tkRep_" and p_ReplaceVars.exists(vArrayItem(count)) then '' then replace it Error occurs here >> vArrayItem(count) = p_ReplaceVars.Item(cstr(vArrayItem(count))) end if next dim vArrayItemNew vArrayItemNew = "" '' Loop through the array and put it back together for count = lbound(vArrayItem) to ubound(vArrayItem) if vArrayItem(count) = ubound(vArrayItem) then vArrayItemNew = vArrayItemNew & vArrayItem(count) else vArrayItemNew = vArrayItemNew & vArrayItem(count) & " " end if next '' return the vArrayItemNew to the function ReplaceVars = vArrayItemNew End Function The error message I get is: ADODB.Field (0x800A0D5C) Object is no longer valid. D:\WWW\LCDEV\DOC_FUNCTIONS\../classes/classlcDocTKit_item.asp, line 52 However I have no idea why, it is a dictionary object and not a recordset, the object should still be open. Any help is greatly appreciated. Thanks ----------------------------- This message is posted by http://Asp.ForumsZone.com Tag: TDC Control and Colors Tag: 143045
  - 12
    - HTTP_USER_AGENT and Safari/85 Problem I am trying to include the following server variable in an IF test: Request.ServerVariables("HTTP_USER_AGENT") in my global.asa. Works fine in all browsers except Safari/85. I get the following error: --------------- Microsoft OLE DB Provider for ODBC Drivers error '80040e57' [Microsoft][ODBC SQL Server Driver][SQL Server]String or binary data would be truncated. ------------------- Any suggestions?? Thanks, Dale Tag: TDC Control and Colors Tag: 143043
  - 13
    - Excel functions called from a web page? Can you call Excel functions using VBScript on an ASP page? What/how do you need to reference? I assume the server would need to have the MS extensions loaded or something? Thanks. -- Bradley Software Developer www.hrsystems.com.au A Christian Response www.pastornet.net.au/reponse Tag: TDC Control and Colors Tag: 143041
  - 14
    - ASP submitting a form to 2 places on the same page Ok, have a normal html form that sends a username and password to an asp page, the asp page then retrieves the username and password and puts it into cookies, The page then uses a javascript submittal to a progress database but this js is considered malicious code by some browsers and will not work for certain users. So I have to find a different way of gleaning the username and password before it is sent off to the other page (which I have no control over). I could always use a response.redirect but then the username and password would be in clear text and is unacceptable. IS there anyway to do a blind submittal on an asp page without user intervention??????? Tag: TDC Control and Colors Tag: 143039
  - 15
    - Help on script Hi, I''d like to create a vbs script that runs when a user logs in. Basically, the scripts should query the users group membership and then run a batch file stored on a server share. If the user is not a member of the group then the batch file should not be run Any help will be appreciated. TIA LM Tag: TDC Control and Colors Tag: 143037
  - 16
    - RegExp: Password Validation I am trying to create a regular expression pattern to validate a user's password without any success. The password must have the following characteristics: - be at least 8 charachters - must have both letters (both upper and lower) and numbers It seems easy enough, but I am having a heck of a time trying to create one. Any help would be greatly appreciated. Thanks. Greif Tag: TDC Control and Colors Tag: 143031
  - 17
    - for each table Dans un tableau html je voudrais faire une fo each des cellules d'une colonnes . Comment faire? Tag: TDC Control and Colors Tag: 143027
  - 18
    - Patchinst.vbs script I am using this script to remotely install the patch. I don't know how to use scripts and was looking for help. I changed the variable to not force a reboot after patch is installed, but now I want to send a pop message to that user using that same script stating that I installed a patch and they need to reboot. http://support.microsoft.com/default.aspx?scid=kb;[LN];827227 Thanks Sal Tag: TDC Control and Colors Tag: 143019
  - 19
    - Excel, Value, and Arrays The value property of a range object in excel has the ability to return an array of values. While it works fine in VB or VBA, I cannot get the following code to work in a vbs file. Dim aryData() Set oRange = oExcel.Range("A5").CurrentRegion aryData = oRange.Value I get the error Microsoft VBScript runtime error: Type mismatch Any thoughts? Tag: TDC Control and Colors Tag: 143012
  - 20
    - Permission Denied when using OpenTextFile repeatedly, is it stepping on itself? I've got a script that does a lot of writing to a log file so I can track its progress. Here is the subroutine that I use: Sub LogMain(S) Dim F set F = fso.opentextfile(CurrentPath & "\log.txt", 8, true) F.writeline Now() & vbTab & S F.close set F = nothing End Sub So from within my script, I can just call: LogMain "test entry" The problem I'm seeing -- which never used to happen, but has been happening quite a bit over the past month or so -- is that the script will work fine for a while, but at some point it suddenly hits a "permission denied" error on the line that calls OpenTextFile. It will not happen at the same point in the script every time, so I'm having a hard time reproducing the error. I'm closing F and then setting it to Nothing before ending the sub, so I would not expect there to be a conflict the next time I open the file. If I change the routine to look like this, it will work flawlessly: Sub LogMain(S) Dim F set F = fso.opentextfile(CurrentPath & "\log.txt", 8, true) F.writeline Now() & vbTab & S F.close set F = nothing wscript.sleep 5 '<-- new line End Sub Is this just a case of the file not really being closed by the OS before I try to open it again? I'm only seeing this happen on one machine, so far. Tag: TDC Control and Colors Tag: 143009
  - 21
    - exchange scripting I tried posting this message in the exchange2000.development group but got no answer, perhaps someone here can help me. I'm putting together a script to delete certain messages in our public folders, right now i have it working fine based on keywords in the message's subject using objMessage.subject property, what i want to know is what property can i use to see the received date on it and delete based on that? ex code: for each folder in objSubFolders if folder.name = "test folder" then Set tempfolder = objSession.GetFolder(folder.id, objInfoStore2.id) Set Allmessages = tempfolder.messages for each Messageval in allmessages if inStr(messageval.Subject,"keyword") then messageval.delete() end if next end if Next what i would like to have it do is something to the effect of (if one of you can help me with the proper syntax): if (inStr(messagval.Subject,"keyword")) OR (messageval.ReceivedDate < oneMonthAgo) messageval.delete() end if i'm not sure of the actual property or if there is another function of means to find the received date to test. any help would be appreciated thanks chris coho ccoho@jrwald.com Tag: TDC Control and Colors Tag: 143008
  - 22
    - How to select folders (only folders, not files) in ASP pages? Hi all, Could anybody give me a hand on select folders in ASP pages? The situation is that I want to specify a folder to save download files in my ASP page. I know how to browse a file. However, what I want is just browse to folder level, just like we select a dirctory for setup application. Thanks a lot. Tag: TDC Control and Colors Tag: 143005
  - 23
    - Script to create COM+ application I'm trying to create an automation script for creating a COM+ application. I not seen any examples on this anywhere just looking for a sample. Thanks Tag: TDC Control and Colors Tag: 143004
  - 24
    - IP Resolution Is there a function to have an IP address resolved to the workstation name? Thanks in advance Tag: TDC Control and Colors Tag: 143003
  - 25
    - vbscript that moves files that are older than 3 days I need a vbscript that moves files that are older than 3 days I am having problems writing this script I f someone could help I would appreciate it Thanks Earl L Tag: TDC Control and Colors Tag: 143002
- Next
  - 1
    - Running Script with Elevated Rights I have a VB script which detects the OS version, installs the latest RPC patch, and opens an IE window telling the user they have been updated and need to re-boot the system to "activate" the patch. I am pushing this task with SMS and all is fine. The problem is I have a significant number of users who are not SMS clients and do not have Admin Rights on the local machine. I am trying to get the script to run with elevated rights when manually invoked by the user and having no success (I want to email a link to the script which says "Click here to update your system"). Anyone have any words of wisdom on this task? I appreciate any and all comments (unless they are nasty). Thanks, Russ J Tag: TDC Control and Colors Tag: 142999
  - 2
    - Printer Help I use a VBScript for each user in their login script that maps a specific network printer in the room where they are logging in. This script uses the computer name to determine the specific printer. This script work with Windows 2000 pro, and XP Pro. Here is the problem; I have 4 users accounts that it will not work and I just cant figure out why. It appears to be a permissions issue when the login script runs and the script throws this error. Cscript Error: Loading your settings failed. (Access is denied.) I have deleted the 4 users and recreated them, still they fail. I know this script works, other users it works fine under both OS's My questions are what specific permissions are required to run a vbscript? Is the script failing because the u ser doesnt have the right permissions to run it? Or, is it failing to make the changes that the script is trying to change? ( ie; add the network printer) Here is a snippet of the script Option Explicit DIM RegEntry, ComputerName RegEntry="HKLM\SYSTEM\CurrentControlSet\Control\ComputerName\ComputerName\ComputerName" ComputerName = ReadRegValue(RegEntry) if InStr(1,ucase(ComputerName),"xpfinal",vbTextCompare) > 0 then call SetPrinter("\\XXXX\test-1") if InStr(1,ucase(ComputerName),"ms-a3-",vbTextCompare) > 0 then call SetPrinter("\\XXXX\Test-2") if InStr(1,ucase(ComputerName),"ms-a4-",vbTextCompare) > 0 then call SetPrinter("\\XXXX\Test -3") 'so on and so forth. wscript.quit ' *** This subroutine installs and sets the default printer Sub SetPrinter(ByVal PrinterPath) DIM WshNetwork Set WshNetwork = CreateObject("WScript.Network") WshNetwork.AddWindowsPrinterConnection(PrinterPath) WshNetwork.SetDefaultPrinter Printerpath end sub ' **** This function returns the data in the registry value Function ReadRegValue(ByVal RegValue) DIM WSHShell Set WSHShell = WScript.CreateObject("WScript.Shell") ReadRegValue="" On Error Resume Next ReadRegValue= WSHShell.RegRead(RegValue) End Function I call this script from the logon.bat for each user; @echo off Cscript %LOGONSERVER%\netlogon\roaming.vbs net use g: \\XXXXX\XXXX The printer configurations are properly setup on the server and the shares are correctly named. I didn't assign any specific permissions to the printer shares. They work for hundred of other accounts. When the users that the script fails on, try to add the network printer via the wizard this fails too. HELP Robert Tag: TDC Control and Colors Tag: 142996
  - 3
    - Change computername automatically Hi there, I am looking for a working script or small utility to change the Windows XP computername immediately after start-up, if required, before any user logs on. This script/utility should check if the current computername equals VSxxxxxxxxxxxx (where x = macaddress) and if not, change it accordingly without breaking domain membership or other security issues. The latter is the problem. I have found and tried several scripts, however there is always a domain/security problem. Is there a 100% transparent and functional way to achieve the above? Thanks, -- SLE Tag: TDC Control and Colors Tag: 142995
  - 4
    - Search for a specific file on local drives I'm looking for a script that will search for a specific file by name on all local drives and return the path. I've seen several examples that search for files by extension, date, and file size but none that just searches for a specific file. Can someone please help? Thanks, Todd Ouimet touimet@advantageprofessionals.com Tag: TDC Control and Colors Tag: 142994
  - 5
    - how to get the infromation if it's a string or a decimal please help! in my script i'm getting data from an csv file and split the values to an aray. now i'd like to claculate with some values, but it's still possible that there are strings als value. now i'd like somthing like that: for i = 1 to ubound(array) if array(i) = nuberic then calculate something. next i how can i do that numberic function? thx christian Tag: TDC Control and Colors Tag: 142990
  - 6
    - * Newsgroup doc. and 7199 Tips, Tricks, and Registry Hacks - 15-Sep-2003 05:30.22 * 15-Sep-2003 05:30.22. Please see the Microsoft Newsgroups page at http://communities.microsoft.com/newsgroups/default.asp Visit Windows & .NET Magazine's 7199 tips at http://www.jsiinc.com - press the "Tips & Tricks" button. Jerold Schulman Windows: General MVP JSI, Inc. http://www.jsiinc.com Tag: TDC Control and Colors Tag: 142985
  - 7
    - RegExp not working Below is a code to match Meta Tags. The pattern is found twice but I am not able to print the first match. The second match displays correctly. If I add a space before the first 'meta' keyword then it works. Can anyone spot a problem here? Any help would be appreciated. Thanks. Vilva ----------------------------------------------------------- <% Function ShowMetaTags(HTMLstring) Set re = New RegExp With re .Pattern = "<\s*META[^>]*>" .IgnoreCase = True .Global = True End With Set aMetaMatch = re.Execute(HTMLstring) Response.Write "Count: " & aMetaMatch.count Response.Write "<BR>" Response.Write "First Tag: " & aMetaMatch(0).Value & "----" & aMetaMatch(0).FirstIndex & "---" & aMetaMatch(0).length Response.Write "<BR>" Response.Write "Second Tag: " & aMetaMatch(1).Value & "----" & aMetaMatch(1).FirstIndex & "---" & aMetaMatch(1).length Set re = nothing End Function %> <% ShowMetatags "<meta FOO=""bar"" NAME =""DateCreated "" cONtenT=1999.11.24 >< META NAME = ""AuthorName"" CONTENT="" George Young"">" %> --------------------------------- Tag: TDC Control and Colors Tag: 142983
  - 8
    - run .vbs as a .exe? Hi, I am in this environment: WIN2K, SP3, with a Domain Controller. Currently, the executing of .vbs is controlled by setting Local Group Policy-User Configuration-System-Run only allowed Windows Application (with Apply Group Policy set) - wscript.exe I would like to know: a) Instead of placing the source-code in the server, can I create a .exe and place it in the server instead. If so, how can I do that? I would like to do this so as to control the access to the script. b) Instead of signing the .vbs script, is there other way to restrict access to executing of all .vbs script? I would like to allow executing of only certain .vbs script instead of open for all. Robin -- Posted via http://dbforums.com Tag: TDC Control and Colors Tag: 142982
  - 9
    - display text field at run time I want to display credit card fields when the user selects the option paid membership. If user selects the option free membership, then the credit card text field will disappear. Here's the code I did with JavaScript but didn't work. > <SCRIPT LANGUAGE="JavaScript"> > function generateCreditTextField() > { if (document.myform.membership.value == "1") > { alert('free'); > document.write(""); > } > else > { alert('paid'); > document.write("<P>Credit Card: <input type="text" name="credit")</P>"); > } > } > </SCRIPT> > > <form name="myform"> > <select name="membership" onchange="generateCreditTextField()"> > <option></option> > <option value="1">Free Membership</option> > <option value="2">Paid Membership</option> > </select> > </form> > > please advise! Thanks! > John > > Tag: TDC Control and Colors Tag: 142980
  - 10
    - security updates I installed security updates and now i cant run aspx pages on server. I get Server Application Unavailable The web application you are attempting to access on this web server is currently unavailable. Please hit the "Refresh" button in your web browser to retry your request. Administrator Note: An error message detailing the cause of this specific request failure can be found in the system event log of the web server. Please review this log entry to discover what caused this error to occur. can someone help??? thanks in advance Tag: TDC Control and Colors Tag: 142969
  - 11
    - reading from excel in vbscript I would like to read 5 different columns in an excel spreadsheet with vbscript. Can anyone please help me with a head start snippet. Thank you, Juan Tag: TDC Control and Colors Tag: 142968
  - 12
    - display text field dynamially I want to display credit card fields when the user selects the option paid membership. If user selects the option free membership, then the credit card text field will disappear. Here's the code I did with JavaScript but didn't work. <SCRIPT LANGUAGE="JavaScript"> function generateCreditTextField() { if (document.myform.membership.value == "1") { alert('free'); document.write(""); } else { alert('paid'); document.write("<P>Credit Card: <input type="text" name="credit")</P>"); } } </SCRIPT> <form name="myform"> <select name="membership" onchange="generateCreditTextField()"> <option></option> <option value="1">Free Membership</option> <option value="2">Paid Membership</option> </select> </form> please advise! Thanks! John Tag: TDC Control and Colors Tag: 142965
  - 13
    - Windows PE Wscript.shell run issues Hi, I have a RIS build which boots to windows PE, calls a HTA (to get build details) then based on those options, starts a 2003 or XP build. The problem i am having is with diskpart. When calling a vbs using WSHShell.run "Diskpart /s Z:\build\diskwork1.txt", 1, True The disk is partitioned and all is fine. When however calling this command from within the HTA, i get nothing. I would like to keep it within the one file if possible - anyone have any ideas? Tag: TDC Control and Colors Tag: 142962
  - 14
    - Script Question I have a situation where I need to deploy SP4 and MS03-026 & 039 to several workstations. In this particular environment, the company has not implemented AD. The only OU's present are those created by default during dcpromo. I've tried to convince them to implement AD but I may as well be talking to a wall. Also, I'm unable to use SMS, SUS (no good for SP4 and they won't consider it for hotfixes), or AD to deploy the service pack and hotfixes. Earlier today, I ran across KB 827227 http://support.microsoft.com/default.aspx?kbid=827227 . I believe it would be possible to modify this script to deploy SP4 prior to the hotfixes however, I'm not 100% certain how it would be accomplished and I've never used VBScript. Does anyone know how to modify this script to deploy SP4 first then the hotfixes or know of any other method I could use to deploy SP4 and the hotfixes rapidly? Tag: TDC Control and Colors Tag: 142946
  - 15
    - Convert WMI Date Excuse my ignorance but is there an easy way to convert the date returned by the CIM_Datafile class into a readable format, i.e.? objFile.LastAccessed returns 20030914074104.750000-420 Tag: TDC Control and Colors Tag: 142945
  - 16
    - Script question ? Hi, I'm thinking the problem here is that Documents and Settings contains spaces, does anyone have a fix for this. I'm sure it's simple I'm just new to scripting. XP Thanks strComputer = "." Set objWMIService = GetObject("winmgmts:" _ & "{impersonationLevel=impersonate}!\\" & strComputer & "\root\cimv2") Set colFolders = objWMIService.ExecQuery _ ("Select * from Win32_Directory where Name = 'C:\\Documents and Settings \Atl-2K\Favorites\'") For Each objFolder in colFolders errResults = objFolder.Delete Tag: TDC Control and Colors Tag: 142944
  - 17
    - DOS Hello I work with Focus at work under W98. Focus is a very old DOS database program. I have to do much typing there so I thought a small script with ' Sendkeys' could help me. But the Focus screen does not accept what I send. Is there a way around ? Many Thanks. A.Geeraert Tag: TDC Control and Colors Tag: 142941
  - 18
    - browser reload from external script Hello! does there exist a solution for my problem? Following situation: I start the internet explorer with a VBS script on a Win XP Machine with following code. The script is calles "start_ie.vbs" ######## Set wshell = CreateObject("Wscript.shell") wshell.run "iexplore.exe" ######## I execute the script and the browser window opens. Now is it possible to reload the browser by executing a second script for example called "reload.vbs" ?? I do not know how to obtain the object Id from the running browser instance. Pleas help me... Thanks a lot Georg Tag: TDC Control and Colors Tag: 142939
  - 19
    - Getting the output of a stored procedure in a VBScript I am running a stored procedure that needs parameters through a VBScript and I need to know to get the output from that procedure to a variable in the script. Here is how am I calling the stored procedure: Dim cnn Set cnn = CreateObject("ADODB.Connection") cnn.Open "Provider=SQLOLEDB;Data Source=myServer;Initial Catalog=myDB;Integrated Security=SSPI;Persist Security Info=False;" cnn.Execute "exec execute_job_with_return 'base' ,'00020' ,5 ,'ubi' ,'UC', 'loyalty' , 0, '000' , lty_rmmeltest ,'smart' ,'%DATA%\txn TEST.txt',' ' , 'Y' ,NULL" The stored procedure then returns an integer value (named "runid") which i need to use for further operations. Thanks in advance. Tag: TDC Control and Colors Tag: 142938
  - 20
    - script question I created a form to calculate the sum of 2 text fields with JavaScript, but it doesn't display the result after execute. here's the code, please advise! <HTML> <HEAD> <SCRIPT LANGUAGE="JavaScript"> function sum(x, y) { document.calc.result.value = x + y; } </SCRIPT> </HEAD> <BODY> <Form name="calc"> <input type="text" name="text1">+ <input type="text" name="text2"> <input type="submit" name="submit" value=" = " onClick="sum(text1.value,text2.value)"> <input type="text" name="result"> </form> </BODY> </HTML> Tag: TDC Control and Colors Tag: 142935
  - 21
    - Set the root element of xml by xmldom Hello, How can I set the root element of xml dom ? xmldoc = CreateObject("Microsoft.XMLDOM") ... and not how can I set the first (root) element ? Thanks :) Tag: TDC Control and Colors Tag: 142927
  - 22
    - Question about variables - newbie please be gentle I have not experience with VBScript, I am learning on the fly sorta. I am working on a project that I think is suited for VBscript. At work we have a series of files that are uploaded to various geographically located servers. The uploads are done on a daily basis however the file name changes everyday to reflect the current days date, e.g. this mornings was "sep13 report.xls". This needs to be done with around 40 files to three different network servers. I want to write a script to automate this process, where the user can input the appropriate dates and the script will find the local file (based on the inputted date) and transfer it to the remote drive. So far I have figured out how to define the variables (dim) and how to prompt for the user input (InputBox) - but when I go to use copyfile to try and tell the script to look for sep13 report.xls - I am not sure how to get it to use the variable (sep13) in the filename it is looking for? I hope this makes sense to you - it is as clear as I can explain it in newbie talk. Any suggestions regarding this problem specifically or the project in general would be greatly appreciated. Have a nice day! Tag: TDC Control and Colors Tag: 142925
  - 23
    - Make a status bar to a HTML application (HTA) Hello, How can I make a status bar to a HTML application window? I couldn't find such a property of the HTA:Application object. I would like to use a window.status = ... statement in a VB-script. JT -- Posted via http://dbforums.com Tag: TDC Control and Colors Tag: 142920
  - 24
    - How to write to hosts file Hello, From a jsp page running in IE 6 only browser how can I write an entry to the client machine hosts file. Client machine could be Win 2K and Win XP. an example entry in hosts file: SERVERIPADDRESS SERVERHOSTNAME Thank you in advance for your help. LCN -- Posted via http://dbforums.com Tag: TDC Control and Colors Tag: 142919
  - 25
    - mailing an Asp form with exchange Hope someone can help (I`m on page 1 of teach yourself VBScript). I am trying to create a form that I can email from a web server and exchange mail, I have only got so far in that evrything works in the To, From, CC, Subjct etc lines. What I have come completely stuck on is putting the form data into the textbody of the email. I can select one field from the form in iMsg.textbody but I do not have a clue how to include multiple fields. Any pointers appreciated, Cdonts doesnt seem to work as I am getting a permission error, the mail script below works fine with exchange. TIA John <%@ Language=VBScript %> <% submit = Request.Form.Item("B1") if submit = "Send" then Dim iMsg Set iMsg = CreateObject("CDO.Message") Dim iConf Set iConf = CreateObject("CDO.Configuration") Dim Flds Set Flds = iConf.Fields ' 3 means that you are asking mail to be sent using Exchange Server. Flds( "http://schemas.microsoft.com/cdo/configuration/sendusing") = 3 Flds("http://schemas.microsoft.com/cdo/configuration/user") = " " Flds("http://schemas.microsoft.com/cdo/configuration/password") = " " Flds.Update Set iMsg.Configuration = iConf iMsg.To = someone@host.co.uk iMsg.From = post@host.co.uk iMsg.CC = me@host.co.uk iMsg.Subject = "Open Day 21st October 2003 sent": & now() iMsg.TextBody = Request.Form.Item ("select") iMsg.Send end if %> <html> <head> <meta NAME="GENERATOR" Content="Microsoft Visual Studio 6.0"> </head> <body bgcolor=green > <% if submit = "Send" then %><font color=white><b><u> Mail Sent</u></b></font> <% else%> <form action="SendMail.asp" method="post" name="Form" id="Form"> <P> <base target="_top"> <TABLE cellPadding=4 cellSpacing=0 class=Nav2> <tr> <TR> <TD vAlign=top><p> <LABEL><font color="red">Select</font> </LABEL> </p> <p> <LABEL><font color="#FF0000">Select2</font></LABEL> </p></TD> <TD> <p> <select name="select"> <option selected>Please Select <option>Test CDONTS <option>Test CDO Ex </select> </p> <P> <select name="select2"> <option selected>Please Select <option>One <option>Two <option>Three </select> <BR> </P></TD> </TR> </TABLE> <P> <INPUT name=B1 type=submit value="Send"></P> </form><%end if %> </body> </html> Tag: TDC Control and Colors Tag: 142918

Hi

I'm using the TDC (Tabluar Data Control) to display computer system
information out of a text file. The first column contains the event type
(information, warning, error).

Is there a way to define a color (for the text or the cell) based on the
content (information, warning, error) in a TDC Control?

Many Thanks
Pius

Top

Re: TDC Control and Colors by Michael

Michael
Wed Sep 17 14:10:16 CDT 2003

asked/answered in microsoft.public.inetsdk.programming.scripting.vbscript

--
Michael Harris
Microsoft.MVP.Scripting

Windows 2000 Scripting Guide
Microsoft® Windows®2000 Scripting Guide
http://www.microsoft.com/technet/scriptcenter/scrguide/sagsas_overview.asp

System Administration Scripting Guide - samples scripts
http://www.microsoft.com/downloads/release.asp?ReleaseID=38942

WSH 5.6 documentation download
http://www.microsoft.com/downloads/details.aspx?FamilyId=01592C48-207D-4BE1-8A76-1C4099D7BBB9&displaylang=en

Top