ASP Interview Questions And Answers _ 6

Started by ganeshbala, Mar 27, 2008, 08:08 PM

previous topic - next topic
Go Down


ASP Interview Questions And Answers

How do you create a recordset object in VBScript?

//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)

" rs.MoveNext
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?

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 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?



What is a class in CSS?

A class allows you to define different style characteristics to the same HTML element.

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?


Go Up

Quick Reply

With Quick-Reply you can write a post when viewing a topic without loading a new page. You can still use bulletin board code and smileys as you would in a normal post.

Warning: this topic has not been posted in for at least 120 days.
Unless you're sure you want to reply, please consider starting a new topic.

Note: this post will not display until it's been approved by a moderator.
Please leave this box empty:

Type the letters shown in the picture
Listen to the letters / Request another image

Type the letters shown in the picture:

shortcuts: alt+s submit/post or alt+p preview
IT Acumens Web Designing Chennai | GinGly :: Build your Personal Website | CineBuzz :: Cinema News | My Kids Diary :: Kids Memories Writing :: Book Website @ 349 Rs monthly
Copyright 2005 - 2020 :: IT Acumens :: All Rights Reserved. :: Sitemap
ITAcumens Discussion Forum with 2 lakhs post running for 15 years - Powered by IT Acumens Dedicated Server