Recent content by chuckster1

thanks. its a long story but i was trying to create a generic depency check of access adps and related sql servers from a vbscript but it didn't support multiple recordsets. i ended up querying the schema instead. thanks again.

Hi There, I'm executing a stored procedure sp_depends 'param' and it sometimes returns 1 sometimes 2 result sets. Is there a way to specify which result set it returns? Chuckster.

I have struggled with impersonation for weeks with no sollution. I believe the problem to be that IIS\.NET impersonation will not work across a Network connection. The easist solution that I found is to edit the machine.config file. (This is clearly a big security risk)...

Looks messy and there is probably a much better way but hey it works. Function AddOptionToSelectList(strSelectListName,strOptionValue, strOptionText) Dim objectIndex On Error Resume Next For i = 0 To Document.all.Length - 1 If Lcase(Document.All.Item(i).name) =...

I want to pass a HTML object name to a function to perform the following task. It won't work because I don't know how to set the reference to the object. Javascript has the getElement command. Does vbscript has something similar? Function...

Hi There, I'm trying to create a web interface for some of my WMI scripts. If I pass the name of the computer that hosts the web page to the sub the wmi script works. If I pass the name of another computer I get the error shown below. I suspect that it is a permissions thing but I have tried...

Thanks for clearing that up M8. Regards Chuckster1

I thought I 'got' multidimenstional arrays until I tried to use it. I want to: myArray(0) to be "c:\test" myArray(0,0) = "file1.xxx" myArray(0,1) = "file2.xxx" myArray(0,2) = "file3.xxx" myArray(1) to be "c:\test2" myArray(1,0) =...

Try looking for chr(9) TAB or chr(13) Return in the string. eg If Mid(str, i, 1) = chr(9) Then... Hope that helps

How is this: I'm an Aussie and we like our dates dd/mm/yyyy. My SQL server likes dates in dd/mm/yyyy Vbscript displays dates in dd/mm/yyyy If I pass a date where the dd is < 13 then I don't get any errors and SQL records it as an Australian date (which is why the script worked inititally. If...

Hardcoding does work. I hope you have found some inspiration on your ceiling. Thanks Tarwn. Chuckster.

I'm sure my simple SQL statements worked before but now I'm getting a type convertion error. The ERROR: &quot;The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value&quot; Code: 80040e07 I tried Cdate(now()) And myDate = now() Isdate(myDate)...

When I have a good old batch file that does the job I use it often in conjuction with Vbscript. Set myShell = wscript.createObject(&quot;wscript.shell&quot;) myShell.run &quot;c:\BatchFile.bat&quot; or oProcess = myShell.Run(&quot;xcopy blah blah&quot;, 1, True) and the script monitors the...

Yes use mwolf00's method.

Another way would be. myArray = array(&quot;v&quot;, &quot;a&quot;, &quot;i&quot;) or Create a long string via a loop (this avoids redim etc) myString = &quot;s, p, l, i, t, m, e&quot; myArray = split(myString, &quot;,&quot;) myArray will now have 7 elements. Hope that helps. Chuckster1