Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. estafford

    SMTP Authentication using Active Directory Accounts.

    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...
  2. estafford

    delete records from more than one table?

    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...
  3. estafford

    capture a url before navigating in a webbrowser control

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

    capture a url before navigating in a webbrowser control

    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...
  5. estafford

    Best way to compare and delete or insert within tables??

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

    should I be concerned?

    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...
  7. estafford

    Best way to compare and delete or insert within tables??

    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...
  8. estafford

    listing tbl fields using jscript

    ...<% var rsjsConn = Server.CreateObject(&quot;ADODB.Connection&quot;); rsjsConn.Open(MM_forums_STRING); rsjs = rsjsConn.Execute(&quot;select * from FORUM_FORUM&quot;) var columnTypes = new Array(205) columnTypes[0] = &quot;Empty&quot; columnTypes[2] = &quot;SmallInt&quot...
  9. estafford

    Default values are set to NULL

    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...
  10. estafford

    How to use XQuery

    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
  11. estafford

    Can I pass data to XQuery and XPath

    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...
  12. estafford

    No security on FTP on IIS

    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...
  13. estafford

    Can I pass data to XQuery and XPath

    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...
  14. estafford

    How to count rows matching a multi condition in an entire column

    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...
  15. estafford

    Return a list of tables in an MDB

    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...
  16. estafford

    Query to list table names?

    the ADOX info is scattered and I had to sort through it to get what I needed. I was then able to write the script I needed from that. It's all in VB and I prefer javascript so there was a lot of translation. This is a javascript example for you question.(server side) function...
  17. estafford

    Query to list table names?

    I wasn't able to create the list of tables using the MSysObjects system table. I kept getting &quot;no read access privledges&quot; errors using ASP. But after 2 and 1/2 days of research, I learned about the adox catalog object and was able to write a javascript to list the tables exactly the...
  18. estafford

    Error writing to a text file

    The following code works for me (I use jscript not vb) var addline = &quot;add this line&quot; var StrPath = &quot;path to textfile/file.txt&quot;; var objFSO = new ActiveXObject(&quot;Scripting.FileSystemObject&quot;); var objFile = objFSO.OpenTextFile(StrPath, 8, true)...
  19. estafford

    error: Record(s) cannot be read; no read permission on 'MsysObjects'.

    This is related to an earlier post (thanks to gol4 for the reply). I am trying to list tables using ASP and SQL from an access 2000 database. When executing the statement, I get the following error. Microsoft JET Database Engine error '80040e09' Record(s) cannot be read; no read permission...
  20. estafford

    How to return a list of database tables

    Greetings, I got the SQL for returning a list of tables in an access 2000 database from another forum, But I am unsure of how to execute it in an ASP page. The SQL is: SELECT MSysObjects.Name FROM MsysObjects WHERE (Left$([Name],4) <> &quot;Msys&quot;) AND (MSysObjects.Type)=1 ORDER BY...

Part and Inventory Search

Back
Top