How do you create a recordset object in
VBScript?
Answer1
//First of all declare a variable to hold the Recordset object, ex-
Dim objRs
//Now, Create this varible 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.
Explain the difference between POST and GET Method.
GET requests are string data that is visible to the end user via the URL
and a limit of 2kb, POST requests have no limit on total data and the
user can’t see the data in a query string.
Why do we use Option Explicit?
Answer1
To avoid multiple variables of the same name.
Answer2:
Correct answer is - This statement force the declaration of variables in
VB before using them.
How do you write an SQL insert statement?
insert into tablename (fieldA, fieldB, fieldC)Values(’dataA’, ‘dataB’, ‘dataC’);
How can you have different number of cells for each row of a table in
HTML?
using colspan and rowspan
What variable can you use to share info across the whole application for
one user?
Use the sessions object
What is string concatenation function in VBScript?
the ampersand symbol and ampersand space underscore across multiple
lines
How do you get the value of a combo box in Javascript?
Answer1.
document.forms[’formName’].elements[’comboName’].options[i].value
Answer2.
document.form_name.element_name.value
What is a class in CSS?
Answer1
A class allows you to define different style characteristics to the same
HTML element.
Answer2
class is a child to the id, id should be used only once, a css class can
be used multiple times:
div id=”banner”
p class=”alert”
When inserting strings into a SQL table in ASP what is the risk and how
can you prevent it?
SQL Injection, to prevent you probably need to use Stored Procedures
instead of inline/incode SQL
Which is the default Data types in VBScript?
Variant.
