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 derfloh 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. bslintx

    INSERT data into local Access DB from remote Access DB

    ty genomon for responding... i cannot link to the access files because they are dynamic - how many there are and the names change....hence using the file system object to find these files on-the-fly i have it retrieving and inserting into an access database as so: pseudo code - For each file...
  2. 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...
  3. bslintx

    VBScript to manage AD

    assuming you have permissions to do so...(creating/modifying objects in AD)...then is there any reason why you cannot use the Active Directory Users and Computers tool in adminpak.msi?
  4. bslintx

    Parse out a string

    you could do a replace and split all by -...however, splitting may be a moot point if you cannot guarantee 'needed' dashes or commas in the string...therefore a regular expression may help <% s = Replace("Example130-Your Analysis Bus-0.00-W-20032,Help130-My Analysis...
  5. bslintx

    Regular expression

    update: splitting DETAILS not needed because it has passed the pattern match - delimited with commas If IsValidRegEx(DETAILSPATTERN,DETAILS) Then VMS_Convert_HOSTS.WriteLine ReportName & "," & EntryDate & "," & DETAILS Else ' ... End If'
  6. bslintx

    Regular expression

    thanks for the invaluable input tsuji... i have not applied your logic yet...it seems to have a nice precision to it and i will certailnly apply accordingly... 1. i took out the SHORTCIRCUIT as i was getting erroneous results...it was only there for i feared an infinite loop. but, it looks...
  7. bslintx

    Regular expression

    tsujii, Fistly, thanks for taking the time to help out. I applied your pattern and it had the same results as my original string. Because of this I figured it had to be a logical error, therefore I created a small sub routine to test out the pattern...and sure enough - I found a logical error...
  8. 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...
  9. bslintx

    SQL statement - Multiple COUNT

    Thanks bborissov! I was 'googling' while you posted and came up with something very similar...i was surprised to see a fast reply! a star for what ultimately would have been the answer Thanks
  10. bslintx

    SQL statement - Multiple COUNT

    I ended up with a 'pivoting' solution: SELECT HOST, COUNT(CASE WHEN Severity = 'Category I' THEN 1 END) AS [Cat I], COUNT(CASE WHEN Severity = 'Category II' THEN 1 END) AS [Cat II], COUNT(CASE WHEN Severity = 'Category III' THEN 1 END) AS [Category III] FROM table GROUP BY [HOST]; Thanks
  11. 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...
  12. bslintx

    help with time counter

    WScript.Sleep(5000) WScript.Echo("You delayed this message by 5 seconds") post relevant code if sleep is not what is needed
  13. bslintx

    Please do not laugh at my first login.vbs script.

    google is your friend keywords: vbs active directory logon scripts http://www.computerperformance.co.uk/Logon/logon_scripts.htm
  14. bslintx

    Combining several scripts

    you may want to consider using a .hta...it's a GUI representation of your vbs code... i intentionally left out move to ou and remove functions...hopefully the way it's written...you can follow the logic...if not...let us know...good luck save as FindUser.hta <html> <head> <title>User...
  15. bslintx

    how to insert ado recordset data with javascript

    again....speed i understand the loop is used against the getstring ...i also understand as i mentioned i may as well use get rows...a 2d array....the loop is FAR slower in generating the recordset reslts....the code works as is if on server side...no loops...just getstring.....it's lightning...
  16. bslintx

    how to insert ado recordset data with javascript

    tsuji, i truely appreciate the response...unfortunately...using the for loop pretty much defeats the purpose of me using getstring...i may as well use getrows i therefore used fso to generate a comma delimited getstring and this satisfies the speed i need vs looping yes...i close the...
  17. 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 =...
  18. bslintx

    trying to query exchange server with WQL and like/wildcard

    also...the * was the wrong one posted ...all demos used %...it just happened to be the last one i was experimenting with on a copy/paste/post...good eye dm4ever
  19. bslintx

    trying to query exchange server with WQL and like/wildcard

    unfortunately yes...i can't for the life of me understand why it doesn't work....if someone has successfully ran the like in this situation...please let me know....it would be appreciated.... btw....i can obviously grab all mailboxes (2000+) in this case and loop with an instr but i'd rather...
  20. bslintx

    trying to query exchange server with WQL and like/wildcard

    forgot to mention...it's a .hta....i'm sure that was inplied w/ the innerhtml but just in case...thanks

Part and Inventory Search

Back
Top