Search results for query: *

Hi, try this to connect to an oracle instance '--------------------------------------------------------- ' Include "Microsoft ActiveX DataObjects 2.7" ' with Extras --> Addins '--------------------------------------------------------- Sub TestIt() '--------------------------------------...

Hi, try this one: SELECT * FROM CountriesTable, ArticlesTable WHERE (((ArticlesTable.Field1) Like '*' & [CountriesTable.Field1] & '*'));

Hi, use WshShell.Exec instead of WshShell.Run and wait until the process has finished. '----------------------------------------------------------------------- ' execute commandline and get result into strResult '----------------------------------------------------------------------- Set...

Try this one Dim oFs: Set oFs = WScript.CreateObject("Scripting.FileSystemObject") If oFs.GetExtensionName("C:\_work\test.xls") = "xls" Then ' do actions End If

Use the RegExp-object from WSH Dim strSource As String strSource = "CWD002" '----------------------------------------------------- ' Insert Microsoft VB Script Regular Expression 5.5 ' using Extras -> AddOns into the project...

Hi, "oCmd.Prepared = True" compiles the statement against the database. This means the statement is only parsed once even if you insert more than one row. If you insert a second row, the insert will be faster because the statement is already "prepared / compiled". If you only insert one row...

Hi, maybe this code will help you (access database) '------------------------------------------------------------ ' create connection object -> here we use access '------------------------------------------------------------ Dim oCn: Set oCn = Wscript.CreateObject("ADODB.Connection")...

maybe the following lines will help... # Setup hash with array elements my $hash = { key => [ "a", "b", "c" ] }; # Display complete array print "@{$hash->{key}}\n"; # Display first element print "@{$hash->{key}}[0]\n";

maybe this will help you. use warnings; use strict; use XML::Simple; #----------------------------------------------- # read xml-file #----------------------------------------------- open( IN , "<./test.xml" ); my ( @doc ) = <IN>; close( IN ); my $xmlin = join( '',@doc ); # create string...

Look at this sites: http://www.perforce.com/ http://www-306.ibm.com/software/rational/offerings/scm.html http://www.serena.com/Products/dimensions/home.asp

use the RegExp-object from VBScript Regular Expressions '------------------------------------------------------------ ' This example explains the usage of the RegExp ' object to parse a string and replace values ' ' To use this example, go to Extras --> AddIns ' and inclde 'Microsoft VBScript...