i am havin a bit of trouble with a report I am trying to generate. I have 2 databases on 2 seperate mysql hosts. Database 1 holds monitoring info and Database 2 holds account info (again, these are 2 different mysqwl hosts).
What I am trying to accomplish is being able to sort by the account_id...
I am trying to determine if a varaible is defined and if it also certain data. I am using the defined function to test if it is set, but am having trouble finding a way to test if it contains a certain word anywhere in te variable.
Can anyone offer any insight on this?
ok, the window that pops up when there i an issue with your vbscript, is there a way to capture this toe the event log as an error?
Basically, i want to know if the script has any issues running and since i get alerted on errors in event log that would be ideal.
Thanks so much Jet042! It pointed out the errors in my ways. My last post will not work as I did not take into account if the day is only 2 characters. I have modified to be this:
-----------------------------------------------------------
For Each objFile in colFiles
modDateFull =...
I may have fixed this myself, though most likely not as elegant as some could have. here is what i have now to get just the creation date of a file with dashes instead of slashes!:
modDateFull = objFile.DateCreated
modDateNum = Replace(modDateFull,"/","-")
modDate = Left(modDateNum,9)...
OK, i am using the
createDateFull = objFile.DateCreated
to get the date/time files are created in one directory. However, it seems that if the date is say 08/23/2007 it grabs it as 8/23/2007. My question is: How can i make it use the leading zero in the variable?
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.