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 TouchToneTommy 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: *

  • Users: bslintx
  • Content: Threads
  • Order by date
  1. bslintx

    INSERT data into local Access DB from remote Access DB

    I am trying to insert data from one Access database from another...I can get the following query to work on a remote Access database... sSQL = "SELECT * FROM Activity IN """ & sRtdPath & """" however, I need to include an inner join like so: sSQL = "SELECT DISTINCT Machine.DisplayField...
  2. bslintx

    Regular expression

    Fellow members, I have to parse data from a .txt file generated by an application. (line-by-line) Unfortunately, it does not have a strict structure like .xml so I have to check if it satisfies a particular pattern - thus I chose to use a regular expression. The pattern is (pseudo): (The...
  3. bslintx

    SQL statement - Multiple COUNT

    Counting on one field is all I ever needed, however, i need 3 this go around... 1 table, 400,000+ records, need to return distinct computers (GROUP BY <assuming) with a count on severity of 'Category I','Category II',Category III' I currently have: SELECT HOST, (select count(severity) from...
  4. bslintx

    how to insert ado recordset data with javascript

    hey all... i'm retrieving a recordset via javascript and ado. the ado method i am using is getstring. i am used to server side code...and i was wondering why i cannot get a string returned by getstring to work correctly in the following: <script> var sDatabasePath = "tree.mdb"; var cn =...
  5. bslintx

    trying to query exchange server with WQL and like/wildcard

    ok, i'm at wits end here i am trying to query exchange server using like, however i receive "Could not complete operation due to error 80041024" this is the code that has the error: Set SWbemLocator = CreateObject("WbemScripting.SWBemlocator") Set objWMIService =...
  6. bslintx

    window.setInterval logic (VBS)

    hey all...i have no idea why i can't get the logic down with this... i have an hta...in which cannot use sleep so ended up choosing window.setInterval the problem: i have successfully displayed the loader however...my logic was off...i was displaying the loader delay>loop>display loop results...
  7. bslintx

    dump ado data to excel xls with subscript error

    hey all, i though i had the code wrapped up but... the problem at hand is for whatever reason i get a subscript out of range error when trying to create more than 3 worksheets... the following simulation of my code... Function DumpToExcel() strExcelPath = "test.xls" Set oExcel =...
  8. bslintx

    how to dynamically add worksheets to excel via ado and recursive funct

    hey all, i'm trying to loop through an ado recordset on active directory and dumping results to an excel spreadsheet... i can create and add to the /xls; however, i'm having trouble with the loop(not expecting the results intended)... i simulated the ado recordset w/ a for next... here's...
  9. bslintx

    Function to convert Unicode to ascii

    Hey all, I have an HTA that parses out a application's lof file (dispatch.log). I can copy and paste manually to a text file and works great; however, it's wasn't my intention to have to do any "manual" copy/paste. I have looked(googled) and I saw a couple functions that by name seemed to be...
  10. bslintx

    Unable to print AJAX tree

    Hi all, i'm at wits end here and hopefully someone can give me a fix action Description: I am using serverside script and ajax to create a tree based on user's selection. Problem: 1. No tree is displayed(or errors) when user selects a view. Debug: 1. AJAX...
  11. bslintx

    Page loading message w/ multiple frames

    hi all...i am hoping someone can point me in the right direction on how to show a message while page is loading... the problem i have is the page contains multiple frames main page (frame structure) - checklist_frame.asp <html> <head> <title></title> </head> <frameset framespacing="6"...
  12. bslintx

    How to grab a radio(group) element and concatenate in a string

    hi all, i have an asp page that produces dynamic checklists. i am trying to implement ajax technology into it and so far this has been accomplished. my problem now is i am trying to concatenate a "key" comprised of database/form values. this key is passed to ajax function(get) and...
  13. bslintx

    Active Directory LDAP query

    Hi, i am trying to lookup "distinct" title's in AD; however, i had no luck. i am using.... Set oRs2 = oConn.Execute("SELECT name, title, physicaldeliveryofficename " & _ "FROM 'LDAP://" & getUnitPath & getDomain & "' " & _ "WHERE...
  14. bslintx

    dynamic between statement

    HI all, Ok...rudy showed me how to search a rec for a certain date but I really need is a way to search by time. I want to query between times...harcoding works fine; ie, Set oRs = oConn.Execute("SELECT * FROM tblArchives WHERE SnapTime BETWEEN '4/20/2006 11:30:00 PM' AND '4/21/2006 12:50:00...
  15. bslintx

    using convert in where clause

    i can't believe i can't get this... all i want to do is select a datetime field that is equal to today's date..please help SELECT SnapTime FROM tblArchives WHERE (CONVERT(varchar, SnapTime, 101) = GETDATE())
  16. bslintx

    How to insert a record every nth minutes

    Hi all, I am very new to mssql server and would appreciate so input on my problem. SCENARIO: I have a database that contains numbers that need to be recorded during a particular time span. A start and end. In a nutshell, these are personnel accountability numbers. Meaning, how many folks were...
  17. bslintx

    How to query Active Directory w/ asp

    Hi all, Having a heck of a time trying to find examples of how to query an Active Directory database. The following code works w/o a hiccup; however, I can't seem to figure out how to setup the strQuery like I am used to querying an Access/SQL database. I am trying to do a simple query to grab...
  18. bslintx

    ms access database table link problem

    hello all, finally, i get to submit a problem..lol anyways i have a personnel table listing all personnel in an organization. i test on a local laptop setup w/iis win xp pro. i "link" the table from another database application so i don't have to create the same database table over again. i'm...
  19. bslintx

    intermittent CDO.Message.1 error '80040213' problem

    I get this error intermittently. I have cleared cache in browser and have to scratch my head as to why it would be intermittent? Either it can connect....or not...not either or. Please advise. Thanks. Brian NOTES: Using IIS, XP Pro, CDOSYS server is elaptop and checked dns ---is good Dim...
  20. bslintx

    Trying to create an sql query that results in no duplicates

    HI everyone, I am using an Access db and asp to track software on pc's. What the final output is SUPPOSED to show is a MASTER list of software from the table (tblSoftware) AND what software is actually on a user's pc from the table tblCompSW. The idea is to have a list for the user to choose...

Part and Inventory Search

Back
Top