Recent content by estafford

greetings, I have an IIS smtp virtual server on a W2K server machine. This server is on an Active Directory network. When I send mail through the SMTP server, I want to authenticate using the AD accounts but authentication fails. If I add a Local user account on the machine with the same name...

We are using archiving software that stores info in an access database. The database contains three tables that I'll call tb1, tb2, and tb3. All tables have a field called "id" tb2 and tb3 might have matching "id" values to tb1. What I want to do is delete data from tb1 and if tb2 and tb3 have...

I finally figured this out for myself. object_BeforeNavigate2(object sender, AxSHDocVw.DWebBrowserEvents2_BeforeNavigate2Event e){ string strWebpage = e.uRL.ToString(); }

Greetings, I am creating an application for browsing our intranet using VS C# and a webbrowser control. What I want to do is: Capture the url string before navigation and compare it to a handful of domains I have in an array. If it matches, allow the navigation. If it dosen't match, cancel the...

Thanks for the info. The LOAD DATA feature is exactly what I needed. Thanks

The last couple of days, I notice that our email is being routed to a backup system. We have a primary T1 connection with IP1. A DSL connection as backup to the T1 as IP2 (this in only connected when T1 goes down. We use 3 mx records to route mail and host our own mail server. If IP1 is down or...

I am working on a project and i'm not sure of the best way to do what I need to. I have a CSV file that contains addresses. I need to compare the csv file to a MySQL table (tbl_bl). Then if the addresses are not found in tbl_bl, I need to add the addresses to another table (tbl_wl) Only if...

Greetings, I am looking for a way to list the field or column names of a table. i have found several examples using VBscript, but I need to do this using JScript or Javascript. Here is what I have. (converted from a working sample in vbscript) <% var rsjsConn =...

I have a database that has default values for several fields. When opened in design view and saved, the default values are cleared creating NULL value errors in my forum app. I have some ideas about waht is causing this but not completely sure. I have been troubleshooting this problem for over...

Does anyone have any suggestions for using XQuery and XML on the desktop without using a web server on a windows platform? Can it even be done? I'm just looking to expirement a little. Thanks ES

Thanks Flumpy, Any help would be appreciated. I'd love to take a look at your samples. I have not used XML, XPath, or XQuery before. It seems the best choice for this project. Would I be able to pass an XQuery to the XML doc using flash's XML.sendandload method? As I understand it, this would...

Try this... You may need to set &quot;log on Locally&quot; permissions for FTP users in your local security policy. Heres what I had to do on a Windows 2000 Server platform. It should be pretty similar for XP. 1. create a new user group account, something like &quot;allowFTP&quot;. 2. Make...

1. Can I pass data to XQuery and XPath from an application? If yes... 2. Is it possible to build a query in XQuery and XPath from the data passed from an application. I am trying to develop an application using Flash with XML. I want to query the XML file using data passed from flash without...

I need to count rows that match multiple conditions from two or more columns. example: count rows where column A = &quot;string&quot; and column B = &quot;string&quot;. I can get the count of a single condition on a complete column (A:A). But I cannot get it to work using multiple conditions...

In access, open your database, hit the tools menu and select options. In the &quot;view&quot; tab make sure that &quot;system objects&quot; is checked. You should now see about five new tables including &quot;MsysObjects&quot;. Now you should be able to run the Query posted by gof4 I hope...