php connectvity

=http://www.w3schools.com/PHP/php_mysql_connect.asp

Regulatory agencies

Regulatory agencies
A regulatory agency (also regulatory authority, regulatory body or regulator) is a public authority or government agency responsible for exercising autonomous authority over some area of human activity in a regulatory or supervisory capacity. An independent regulatory agency is a regulatory agency that is independent from other branches or arms of the government.
Regulatory agencies deal in the area of administrative law—regulation or rulemaking (codifying and enforcing rules and regulations and imposing supervision or oversight for the benefit of the public at large). The existence of independent regulatory agencies is justified by the complexity of certain regulatory and supervisory tasks that require expertise, the need for rapid implementation of public authority in certain sectors, and the drawbacks of political interference. Some independent regulatory agencies perform investigations or audits, and some are authorized to fine the relevant parties and order certain measures.
Regulatory agencies are usually a part of the executive branch of the government, or they have statutory authority to perform their functions with oversight from the legislative branch. Their actions are generally open to legal review. Regulatory authorities are commonly set up to enforce standards and safety, or to oversee use of public goods and regulate commerce. Examples of regulatory agencies are the Interstate Commerce Commission and U.S. Food and Drug Administration in the United States, Ofcom in the United Kingdom, and the TRAI in India.

keywords
regulatory agencies wikipedia
regulatory agencies definition
federal regulatory agencies
independent agencies
Searches related to Regulatory agencies
federal regulatory agencies
challenges of balancing agency autonomy
independent regulatory agencies
pharmaceutical regulatory agencies
journal of regulatory agencies
types regulatory agencies
regulatory state, State Pesticide Regulatory Agencies, Concept:Government Regulatory Agencies , Federal and State Regulatory Agencies - Links - Integrated ...,International Organizations and Foreign Government Agencies - FDA,
Regulatory authorities in India :: Adfactors PR :: Financial PR ,
Regulatory Agencies in India
regulatory agency
International Regulatory Agency Links

Radio control

Radio control
Radio control (often abbreviated to R/C or simply RC) is the use of radio signals to remotely control a device. The term is used frequently to refer to the control of model vehicles from a hand-held radio transmitter. Industrial, military, and scientific research organizations make use of radio-controlled vehicles as well.
The first general use of radio control systems in models started in the early 1950s with single-channel self-built equipment; commercial equipment came later. The advent of transistors greatly reduced the battery requirements, since the current requirements at low voltage were greatly reduced and the high voltage battery was eliminated. In both tube and early transistor sets the model's control surfaces were usually operated by an electromagnetic escapement controlling the stored energy in a rubber-band loop, allowing simple on/off rudder control (right, left, and neutral) and sometimes other functions such as motor speed.
Crystal-controlled superheterodyne receivers with better selectivity and stability made control equipment more capable and at lower cost. Multi-channel developments were of particular use to aircraft, which really needed a minimum of three control dimensions (yaw, pitch and motor speed), as opposed to boats, which can get away with two or one.
As the electronics revolution took off, single-signal channel circuit design became redundant, and instead radios provided proportionally coded signal streams which a servomechanism could interpret.
More recently, high-end hobby systems using Pulse-code modulation (PCM) features have come on the market that provide a computerized digital bit-stream signal to the receiving device, instead of analog type pulse modulation. However, even with this coding, loss of transmission during flight has become more common in part because of the ever more wireless society.

key words
Searches related to radio control
radio control circuits
radio control sports
radio control planes
radio control boats
radio control distributors
sanwa radio control
2.4 ghz radio control
radio control toys
Callide Valley Radio Control Car Club
Radio Control | ebay
Grig: Free, Ham Radio Control Application
Electrical Equipment/Radio control systems
RCGroups.com: The ABCs of Radio Control - Aircraft, Boats, and Cars!
RC Cars & Trucks News, Videos, Photos, Blogs, Games - RC Car Action
Tower Hobbies - Best Source for Radio Control ( R/C or RC ) Cars
IndiaRC ...My Hangar on the Net
HowStuffWorks "How Radio Controlled Toys Work"
Radio control

Press releases

============================
Press releases
A press release, news release, media release, press statement or video release is a written or recorded communication directed at members of the news media for the purpose of announcing something ostensibly newsworthy. Typically, they are mailed, faxed, or e-mailed to assignment editors at newspapers, magazines, radio stations, television stations, and/or television networks. Commercial press release distribution services are also used.
The use of press releases is common in the field of public relations (PR). Typically, the aim is to attract favorable media attention to the PR professional's client and/or provide publicity for products or events marketed by those clients. A press release provides reporters with an information subsidy containing the basics needed to develop a news story. Press releases can announce a range of news items, such as scheduled events, personal promotions, awards, news products and services, sales and other financial data, accomplishments, etc. They are often used in generating a feature story or are sent for the purpose of announcing news conferences, upcoming events or a change in corporation.
A press statement is information supplied to reporters. This is an official announcement or account of a news story that is specially prepared and issued to newspapers and other news media for them to make known to the public.


key words
Searches related to Press releases
sample press releases
writing press releases
press releases 2009
free press releases
bc government press releases
google press releases
deleg press releases
press release format
Press & Media Resources
Informatica Press Releases - 2011
Propeller (aircraft)
harma Model Aero Engines & Propellers - India's open forum for RC
Images for Propellers
APC Propellers, props for model airplanes
Marine Propellers and Propulsion, Second Edition
Hartzell Propeller Inc.
Propellers
Press & Media Resources
Press Release - PRD Kerala

Propellers

Aircraft propellers or airscrews convert rotary motion from piston engines or turboprops to provide propulsive force. They may be fixed or variable pitch. Early aircraft propellers were carved by hand from solid or laminated wood with later propellers being constructed from metal. The most modern propeller designs use high-technology composite materials.
The propeller is usually attached to the crankshaft of a piston engine, either directly or through a reduction unit. Light aircraft engines often do not require the complexity of gearing but on larger engines and turboprop aircraft it is essential.
The purpose of varying pitch angle with a variable pitch propeller is to maintain an optimal angle of attack (maximum lift to drag ratio) on the propeller blades as aircraft speed varies. Early pitch control settings were pilot operated, either two-position or manually variable. Following World War I, automatic propellers were developed to maintain an optimum angle of attack. This was done by balancing the centripetal twisting moment on the blades and a set of counterweights against a spring and the aerodynamic forces on the blade. Automatic props had the advantage of being simple, lightweight, and requiring no external control, but a particular propeller's performance was difficult to match with that of the aircraft's powerplant. An improvement on the automatic type was the constant-speed propeller. Constant speed propellers allow the pilot to select a rotational speed for maximum engine power or maximum efficiency, and a propeller governor acts as a closed-loop controller to vary propeller pitch angle as required to maintain the RPM commanded by the pilot. In most aircraft this system is hydraulic, with engine oil serving as the hydraulic fluid. However, electrically controlled propellers were developed during World War II and saw extensive use on military aircraft, and have recently seen a revival in use on homebuilt aircraft.

keywords

Propeller (aircraft)
Ducted propeller
Voith Schneider Propeller
Propeller (disambiguation)
Modular propeller
Cleaver (propeller)
Category
Folding propeller
More results from wikipedia.org »
========================================

connection of database in frontpage

You might not want FrontPage 2003 to create an entire Web-based interface for your database needs.  You might instead require database elements to be integrated into your existing Web site.  The rest of this paper will explain how to do just that.

Steps to Creating a Simple Form in FrontPage 2003

To create a new page with a feedback form:

·         Select File | New | Page or Web.  This will open the New Page or Web task pane.  Select Page Templates from the task pane.  The Page Templates Dialog Box will appear.

·         In the “General” tab, select “Feedback Form.”

·         Click “OK” in the lower right-hand corner of the “New” dialog box.

·         Edit the form to represent your specific needs.  You can see FrontPage Help (F1) for more information on how to edit and customize forms.

·         Select File | Save.

·         Name the page “feedback.asp” and click “Save”.

Note: You don’t have to use the Form Wizard to create forms in FrontPage 2003; it is one tool that might make form creation easier.  You can create any kind of form one piece at a time with individual form elements, by selecting Insert | Form, and then adding form fields to suit your needs.

Managing Forms and Databases

Once the customer feedback form is created, you can then use FrontPage 2003 to either save the results to an existing database or create a new database to save results to.  FrontPage 2003 will connect to any database that can connect via ODBC, the Open Database Connectivity standard.  It is important to note that the only type of database FrontPage 2003 can create is an Access database.

Creating a Database Within Your Web

It is easy to create a database from scratch using FrontPage 2003.  Once you have completed your form, follow these simple steps to automatically create a database in which to store your form information.

·         Right click inside the form boundary (the dotted line).

·         Select “Form Properties”.  This will open up the “Form Properties” dialog box.

·         Select the “Send to database” radio button.

·         Click the “Options” button in the lower left-hand corner of the Form Properties dialog box.  This will open the “Options for Saving Results to Database” dialog box.

·         Click on “Database Results” tab.

·         Click the “Create Database” button.  FrontPage will create a new Access database, as well as the database connection in global.asa that you can use for later reference to that database.  An alert will pop up to let you know when FrontPage 2003 has finished this process.

·         Click “OK” to dismiss the alert.

·         Click the “OK” button in the lower right-hand corner of the “Options for Saving Results to Database” dialog.

·         Click the “OK” button in the lower right-hand corner of the “Form Properties” dialog.

·         Save the page (make sure that it is saved with an .asp extension).

FrontPage 2003 will name the database based on the title of the page you created the form on.  A Results table will be created in the database and will contain one column for each form field as well as some additional columns (Remote Computer Name, User Name, Browser Type and Timestamp) that you might find useful.

You can test the form by publishing your Web site to your Web server and then viewing the page you’ve just created in the browser.  Go ahead and complete the form and then click the Submit button.  You can verify that the form results were saved to your database by creating a Database Results Region described below in Displaying Form Results.  That’s it!  Just a few steps and FrontPage 2003 will create a database for your site and write all of the ASP code required to save form results to the database.

Sending Form Results to an Existing Database

Part of the power of database integration with FrontPage 2003 is that you don’t have to start from scratch.  You may already have an existing Access database that you would like to integrate with your Web site.  To do this, you must first import the database into your Web site and create a connection to it.  This too, is easy, and you have two options to help carry it out.

The first option is to simply import that database by selecting File | Import from FrontPage 2003.  This will open an Import dialog box that will let you add any file to your Web site.  You can add your database to your existing Web using this method quickly and easily.

The second option entails taking advantage of the drag and drop features provided by FrontPage 2003.  Again, the power of being integrated with a larger Office Suite becomes clear if you follow this path:

·         Open the folder list view in FrontPage (View | Folder List)

·         With FrontPage still open, launch Windows® Explorer.

·         Navigate to the files you wish to copy to your web.

·         Drag and drop these files into your FrontPage web.

In both of the above methods, FrontPage will recognize the .mdb file extension of the Access database and prompt you to create a new connection for that database.  Go ahead and enter the database name and click “OK.”

You can then connect any form to that database using the methods described here.

Connecting Your Form to an External Database

You might find yourself in a situation where your database is hosted outside of your Web site.  Because of the power of the Internet and the ease of use offered by FrontPage 2003, you can connect to any database on the Internet from your Web as long as it is available on the Web and is ODBC compliant.

Before you connect to the database, you will need to determine the server name and passwords required to access your database.  The person in charge of the database will be able to provide you with the information necessary to make a connection.  An example of when this approach might make sense is when your site becomes very popular and its requirements outgrow the capabilities that Access offers.  So you might ask your Web site hosting company to set up a SQL Server™ database for you to use to store your important Web data.  When they do this, they will supply you with the server name, user name, and password necessary to connect to it from your forms in FrontPage.

Once you have figured out the path, login and password to the external database, connecting is simple:

·         Right click inside the form boundary (the dotted line) on the Web page with the form you wish to connect to the external database.

·         Select “Form Properties”.  This will open up the “Form Properties” dialog box.

·         Select the “Send to database” radio button.

·         Click the “Options” button in the lower left-hand corner of the Form Properties dialog.  This will open the “Options for Saving Results to Database” dialog.

·         Click on “Database Results” tab.

·         Click the “Add Connection…” button.  The Database tab of the Web Settings Dialog box will open.  Click the “Add” button to open up the “New Database Connection” dialog box seen below.






·         Clicking the “Advanced” button on the “New Database Connection” dialog box will open the “Advanced Connection Properties” dialog box (seen below).  Enter the Username and Password given to you by the database administrator and enter any additional parameters required through the dialog box interface.



Sending Form Results Via Email or to a Text File

If you don’t have or need database connectivity, you can send the information from your form to an email address or to a text file on your Web site.  An article on this process can be found online on the FrontPage 2003 Article entitled, “Collecting Sales Leads Online with Microsoft FrontPage 2003.”  The URL for this article is: http://office.microsoft.com/assistance/2000/fpSalesLeads.aspx.

Once You Are Connected

Congratulations!  You now know how to add a feedback form to your Web, save it as an ASP file, and configure the form to send the data it collects to a database that FrontPage 2003 either created or set up the connection for.  You can use these same steps to send the data collected by any form in a FrontPage Web to a database.

Inserting Database Results with the Database Results Wizard

At this point, you now have a database at your site able to receive user input.  This might satisfy your needs.  If not, you probably are looking for a way to present database information in your Web site.  In this section, you will learn how to use FrontPage to display the results of a database table in your browser.

Displaying form results is a little more detailed than sending form results to a database, but is still accomplished quickly and easily using the FrontPage 2003 interface.

To insert database results into your Web site using the Database Results Wizard, select Insert | Database | Results into the page you wish to add the results to.  Remember that all pages that interact with a database will need to be saved with the .ASP extension.

Step 1: Selecting the Database

The first obvious option you are given is to select the database you would like to get the results from.  The dialog box offers three choices.

The first choice is to connect to Northwind, the sample database provided by FrontPage.  Use this feature if you wish to experiment with database results without having to worry about database creation.

The second option is to use an existing database connection.  FrontPage 2003 remembers all of the database connections you’ve ever worked with in the Web site you are editing.  Your choice is probably in the drop down menu.  If this is the case, pick the database you want to connect to and select the Next button.

The final choice requires you to set up a connection that previously didn’t exist.  If you select that option and push the Create button, you will be given access to the Database tab of the Web settings dialog box.  From here, pushing the Add button will open the New Database Connection dialog box (pictured below) that will let you set up a connection to either a File or folder in the current Web, a System data source on web server, a network connection to database server or a custom definition.  Select the options suited for the task and your connection is established.





Step 2: Record Source

Because databases can contain great amounts of information, it is important to choose which parts of the database information you would like to display.  The second step asks for the Record Source, which is the table you’ll be pulling your data from.

If you built the database from FrontPage 2003, you will only have one choice.  If you are connected to a database with multiple tables, you will need to choose the one you wish to connect to.

Another option here is to create a custom query. If you know SQL (the Structured Query Language – not to be confused with SQL Server, the popular Microsoft Database Product) you can enter the appropriate SQL code and choose exactly what you want to view.  Information about Microsoft SQL Server and the SQL language can be found online at http://www.microsoft.com/sql/ .



Step 3: Selecting Fields

Once you have selected the Record Source (table) you wish to get your information from, it is time to choose the fields that you wish displayed in your Web page.  If you want to show all of the fields, select the next button.  If you wish to show the information in only certain fields, simply select the Edit List button and choose accordingly as seen below.



You will notice that there is a More Options button in the Step 3 dialog box.  This button will take you to another dialog box enabling you to choose more specific criteria for ordering for the data.  As seen in the screen below, you can both set up a filter to match specific criteria as well as set the ordering structure for the results.



Step 4: Formatting

Now that you know the database, table and fields you wish to show, the goal now is to determine how you would like to display the data.  The Database Wizard gives you the capability to either present your data in a Table or Column option.

The three check boxes in step 4 enable you to decide if you want to use a table border, expand the table to the width of the page and include a header row with the column labels.

Step 5: Grouping the Results

Finally it is a simple choice of grouping your results.  Results generated form databases can be long and overwhelming.  Luckily, FrontPage 2003 has a solution for that issue as well.  Step 5 gives you the opportunity to split the results into a fixed number of records per page.  The default is 5 records, but the choice is yours to make.

That’s It

Once you’ve gone through these five simple steps, the appropriate ASP code is written and your Web site reports accordingly.  You need to save your page as an ASP page (filename.asp).  You can view the Web pages from any browser, and every time your page is visited, an updated snapshot of the database contents is presented on the page.  You have integrated a database results with your FrontPage 2003 Web site.



Summary

The new database integration features found in FrontPage 2003 give you both the power to integrate database content into your Web site as well as program dynamic content to your site without spending weeks in a database class or learning complicated programming skills.  If you need to implement a complete database solution into your Web site, the new Database Interface Wizard can help you do just that.  If you need to implement elements of a previously existing database into your Web site, the tools provided by FrontPage 2003 can help you to do that as well.

You have taken the first steps towards moving from the position of a developer of static Web sites to that of an interactive programmer, all without having to know programming.  

Now that you understand database connectivity options and how they integrate easily and simply with FrontPage 2003, consider the options available to you:  You can publish an interactive address book for members of a club you belong to, you can enable your potential customers to populate your contacts database without you having to enter a thing, you can make inventory information made available online or create the first part of an e-commerce engine that takes orders directly from the customer.  You can also set up an entire Web-based database management solution without ever having to purchase a single database product.

Databases are exciting.  The power provided by FrontPage 2003 makes database integration simple.  The possibilities are endless, and they are yours to explore.











fpdb/index.mdb

connection of database in frontpage

https://espace.cern.ch/webservices-help/WebAuthoring/DynamicWebContent/Pages/DBConnectivity.aspx
==================
http://office.microsoft.com/en-us/frontpage-help/creating-hyperlinks-with-drag-and-drop-book-excerpt-HA001187172.aspx

===================
http://office.microsoft.com/en-us/frontpage-help/creating-hyperlinks-with-drag-and-drop-book-excerpt-HA001187172.aspx

connectivity in dreamwever

In this article,  we learn, how to create DSN Connection in Dreamweaver.
Step.1
The first step in this is to create a system DSN. To create DSN you have to go to (Windows)

system’s control panel and then you have to go to “Administrative Tools” then “Data Sources

(ODBC)” then go to the “System DSN” TAB.

  Then click ADD button and then choose the driver (Driver Do Microsoft Access) then click

finish. Now give a name for your DSN and then browse and select the “*.mdb” file (database

file) you want to use as the database to which the particular DSN name has to connect.
You need to define the DSN by clicking Define button on the DSN wizard window that appears

when you click to add “Data Source Name(DSN)” in Dreamweaver.
(If your new DSN does not appear in the list items, open the “Data Source Name(DSN)” wizard

once again from the database tab from the Application panel. you can find your new dsn

appearing in the list. (Forget not to define your DSN in the System DSN tab).
Step2.
Now, we need to link the newly created DSN in dreamweaver for our application devlopment.

For this, go to “Application” Panel and choose the Database tab. Click PLUS icon and choose

“Data Source Name (DSN)“.Select the “using Local DSN” Radio button. choose from the list of

System DSNs available on your system ( in this list you can find your newly defined DSN

too) then give a name for that connection. Now click “Test” (if there is password fill it

and the username).
If the DSN is connected Successfully, we get the message saying “Connection was made

Successfully“. Now you can make use of this DSN and create applications.
If the Test is not Success, it means there are some errors. We need to cross review each

steps we’ve done.
Learn how to create a DSN-less database connection in dreamweaver

Database setup

firstly create database
http://www.youtube.com/watch?v=aKCXrGBnWC4&feature=related

for creating recordset

when we want to do connect data from datafield then we create dataset


bedore we create a table we need to create a recordset
for creating recordset
http://www.youtube.com/watch?v=VL-i6Otza2U&feature=related

for creating table

http://www.youtube.com/watch?v=VjNXsbf2eCo

create database on frontpage

Introduction

It is relatively simple to create a form, but where do you store the input? If you use a database, data can be retrieved for later calculation, tracking, and presentation as required interactively. Microsoft® FrontPage® offers multiple options to integrate a database in a Web site, including Microsoft ActiveX® Data Objects and the Database Interface Wizard. This article will provide intermediate ASP options you can use in a FrontPage Web site for easy database integration.

Dynamic Web pages let you retrieve current information, store data, or access people online—and they do so through the use of databases. Databases collect and store so many different types of information on the Web that the value they offer is often taken for granted. But how do you learn to use a database with a Web page?

Through the development of Active Server Pages (ASP) and the easy-to-use database wizards in Microsoft Access, Microsoft offers a set of tools that developers can quickly pick up to start creating their own dynamic data pages. Using the FrontPage 2002 Web site creation and management tool, an ASP developer can create an entirely new database from within FrontPage, use an existing database connection, or experiment with a sample database—all from a page template called the Database Interface Wizard. Although the Database Interface Wizard functionality will not be discussed in this article, see Resource Links at the end of the article for information about how to use the wizard.

This article will discuss ASP database integration options using Microsoft Visual Basic® Scripting Edition (VBScript), ActiveX Data Objects (ADO) methods to pull information from a database, and an example of how to display records from a database in Hypertext Markup Language (HTML) format. If you are working in the HTML view of FrontPage, using code from this article also will allow you to connect to a database and display data from it in your FrontPage ASP template.

A Little ASP, Logic, and SQL

Using Visual Basic Scripting Edition to handle your data means that the Web page does not have to be static. When you use VBScript logic to make a database connection, retrieve data, and display it in the Web page, this processing or load is transferred to the Web server. Because you are reducing load time and not using the Web browser, you gain interactivity while not sacrificing Web page speed.

When you are dealing with data in an ASP page, the logic behind VBScript saves data in a transient format, so that data manipulation may be performed (if necessary), before data is saved to a database. One of the easiest ways to connect to a database can now be done with an OLE DB connection. OLE DB sits between the Open Database Connectivity Layer (ODBC) layer and the application. With your ASP pages, ADO is the "application" that sits above OLE DB.

Note   The ADO concept, and its available methods, are discussed further when we are ready to write our database connection code. If any data manipulation needs to occur before data is stored in the database, VBScript logic can change the data accordingly before it reaches the database. For example, if someone submits a phone number through a form with dashes in it and phone numbers in your database do not contain dashes, VBScript logic can remove phone number dashes before saving that data to the database.
In an ASP environment, VBScript is not the only component used to get your data into the database. You also must use a simple database language called Structured Query Language (SQL). SQL is widely accepted by databases to understand how a developer wants to insert data or select data from a database. Here is an example of a SQL command (or statement) used to retrieve data from a Contacts table:

["SELECT * FROM Contacts"]

In ASP, SQL statements are formed a little differently. They are called after the ASP page has set up variables for the database connection and after the correct OLE DB drivers are in place for connecting to a database. Here is the same SQL example from above, as you would need to write it in VBScript in your ASP Web page:

[strSQL = "SELECT * FROM Contacts"]

As you can see, the SQL statement has been referenced with an ASP variable, instead of merely stated by itself. Using variables in VBScript allows a developer to reuse the values of prior commands to produce further results and allow programming code to be processed faster. Variables like the example above are considered objects, and using these and other objects makes ASP programming very powerful.

ActiveX Data Objects offer consistent, high-performance access to data you want to display in a Web page. ADO is now the only data interface tool you need to know for creating data access in your Web. Not only can you use ADO with VBScript, but it also works with other languages like Visual Basic, C++, and Microsoft Visual J++®.

This article will use two ADO method examples: Open and Close.

Setting Up a Template Layout

Before we begin coding, it's important to set up a template layout for data access. You can copy and reuse this layout as needed for other applications. Our template contains places to notate code version, author, date last modified and comments about the purpose and intent of the template itself (for example, "This template is to access data and display it in a tabular format"). Using a template layout for each ASP page you create is a good way to stay organized.

In FrontPage, create a new Web page and name it Index.asp. If you want to cut and paste the layout code below, make sure you are in the HTML view of your new Web page, in order to preserve page comments and database integration features.

Here is a template layout example:

<%@ LANGUAGE="VBScript" %>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<html>
<head>
<%
'Option Explicit
'--------------- WEB SITE: YOUR WEB SITE NAME ----------------
' File Name: index.asp
'
' Purpose: Demonstrate database access and Record Set Display
'
' Accesses Company Information in a table layout
'
' Arguments:
' Comments:
'
' Author: Mary Burk
'     Mess Enterprises
'     http://www.mess.net
'     Internet: mary@mess.net
'
' Date Created:
' 02/09/03
'
' Modification History:
'
'----------------------------------------------------------------------
'
'----------------------------------------------------------------------
' All your ASP preprocessing code goes here
'----------------------------------------------------------------------
'
'----------------------------------------------------------------------
<html>
<body>
</body>
</html>
'----------------------------------------------------------------------
' End HTML output
'----------------------------------------------------------------------
'
'----------------------------------------------------------------------
' All ASP post-processing code goes here, as well as sub routines and
  ' functions, if any are required.
'
'----------------------------------------------------------------------

Now we are ready to explore ADO methods and OLE DB examples to connect to our database.

Accessing Data Objects

Inside our Index.asp template, we need to declare a few variables, choose the proper OLE provider for the database we are connecting to, and then provide the path to where the database resides on our server. An OLE DB connection is also known as a "DSN-less" connection. This new code provides developers a way to specify the database they want to connect to without having to define a specific Data Source Name (this used to be required from a .dsn file that specified Data Source Names) It is no longer necessary to specify a Data Source Name or DSN. Instead, developers can simply specify the correct database program provider and the path to the database with an OLE DB connection string.

Here is what you need to declare as variables:

dim objConn     ' Our Connection Object
dim objRS       ' Our Recordset Object
dim strSQL      ' Our SQL string to access the database
dim strConnection    ' Our Connection Object string to access the database
dim i            ' Our counter variable to count the rows of the Recordset

Here is what the Connection Object string and Recordset Object string should look like:

Set objConn = CreateObject("ADODB.Connection")
Set objRS = CreateObject("ADODB.Recordset")

Here is what a Connection Object string looks like to connect through OLE DB to an Access database. It uses the Open method (objConn.Open):

objConn.Open "Provider=Microsoft.Jet.OLEDB.4.0;" "Data Source="&
Server.MapPath("g:\Mess.mdb")

If you need to connect to a Microsoft SQL Server™ database, that connection string would look something like this:

objConn.ConnectionString = "Provider=SQLDB; Data Source=DatabaseSource;
  Initial Catalog=DatabaseName; User ID=UserID; Password=Password"
The Open method was demonstrated above. This Execute method is necessary to execute the SQL query we are making to the Access database:

<%
strSQL = "SELECT * FROM Contacts"
set objRS = objConn.Execute (strSQL)
if (objRS.BOF and objRS.EOF) then
   response.write "No records found"
   response.end
end if
%>

Other methods—such as AddNew for adding records to a database, Delete to delete database records, and Clear for removing Error objects—are discussed in further detail in documentation exploring OLE DB providers and the ADO API Reference set. This collection of examples and data access methods provides more examples for data access in additional languages. The reader is encouraged to try all the ADO connection method examples on this site and continue studying data manipulation methods available through ASP.

Displaying Results and Saving Data

Once we have established our data connection to the database, and checked to make sure our code will not return errors if no data is found, the last thing we need to do is write our data to a Web page using Visual Basic Scripting and HTML. The main snippet of HTML and VBScript we need to code into our FrontPage index.asp page is the loop structure. A loop will query the database repeatedly, until every record that satisfies our query is returned to the ASP page and displayed in our HTML table in successive table rows.

The trick to coding a Loop structure in a table is to write your HTML by rows. Your dynamic loop must run from <tr> to </tr>. If you write your loop code statement to only create new cells in your table (and not new rows), that is, if you only have your loop create new <td></td> tags, you will produce a loop in only one row. This construction of your loop could possibly grow the width of your table quite long, and make your table appear improperly formatted.

Here is how to structure your loop row to receive back all rows of data from the Access Contacts table:

<table border="1" cellpadding="2" cellspacing="1" width="400">
<%
response.write "<TR BGCOLOR='#CCCCCC'>"
For i = 0 to objRS.Fields.Count - 1
response.write "<TD>" & objRS.Fields(i).Name & "</TD>"
Next
response.write "</TR>"
strSQL = "SELECT * FROM Contacts"
set objRS = objConn.Execute (strSQL)
objRS.MoveFirst
Do While Not objRS.EOF
response.write "<TR>"
For i = 0 to objRS.Fields.Count - 1
response.write "<TD>" & objRS.Fields(i) & "</TD>"
Next
response.write "</TR>"
objRS.MoveNext
Loop
%>
</table>

Remember to query your database recordset, and close your database connection using the ADO Close method. Why is that important? One reason a good developer wants to do this is to save computer resources. Database connections that are not closed when they finish executing can disrupt other page loads in your site. There also can be a negative effect on the database if other programs are not able to access the database because it is still open somewhere else. Open database connections can even crash your entire Web site, if left open and running too long.

At this point in the index.asp page example, it is important to query the record set again and invoke the ADO Close method object. Here is how to do it:

<%
strConnectionString="Provider=Microsoft.Jet.OLEDB.4.0;Data
  Source=G:\Mess.mdb"
Set objConn=Server.CreateObject("ADODB.Connection")
objConn.Open strConnectionString
objConn.Close
set objConn = Nothing
objRS.Close
set objRS = Nothing
%>

Beyond closing out html and body tags, that's it. If you have continued to work in the HTML view in FrontPage and copied this example into your editor, you now will be able to query an Access Contacts database on your computer or Web server.

This code connects to the Mess Company database when run on the Mess Enterprises ASP-enabled Web server, loops through all company contacts, and displays them in a looped table layout. Every page request rechecks the database for added or deleted entries, and only displays current information from the database in the ASP page.

Looking Ahead

This article has provided one example of data interactivity in ASP. There are numerous ways to make your Web site more interactive using a database. And there are powerful database tools you can use to gain performance time and reduce the lines of code you have to write when creating Web database pages and applications. Two advanced examples of database power are stored procedures and triggers. Let's have a quick preview.

Stored procedures are frequently used to keep a set of complicated SQL queries in one place. Developers have found that maintaining their VBScript code separately from their SQL code, which does not change as often, allows for faster code changes during development. Stored procedures are stored in the database and accessed through ASP with @ symbols. The @ symbol is the programmatic way to pass parameters to a stored procedure when the set SQL contained in a stored procedure is not all you want to execute.

Triggers are database events that happen only when certain events are executed in a database, and they are an easy way to track changes made to a database. For example, you might want to use triggers to see what hour of the day people visit the site and modify personal information. You can also use triggers to evaluate what time of day records are added or deleted from a database as well. Triggers usually track their information in separate tables from changed data fields, so that a full version history of changes made to data in the main database is available and clear. Triggers also reside in the database and are created through complex SQL statements made against the database itself.

Dear Sir,
         
            I am Ms. Manisha Malviya, Marketing executive of Careers in Airline.
 I am looking for business from Airlines of Canada.


Manisha Malviya
Site  : www.careersinairline.com
Email : manisham.aerosoft@gmail.com
Mo.   : 9406937379

synopsis of courses of airline

Travel consulting and Airlines Reservations Course
http://www.careersinairline.com/tcaarc/
=============================
Airline and Airport Management
http://www.careersinairline.com/aaam/
=============

Airline Flight Dispatcher Courses
http://www.careersinairline.com/afdc/
=======================
 Type Rating Training Courses for Airline
http://www.careersinairline.com/trtc/
====================
List of MBA colleges having airline management courses in south ..
http://www.careersinairline.com/lmcha/

=====================

Airline Training Course

http://www.careersinairline.com/airlinetrainingcourse/

==============

Pilot Training Courses

http://www.careersinairline.com/pilottrainingcourses/

=======================

Air Ticketing Course

http://www.careersinairline.com/airticketingcourse/

=====================

 Travel Agent and Air Ticketing Courses

http://www.careersinairline.com/travelagentandairticketingcourses/

==================

Pilot Training Aviation Courses

http://www.careersinairline.com/pilottrainingaviationcourses/

=================

Airline Pilot Interview Preparation Course

http://www.careersinairline.com/apipc/

==================

Diploma in Airline Management from 

http://www.careersinairline.com/diam/

=============================

Distance Learning Courses in Airline and Airport Administration

http://www.careersinairline.com/dlcaaa/

==================

Airline Management courses

http://www.careersinairline.com/aam/

====================

Airline Customer Service Agent Courses

http://www.careersinairline.com/acsacc/

Travel Jobs

Airline Industry Occupations: Flight attendant is not the only job title for this vast industry. Jobs range from travel agents to aircraft pilots, flight engineers to cargo and freight agents.

Education: Trade school certification is required for many of the jobs; a bachelor's degree and graduate degree as well as flight time and training could also be required.

Scope: Opportunities for aircraft and avionics equipment mechanics and service technicians should be excellent for those who have completed a training program. Reservation and transportation ticket agents and travel clerks held about 163,000 jobs in 2004. About six out of 10 are employed by airlines. Others work for automobile clubs, hotels, railroad companies, etc.

Airline pilots and flight attendants are celebrities of the airline industry, but two-thirds of all airline jobs are actually on the ground. Even though airline jobs are projected to grow 9% through 2014, expect fluctuations based on vacation trends. Where are the best airline jobs? Regional and no-frills airline jobs should be the top of your list.

Jobs in Airports

Company Jobs(249)
Consultant Jobs(142)

==================
Hotels/ Restaurants/ Airlines/Travel(291)
Aviation/ Aerospace Firms(64)
Other(11)
Courier/ Transportation/ Freight(4)
IT-Software/ Software Services(4)
Auto/Auto Ancillary(3)
BPO/ITES(3)
Construction/ Engineering/ Cement/Metals(2)
Education/ Teaching/ Training(2)
Shipping/ Marine(2)

==============
Ticketing / Travel / Documentation
Reservations Exec.(80)
Travel Agent(52)
Operations Mgr(51)
Tour Mngmt Exec.(48)
Operations Exec.(35)
BD Mgr(23)
Tour Mgmt Mgr / Sr. Mgr(22)
Airline
Cabin Crew(17)
Ground Staff(14)
Other
Fresher(10)

jobs in airline

obs in airline
Jobs in Airports - Airports in India are Hiring
Travel Jobs - Airlines Jobs
Kingfisher Airlines – Jobs in Fly Kingfisher India
SpiceJet Careers | Work with SpiceJet
Airline People - Staff, Jobs, Careers
Airline careers | Airlines Training | Cabin Crew jobs
Hotel Jobs, Hospitality Jobs, Hotel Careers, Cruise Ship Jobs, BPO
Ticketing-reservation Jobs In India |
Jobs in India - Airline, Travel, Tourism, Shipping, Crew, Hostess
Airline Pilots jobs in India, India
Airline Jobs, Recruitment in Gujarat
Airline Ticket Agent Jobs in Gurgaon
Careers in Airline | Cabin Crew jobs | Airlines Training .


======================

keywords
jobs in airline industry
jobs flight attendant
jobs flight crew
hr jobs in airlines