Recent content by JeremyG

Before you do option #2, make sure that your ISP will configure reverse-lookups for your mail server. Many ISP's such as AOL, will not accept mail from domains who's reverse lookup fails.

Wow this article doesnt make any sense to me. Why would I use the Exchange 5.5 Admin program for Exchange 2003? Looks like this article is in reference to removing Exchange 2000 from a pre-existing Exchange 5.5 site. This was the only exchange server I've ever had on this domain.

I installed Exchange 2003 on my domain. For various reasons including a server name change, I uninstalled Exchange as no one was actively using it, and cannot re-install it. I get the following error. --------------------------- Microsoft Exchange Installation Wizard...

Hmmm I dont think i was clear in my question. I actually DO mean WQL. WQL is a subset of SQL, and it's used in WMI programming. Unfortunately it doesnt support ORDER BY. So if i have this Dataset: Name Score John 8 Tim 10 Jen 30 Joe 5 Tina 22 Eric 2 James 8 I...

I need a query that will return only 5 records containing the highest value in a field. Specifically I need to query the EventLog with WMI and get the 5 most recent events. Normally this would be very easy, but WQL does not support ORDER BY. So basically it returns an un-ordered collection...

I'm trying to find a way to unbind a networking service from an adapter programatially. For example the QoS networking service...I would like to basically "uncheck" the box for it on the adapter dialog. I can't seem to find any way to do this through WMI, so I'm thinking maybe I can...

First of all, let me make a suggestion to make your code alot easier to look at, and also easier to edit. ----------------------------------------- Select Case handle Case "~*WarGod MA*~ *Venna*RGW" x = "admin" Case "-=Head-Administrator=-" x =...

One little-known feature of Microsoft Internet explorer is the Web Archive feature. go to a page and do a File, SaveAs.. For type select "Web Archive, Singlefile(*.MHT)" This saves a page with all text and graphics included. Pretty cool. Yea i know its not a programatic solution...

Try this this will move all of the comparing cycles off of the server's SQL query and onto the web server. <Use code here to load your &quot;NewCustNo&quot; values into an array called myArray> Set rsSQL = Server.createobject(&quot;ADODB.Recordset&quot;) strSQL = &quot;Select * from...

Dont need VB code at all.....execute this SQL Statment in your code. strSQL = &quot;INSERT INTO NewTable (Field1, Field2, Field3) &quot; & _ &quot;SELECT Field1, Field2 Field3 FROM OldTable&quot; connection.execute strSQL

Yes! exactly what I need, thanks alot. I was actually getting close to it, was trying the &quot;EXISTS&quot; function, but you saved me alot of time!!!

I'm trying to write a query that returns the following: 1. Field #1 from TableA 2. Field #2 from TableB (only when it's SoftwareID matches the ID in TableA, there are multiple records in TableB that match TableA) 3. Return ONLY the record which has the highest value of Field #3 in TableB...

I always run into all sorts of trouble when dealing with SQL ntext fields in a recordset (or loading into an array with get rowss).....especially if there are multiple ntext fields in a query. Can anyone shed some light, or point me to some reading on the subject?

Not sure, though i rarely use the execute... normlly I do this: ----------------------- Set rsList = Server.createobject(&quot;ADODB.Recordset&quot;) rsList.open &quot;String&quot;, MyConnection, 0, 1 ---------------------- It will return two columns, the first being the email and the second...

This would find duplicates in the name field..... SELECT Name, COUNT(Name) FROM MyTable GROUP BY Name HAVING COUNT(Name) > 1