Hello, my name is***** do you need the solution by (date, time, timezone)? Thank you.
The answer to item 3 is:
It is currently 8:15 eastern. Is it possible to have this done in an hour? 9:20?
Item 3 is:
net use X: \\FileServer1\PublicData netpass /user:netuser
I'm not sure I can complete it in an hour. I can do the VBScript items but I was hoping to get until maybe tomorrow at noon Eastern?
I only have two hours. How many can you do by then?
I can do all the ones except the VBScript items fairly quickly, the VBScript is going to take me some time to write and test. I might be able to nail it in that amount of time though.
Shall I give a shot anyway?
Sure, it would be appreciated.
There might be other experts online right now that could do it in that amount of time, so I could opt out for them to take a look.
Please do as I have time constraints
I can do it in the two hours, if I post them as I complete them would that help? Looking at it again I think I can do it in the hour but it might take a little more than that.
That's fine lets do it!
Alright I'm on it.
#3 is already done above
In #1 they don't give the table name so I'll assume they mean Computers is the table name.
sqlStr = "SELECT * FROM Computers WHERE ((Computers.Num_CPUs < 2) And (Computers.Memory < 4)) ORDER BY Computers.Room_Num;"
They say a 'speed of less than two' but there is no column indicating speed, so I assume they mean number of CPU's.
=== #2 is ===
net share PublicData=C:\Data
=== #3 is ===
=== #4 is ===
Const ForAppending = 8dim objFS, objStSet objFS = CreateObject("Scripting.FileSystemObject")Set objSt = objFS.OpenTextFile("C:\data\DataFile.txt", ForAppending, True)
=== #5 is ====
dim ageage = 25Wscript.Echo "Your age is " & age & ", but in 10 years you will be " & (age + 10) & "."
Thank you. This isn't so bad after all, got the hang of it now.
=== #6 is ===
Sub Swap(ByRef num1, ByRef num2)dim numTempnumTemp = num1num1 = num2num2 = numTempEnd Sub
And for the above, a stub to test it is:
dim num1dim num2num1=1num2=2Swap num1, num2Wscript.Echo "num1 num2:" & num1 & ", " & num2
=== #7 is ===
dim numArray(10)dim iFor i = 0 to 10 numArray(i) = (i * i)Next
And a test stub for above in case it is needed:
'Test codedim strOutstrOut = ""For i = 0 to 10 strOut=strOut & numArray(i) & ","NextWscript.echo strOut
And === #8 is ===
If (age > 12) And (age < 20) Then Wscript.echo "The value of age is a Teenager"Else Wscript.echo "The value of age is NOT a Teenager"End if
All VBscript I tested to verify it works properly.
Looks good, it is greatly appreciated..will pay and leave + feedback..Thanks!
Thank you, ***** ***** free to request me if I may be of future assistance: http://www.justanswer.com/computer/expert-nyprogrammer/
When you're all set, (you probably already know), clicking the 'accept' button is what makes the site pay me my portion. Thanks!