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!
-
Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
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...- bslintx
- Post #3
- Forum: Microsoft: Access Modules (VBA Coding)
-
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...- bslintx
- Thread
- Replies: 3
- Forum: Microsoft: Access Modules (VBA Coding)
-
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? -
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...- bslintx
- Post #6
- Forum: Microsoft: ASP (Active Server Pages)
-
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' -
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... -
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... -
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... -
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- bslintx
- Post #4
- Forum: Microsoft SQL Server: Programming
-
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- bslintx
- Post #3
- Forum: Microsoft SQL Server: Programming
-
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...- bslintx
- Thread
- Replies: 3
- Forum: Microsoft SQL Server: Programming
-
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 -
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 -
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... -
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...- bslintx
- Post #5
- Forum: Javascript
-
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...- bslintx
- Post #3
- Forum: Javascript
-
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 =...- bslintx
- Thread
- Replies: 4
- Forum: Javascript
-
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 -
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... -
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
