How do you create a recordset object in
//First of all declare a variable to hold the Recordset object, ex-
//Now, Create this varible as a Recordset object, ex-
*. 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
*. 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?
To avoid multiple variables of the same name.
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
using colspan and rowspan
What variable can you use to share info across the whole application for
Use the sessions object
What is string concatenation function in VBScript?
the ampersand symbol and ampersand space underscore across multiple
What is a class in CSS?
A class allows you to define different style characteristics to the same
class is a child to the id, id should be used only once, a css class can
be used multiple times:
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?