Explore topic-wise InterviewSolutions in .

SQL INJECTION, to PREVENT you probably NEEDS to use Stored PROCEDURES instead of inline/in code SQL.

SQL Injection, to prevent you probably needs to use Stored Procedures instead of inline/in code SQL.

<P>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”

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”

document.forms [’FORMNAME’].elements [’COMBO NAME’].OPTIONS[i].value

document.forms [’formName’].elements [’combo Name’].options[i].value

The AMPERSAND symbol and ampersand SPACE underscore across MULTIPLE LINES.

The ampersand symbol and ampersand space underscore across multiple lines.

USE the SESSIONS OBJECT

Use the sessions object

USING COLSPAN and ROWSPAN.

Using colspan and rowspan.

Insert into table name (FIELD, field, field) Values (’dataA’, ‘DATAB’, ‘DATAC’);

Insert into table name (field, field, field) Values (’dataA’, ‘dataB’, ‘dataC’);

This STATEMENT forces the DECLARATION of VARIABLES in VB before using them.

This statement forces the declaration of variables in VB before using them.

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.

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.

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

%’>

CONTENTS collection - contains all VARIABLES added via SCRIPTS in global.asa.

STATIC collection - contains the NAMES of all objects.

Contents collection - contains all variables added via scripts in global.asa.

Static collection - contains the names of all objects.

-----tag: PROVIDES input spaces (text boxes, combo boxes, RADIO button, etc.) on a form CALLED FIELDS. It has three attributes TYPE, NAME and VALUE. TYPE provides the characteristics of the field and the NAME specifies a name to the field by which it can be referred.

-----tag: Provides input spaces (text boxes, combo boxes, radio button, etc.) on a form called fields. It has three attributes TYPE, NAME and VALUE. TYPE provides the characteristics of the field and the NAME specifies a name to the field by which it can be referred.

• TAGS provides SPACE for the user to input values.
• the form has a button to SUBMIT information back to the server.
• It transfers CONTROL to another ASP PAGE.
• It carries the information in the fields to another ASP page.

Application_OnStart- This EVENT will be FIRED when the FIRST visitor hits the page.

Application_OnEnd- This event runs when the server is STOPPED.

Application_OnStart- This event will be fired when the first visitor hits the page.

Application_OnEnd- This event runs when the server is stopped.

• ASP execute code on the server side whereas the browser interprets HTML.
• ASP can use any scripting LANGUAGES.
• GETS FEEDBACK from the user and return information to the user.
• CREATE pages that will be customized to display only THINGS that will be of interest to a particular user.
• Can edit contents of a web page by updating a text file or a database rather than the HTML code itself.

Contents COLLECTION CONTAINS all the VARIABLES established for a session WITHOUT USING the tag.

Static collection contains all the objects created.

Contents collection contains all the variables established for a session without using the tag.

Static collection contains all the objects created.

• Expires specifies the NUMBER of MINUTES before a page cached on a browser expires.
• Expires Absolute sets the date and time at which a page cached on a browser expires.

• Flush sends PREVIOUS buffered OUTPUT to the client immediately, but continues processing the SCRIPT.
• CLEAR erases any already-buffered HTML.
• End causes the server to stop processing the script.

INCLUDING the RUNAT=SERVER ATTRIBUTE

Including the RUNAT=SERVER attribute

Internet Explorer (SUPPORTS VBScript, JAVASCRIPT).

NETSCAPE Communicator/ NAVIGATOR (supports only JavaScript, VBScript can be also added too).

Internet Explorer (supports VBScript, JavaScript).

Netscape Communicator/ Navigator (supports only JavaScript, VBScript can be also added too).

• LOCK prevents clients from modifying the variables stored in the APPLICATION object.
• UNLOCK removes the lock from variables stored in the Application object.

• Minimizes NETWORK traffic by limiting the need for the browser and server to talk to each other.
• Makes for quicker loading time since HTML pages are only downloaded.
• Allows running programs in languages that are not SUPPORTED by the browser.
• Can provide the client with data that does not reside on the client’s machine.
• Provides IMPROVED SECURITY measures since the script cannot be viewed by the browser.

• REQUEST OBJECT
• Response Object
• Server Object
• Session Object
• APPLICATION Object

• Session _On Start This EVENT will be FIRED when a new USER begins a session with the WEB site.
• Session_OnEnd This event is CALLED whenever a session terminates.

• SessionID returns the session identification number for each user.
• Timeout sets the timeout PERIOD assigned to the Session OBJECT for any APPLICATION, in minutes.
• Codepage determines the code page that will be used to DISPLAY content.
• LCID a locale identifier, which determines time zone and language, rules for the system.

STATIC HTML BROWSER uses HTTP to REQUEST HTML file from the Web Server.

DYNAMIC HTML Browser uses HTTP to request an executable application rather than a Static HTML file.

Static HTML Browser uses HTTP to request HTML file from the Web Server.

Dynamic HTML Browser uses HTTP to request an executable application rather than a Static HTML file.

Application-scope means that VARIABLES (and OBJECTS) can be accessed from any ASP PAGES that are PART of the application.

Application-scope means that variables (and objects) can be accessed from any ASP pages that are part of the application.

ARRAYS are VARIABLES that store ITEMS of similar information.DIM ARRAY1 (4) (declares an ARRAY with the name array1 with 5 ELEMENTS).

Arrays are variables that store items of similar information.DIM ARRAY1 (4) (declares an array with the name array1 with 5 elements).

ASP is a server SIDE-scripting environment for BUILDING dynamic and interactive WEB pages. SINCE the scripts run on the server side, the web server does all the PROCESSING.

ASP is a server side-scripting environment for building dynamic and interactive web pages. Since the scripts run on the server side, the web server does all the processing.

ASP PROVIDES scripting engines that EXECUTE the corresponding scripting languages on the server side. Scripts should be encoded within the DELIMITERS.

ASP provides scripting engines that execute the corresponding scripting languages on the server side. Scripts should be encoded within the Delimiters.

BUFFER CONTROLS the HTML OUTPUT STREAM manually.

Buffer controls the HTML output stream manually.

By setting its EXPIRES PROPERTY to any date prior to TODAY Response. Cookies("COOKIE name"). Expires = Date 1.

By setting its Expires property to any date prior to today Response. Cookies("cookie name"). Expires = Date 1.

Collection is a SET of name/value PAIRS where the INFORMATION SUPPLIED by the client is STORED.

Collection is a set of name/value pairs where the information supplied by the client is stored.

CONTROLS the ASP execution ENVIRONMENT. It can set the amount of time script can run before an error occurs. Converts a virtual PATH to a physical path on the server. Takes a user supplied string and encode it into proper FORMAT for a URL string.

Controls the ASP execution environment. It can set the amount of time script can run before an error occurs. Converts a virtual path to a physical path on the server. Takes a user supplied string and encode it into proper format for a URL string.

Cookie collection does not have the COUNT property. COOKIES can have multiple values for the same cookie name but each value can be REFERRED USING a key whereas in a Form/Query string cookie each value has to be referred using an index value.

Cookie collection does not have the Count property. Cookies can have multiple values for the same cookie name but each value can be referred using a key whereas in a Form/Query string cookie each value has to be referred using an index value.

COOKIES are text files that store information about the user by which the web server identifies and marks each different VISITOR to a web site and determines where a user has been before. A cookie can store information only when the user sends it. Individual cookies are limited to 4 KB of data. The maximum number of cookies allowed is 300.

Cookies are STORED on client’s machine.

Cookies are text files that store information about the user by which the web server identifies and marks each different visitor to a web site and determines where a user has been before. A cookie can store information only when the user sends it. Individual cookies are limited to 4 KB of data. The maximum number of cookies allowed is 300.

Cookies are stored on client’s machine.

GETS information from the user. It has five collections by which VALUES can be accessed.

They are:

• QUERY string
• Form
• COOKIES
• Server Variables 
• CLIENT Certificate.

Gets information from the user. It has five collections by which values can be accessed.

They are:

IIS is a Web Server that provides Web services, not only for web pages but ALSO for FTP SITES and video and audio services. It integrates with the DATABASE facilities of SQL Server.

IIS is a Web Server that provides Web services, not only for web pages but also for ftp sites and video and audio services. It integrates with the database facilities of SQL Server.

It ALLOWS you to ACCESS (read/write) the contents of text FILES stored on the WEB server.

It allows you to access (read/write) the contents of text files stored on the web server.

It can be up to 255 CHARACTERS MUST start with an ALPHABET must not CONTAIN an EMBEDDED period or full-stop.

It can be up to 255 characters must start with an alphabet must not contain an embedded period or full-stop.

It CONTROLS the information sent to the user. The VARIOUS methods are:

• Response. WRITE - Sends information directly to a browser.
• Response.Redirect - Directs a user to a URL other than the requested URL.
• Response.ContentType - Controls the TYPE of content sent.
• Response. Cookies - Sets cookie VALUES.
• Response. Buffer - To Buffer information.

It controls the information sent to the user. The various methods are:

It is a Text File that CONTAINS the COMBINATION of the FOLLOWING:

• Text
• HTML tags
• SCRIPT Commands

It is a Text File that contains the combination of the following:

It is TEXT FILE that CONTAINS DETAILS about an ASP application, such as when it should BEGIN and end.

It is text file that contains details about an ASP application, such as when it should begin and end.

It lets you store and retrieve information in a flexible DATA STRUCTURE. Each value or information STORED in a Dictionary is associated with a key through which the information can be retrieved.

It lets you store and retrieve information in a flexible data structure. Each value or information stored in a Dictionary is associated with a key through which the information can be retrieved.

It PERMITS to CREATE more interactive Web Pages. Validation, formatting of web pages can be DONE. VBScript, JavaScript are some examples.

It permits to create more interactive Web Pages. Validation, formatting of web pages can be done. VBScript, JavaScript are some examples.

It provides ACCESS to the physical file system of the WEB server. It gets and manipulates INFORMATION about all drives in a server, folders and sub-folders on a drive and FILES inside a folder.

It provides access to the physical file system of the web server. It gets and manipulates information about all drives in a server, folders and sub-folders on a drive and files inside a folder.

It provides extra information by which it MAKES the site EASIER to manage. It can include text files using the #include STATEMENT, retrieve the size and last modification date of a file, define how variables and error messages are displayed and insert the values of HTTP variables in the page SENT back to the browser.

It provides extra information by which it makes the site easier to manage. It can include text files using the #include statement, retrieve the size and last modification date of a file, define how variables and error messages are displayed and insert the values of HTTP variables in the page sent back to the browser.

It stores INFORMATION about a User’s SESSION. GIVES a NOTIFICATION when a user session begins or ENDS.

It stores information about a User’s session. Gives a notification when a user session begins or ends.

It’s a COMPUTER that provides Web services on the INTERNET or on a LOCAL Intranet. It is designed to locate, ADDRESS and send out simple HTML PAGES to all other users who access these pages.

It’s a Computer that provides Web services on the Internet or on a local Intranet. It is designed to locate, address and send out simple HTML pages to all other users who access these pages.

It’s a method by which web PAGES can be BUILT and generally USED for formatting and LINKING TEXT.

It’s a method by which web pages can be built and generally used for formatting and linking text.