ASP Programming Question:

Download Job Interview Questions and Answers PDF

How do you create a recordset object in VBScript?

ASP Programming Interview Question
ASP Programming Interview Question

Answer:

Answer1
//First of all declare a variable to hold the Recordset object, ex-
Dim objRs
//Now, Create this variable as a Recordset object, ex-
Set objRs=Server.CreateObject(ADODB.RECORDSET)
Answer2
” rs.MoveNext
wend
end if
%’>
*. Create Recordset object
*. Place form field value in a variable named “param”
*. Define query by concatenating strings and variable value
*. Open RecordSet Object. Note that the first parameter is the Command Text. The second parameter is the Connection String. The Command Object and Connection Object are created implicitly.
*. Make sure the RecordSet isn’t empty
*. Begin executing a loop which goes through all records in the RecordSet.
*. Write each record’s “firstname” and “lastname” fields to the page on a separate line.
*. Move to Next Record.

Download ASP Programming Interview Questions And Answers PDF

Previous QuestionNext Question
What are the tags necessary to be present within the tag ?Explain the difference between POST and GET Method.