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 TouchToneTommy 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
...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
...& ReportSaveAs, True) VMS_Convert_HOSTS.WriteLine "REPORT NAME,ENTRY DATE,ID,IP ADDRESS,MAC ADDRESS,HOST NAME" CONST DETAILSPATTERN = "^\s*(\d{1,3}(\.\d{1,3}){3},(unspecified|[A-Fa-f0-9]{2}(:[A-Fa-f0-9]{2}){5}),(\w|-|\W){2,16})\s*$" For Each file in oFolder.Files If... -
Regular expression
...shyed away from them. but, i have a couple questions in regards to the following snippet (the test script to validate the pattern you gave me)... * IP:, MAC:, Host Name: were replaced with delimited commas to eventually be imported into a SQL database - hence the slight change Function... -
Regular expression
...expression. The pattern is (pseudo): (The characters IP:) (a space) (An ip address) (a space) (The characters MAC:) (a space) (a mac address *** either a mac address OR the word 'unspecified') (a space) (The characters Host Name:) (a space) (computer name *** follows active dir rules IE... -
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
...FROM table GROUP BY HOST but returns: HOST Cat I Cat II Cat III comp1 73622 260071 270901 comp2 73622 260071 270901 comp3 73622 260071 270901 * host field is correct, however counts are not by host but database overall... should return something like: HOST Cat I Cat II Cat III comp1 3...- 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
