Search results for query: *

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

I can't find this person's reply to your message....so i'll answer you. Since ASP code is executed on the server, and it gets processed and stripped out before it sends the results to the client....you cannot have a client-side event call an ASP function. You could emulate this by including a...

There's all sorts of issues when using ntext (or &quot;notes&quot; or &quot;blob&quot;) fields from a SQL database. I get all kinds of errors if my ntext field is not last in the record set, and even more errors if there is more than one ntext field. Does anyone know a good resource to find...

I would recommend changing the values in the recordset, and then doing a batch update. If I'm not mistaken, this would send the update data to the server in one large block rather than 3000 small ones. If I'm wrong here someone please correct me

I have a SQL database with a table consisting of about 16 fields. I create an ADODB recordset and execute my query with no errors. Then i do a GetRows() and it is loaded into an array. However for some reason the date fields and bit fields come up as blank in the array....and I can't figure...

Could you bring it all into one query then use the <br><br>&quot;Between [Enter STart Date] and [Enter End Date]&quot;as parameters for the date field?<br><br>Then base your report off the query. Am I understanding your question right ?.<br><br>Or you can make a form that they fill in the start...