How Do You Create A Record Set Object In Vbscript?

1.	How Do You Create A Record Set Object In Vbscript?
Answer» rs.MoveNext wend end if %’> Create Record set object. Place form FIELD value in a variable named “param”. Define query by concatenating strings and variable value. Open Record Set 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 Record Set isn’t empty. Begin executing a loop which goes through all records in the Record Set. Write each record’s “first name” and “last name” FIELDS to the page on a SEPARATE LINE. Move to Next Record. rs.MoveNext wend end if %’>

Answer»

rs.MoveNext

wend

end if

%’>

Create Record set object.
Place form FIELD value in a variable named “param”.
Define query by concatenating strings and variable value.
Open Record Set 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 Record Set isn’t empty.
Begin executing a loop which goes through all records in the Record Set.
Write each record’s “first name” and “last name” FIELDS to the page on a SEPARATE LINE.
Move to Next Record.

rs.MoveNext

wend

end if

%’>

Discussion