• 100% Satisfaction Guarantee
Raj, Engineer
Category: Homework
Satisfied Customers: 1288
Experience:  4 + Experiance in IT Industry
16752232
Raj is online now

# These are for VBS and I Need help with them 1. (TCO 7) Assuming

These are for VBS and I Need help with them

1. (TCO 7) Assuming that you are connected to a database table called Computers with the fields Computer, Hostname Room_Num, CPU_Type, Num_CPUs, Bit_Size, OS_Type, Memory, and HDD_Size, write the SQL Query String sqlStr such that the fields Computer, Room_Num, and OS_Type will be displayed for the records that indicate an OS_Type of 'Fedora 10' or 'Windows XP'. The returned records should be sorted by OS_Type.

2. (TCO 5) Write a VBScript function called Average(num1,num2) that accepts two numbers and returns the average value of the two number

3. (TCO 2) Write the VBScript code lines that perform the following tasks: define a variable name that is initialized to “John Doe” and a variable age that is initialized to 35. Display a message that uses the variables “Your name isXXXXX and your age is 35.”
Hi There,

I will be helping you with the solution.
Let me know the deadline by which you need all the three Answers.

Thank you
Customer: replied 3 years ago.

They are due in 1 hour and 30 minutes

Ok Stay Online and I will provide you the Solution in about 1 hr. from now.
Customer: replied 3 years ago.

ok i will be here.

SOLUTION IS READY and as follows:

SOLUTION 1:
os_type1 = "Fedora 10"
os_type2 = "Windows XP"
orderby = "OS_Type"

sqlStr = fmt("select Computer, Room_Num, OS_Type _
from Computers where OS_Type in ('{0}','{1}') _
order by {2} asc", _
array(os_type1, os_type2, orderby))

SOLUTION 2:

Function Average(num1,num2)
Average = ( (num1 + num2) / 2 )
End Function

SOLUTION 3:

<script type="text/vbscript">
Dim name
Dim age

name = "John Doe"
age = 35

document.write("<p>Your name is " & name & " and your age is " & age & ".</p>")

</script>

-------------------------------------------------------------------------------------------------------------------------------
If you face any difficulty than feel free to ask for help.

If the solution file is satisfactory than Please don't forget to RATE the Answer.
It will hardly take few seconds to RATE my Answer

Thank You and Have a Good Day.