(a)Explain what the codes below would do
<HTML>
<HEAD>
<TITLE>VBScript Example</TITLE>
<!-
UserName = InputBox("Enter Your Name?")
MsgBox UserName
Document.Write "<H1>"
Document.Write "My name is: " & UserName
Document.Write " <\/H1>"
->
</SCRIPT>
</HEAD>
</BODY>
Sub curconvert(amount)
Response.write(“The amount is equivalent to ”)
Response.write("GHC. " + amount*2.5)
end sub
(b)Given the form code below, Discuss what each line will achieve and write the ASP code to recieve and output information passed to process.asp.
<form method= “post” action= “process.asp”>
Mr/Mrs/Ms: <input type= “text” name= “title”><br>
Name: <input type= “text” name= “name”><br>
Email: <input type= “text” name= “email”><br>
<input type=s “submit” value= “Send”>
</form>
(a)The ASP script below has errors, rewrite a debugged version.
Welcome <%
response.write(querystring(title”)) write(request.querystring(“name”) & “!”)
%>
(b)Discuss the following
I. ODBC
II. ADO
III. DSN
(a)Write out the SQL syntax for the following operations and using a car as an entity example, write sample statements each
I. Removing a Record from an entity
II. Updating a Record from an Entity
III. Adding a record to an entity
IV. Searching for a record in an entity
(b)Given the code below discuss what will be achieved using this code and the various aspect of each line code.
<%
Dim objConn
Dim sql
Set objConn = Server.CreateObject
(“ADODB.Connection”)
objConn.Open “DSN=OUM”
sql = “Update Publisher set Name = 'Dewan Bahasa
dan Pustaka' where Publisher_ID = 1”
objConn.Execute(sql)
Response.Write “Publisher name has been updated”
objRec.Close
objConn.Close
Set objRec = Nothing
Set objConn = Nothing
%>
I need help on the above questions, writing this exams in 5 hours time. Please help me solve this, a beginner here