=http://www.w3schools.com/PHP/php_mysql_connect.asp
Thursday, May 26, 2011
Thursday, May 19, 2011
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
Tuesday, May 17, 2011
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
bedore we create a table we need to create a recordset
for creating recordset
http://www.youtube.com/watch?v=VL-i6Otza2U&feature=related
Monday, May 16, 2011
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.
Sunday, May 15, 2011
Sunday, May 8, 2011
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/
Thursday, May 5, 2011
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)
Sunday, May 1, 2011
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
Saturday, April 30, 2011
courses
Airline Training Course
Pilot Training Courses
Air Ticketing Course
SimpliFlying-led 3-day IATA courses on airline social media ...
Airline Flight Dispatcher Courses
Travel Agent and Air Ticketing Courses
Type Rating Training Courses for Airline ...
Pilot Training Aviation Courses
Airline Pilot Interview Preparation Course
Diploma in Airline Management from IHCTM
Airline Management courses
Distance Learning Courses in Airline and Airport Administration
Travel consulting and Airlines Reservations Course
Airline and Airport Management
List of MBA colleges having airline management courses in south ...
Airline Customer Service Agent Courses
Tuesday, April 5, 2011
Best Answer - Chosen by Voters
What browser are you using? I'll give the instructions for the most common ones;
Internet Explorer 5,6, &7:
1. Start Internet Explorer.
2. On the Tools menu, click Internet Options.
3. Click the General tab.
4. In the Address box, type http://www.facebook.com
NOTE: If you want the page that you are currently viewing in Internet Explorer to be your home page, click Use Current.
5. Click OK.
In firefox:
Click on TOOLS on the menu bar at the top of the Firefox screen, then click on OPTIONS
After clicking options you will see the Firefox Options dialogue box.
Type the address of the webpage that you would like to use as your new homepage into the box providedand click the OK button.
If it is the webpage you are currently viewing just click the Use Current Page button then simply click on the OK button.
Internet Explorer 5,6, &7:
1. Start Internet Explorer.
2. On the Tools menu, click Internet Options.
3. Click the General tab.
4. In the Address box, type http://www.facebook.com
NOTE: If you want the page that you are currently viewing in Internet Explorer to be your home page, click Use Current.
5. Click OK.
In firefox:
Click on TOOLS on the menu bar at the top of the Firefox screen, then click on OPTIONS
After clicking options you will see the Firefox Options dialogue box.
Type the address of the webpage that you would like to use as your new homepage into the box providedand click the OK button.
If it is the webpage you are currently viewing just click the Use Current Page button then simply click on the OK button.
Monday, April 4, 2011
links
Home
http://www.careerinairline.com/home/
==================
Career Jobs
http://www.careerinairline.com/careerjobs/
=====================
Resources
http://www.careerinairline.com/resources/
=================
Resume
http://www.careerinairline.com/resume/
===========
FAQ
http://www.careerinairline.com/faq/
===========
Blog
http://www.careerinairline.com/blog/
==========
About
http://www.careerinairline.com/about/
==========
Contact
http://www.careerinairline.com/contact/
links
Home
http://www.careerinairline.com/home/
==================
Career Jobs
http://www.careerinairline.com/careerjobs/
=====================
Resources
http://www.careerinairline.com/resources/
=================
Resume
http://www.careerinairline.com/resume/
===========
FAQ
http://www.careerinairline.com/faq/
===========
Blog
http://www.careerinairline.com/blog/
==========
About
http://www.careerinairline.com/about/
==========
Contact
http://www.careerinairline.com/contact/
Monday, March 28, 2011
http://www.facebook.com/careersinairline
================
http://twitter.com/careersinairline
=================
wordpress
http://wordpress.com/careersinairline
===============
http://www.linkedin.com/careersinairline
===========================
orkut
http://www.orkut.co.in/careersinairline
======================
myspace
http://www.myspace.com/careersinairline
Synopsis for Career in Airlines
Air travel remains a large and growing industry. It facilitates economic growth, world trade, international investment and tourism and is therefore central to the globalization taking place in many other industries.
In the past decade, air travel has grown by 7% per year. Travel for both business and leisure purposes grew strongly worldwide. Scheduled airlines carried 1.5 billion passengers last year. In the leisure market, the availability of large aircraft such as the Boeing 747 made it convenient and affordable for people to travel further to new and exotic destinations. Governments in developing countries realized the benefits of tourism to their national economies and spurred the development of resorts and infrastructure to lure tourists from the prosperous countries in Western Europe and North America. As the economies of developing countries grow, their own citizens are already becoming the new international tourists of the future.
Business travel has also grown as companies become increasingly international in terms of their investments, their supply and production chains and their customers. The rapid growth of world trade in goods and services and international direct investment have also contributed to growth in business travel.
Worldwide, IATA, International Air Transport Association, forecasts international air travel to grow by an average 6.6% a year to the end of the decade and over 5% a year from 2000 to 2010. These rates are similar to those of the past ten years. In Europe and North America, where the air travel market is already highly developed, slower growth of 4%-6% is expected. The most dynamic growth is centered on the Asia/Pacific region, where fast-growing trade and investment are coupled with rising domestic prosperity. Air travel for the region has been rising by up to 9% a year and is forecast to continue to grow rapidly, although the Asian financial crisis in 1997 and 1998 will put the brakes on growth for a year or two. In terms of total passenger trips, however, the main air travel markets of the future will continue to be in and between Europe, North America and Asia.
========================
Here is what we think this website is worth:
$708
=================
http://www.facebook.com/login.php?api_key=d99ed27ef90d771f21cf34e60931620d&v=1.0&next=http%3A%2F%2Fsikkertrafikfb.wemind.dk%2Fstories_list.php&canvas=1
================
http://twitter.com/
=================
Sunday, March 27, 2011
who is information
WHOIS information for careerinairline.com : [Querying whois.verisign-grs.com] [Redirected to whois.PublicDomainRegistry.com] [Querying whois.PublicDomainRegistry.com] [whois.PublicDomainRegistry.com] Registration Service Provided By: SAHAJ INFOTECH Contact: +91.7312541367 Domain Name: CAREERINAIRLINE.COM Registrant: AeroSoft Corp AeroSoft Corp (aerosoftcorp@gmail.com) 301 Royal Regency Airport Road Indore Madhya Pradesh,452005 IN Tel. +91.7312621309 Creation Date: 13-Aug-2008 Expiration Date: 13-Aug-2011 Domain servers in listed order: dns7.sahajinfotech.com dns8.sahajinfotech.com Administrative Contact: AeroSoft Corp AeroSoft Corp (aerosoftcorp@gmail.com) 301 Royal Regency Airport Road Indore Madhya Pradesh,452005 IN Tel. +91.7312621309 Technical Contact: AeroSoft Corp AeroSoft Corp (aerosoftcorp@gmail.com) 301 Royal Regency Airport Road Indore Madhya Pradesh,452005 IN Tel. +91.7312621309 Billing Contact: AeroSoft Corp AeroSoft Corp (aerosoftcorp@gmail.com) 301 Royal Regency Airport Road Indore Madhya Pradesh,452005 IN Tel. +91.7312621309 Status:ACTIVE The data in this whois database is provided to you for information purposes only, that is, to assist you in obtaining information about or related to a domain name registration record. We make this information available "as is", and do not guarantee its accuracy. By submitting a whois query, you agree that you will use this data only for lawful purposes and that, under no circumstances will you use this data to: (1) enable high volume, automated, electronic processes that stress or load this whois database system providing you this information; or (2) allow, enable, or otherwise support the transmission of mass unsolicited, commercial advertising or solicitations via direct mail, electronic mail, or by telephone. The compilation, repackaging, dissemination or other use of this data is expressly prohibited without prior written consent from us. The Registrar of record is Directi Internet Solutions Pvt. Ltd. d/b/a PublicDomainRegistry.com. We reserve the right to modify these terms at any time. By submitting this query, you agree to abide by these terms. |
Monday, March 21, 2011
Synopsis
Project Synopsis Format
Name :- Manisha Malviya
Roll No.:- 0822ca081021
Project Undertaken:- Capt. Shekhar Gupta
Estimated duration:- 01/02/2011 to 30/05/2011
Organization with address:- Aerosoft Corp.
108, Ambikapuri EXTN.
AIRPORT ROAD
INDORE-452005,INDIA
www.aerosoft.in
Nature of project :- B2B project on Wordpress.
Project description :- “CAREER IN AIRLINE“
Project is related to career in airline. The project namely “Career in Airline” is very user friendly software so that the new user can also use it. . Mainly the main aim of the project is to keep information of vacancies in different airlines & different categories of jobs.
Scope of the project: - It can be used by any airlines who want to share their vacancies and information. It is also used for job seeker who wants to make career in airlines.
Signature of student:-
Manisha Malviya
(0822ca081021)
Signature of project in charge:
Capt. Shekhar Gupta
Date: 21/03/2011
Neelima Sapre,
Reader
Department of Computer Applications
SVCE,Indore
Reader
Department of Computer Applications
SVCE,
Synopsis
Project Synopsis Format
Name :- Manisha Malviya
Roll No.:- 0822ca081021
Project Undertaken:- Capt. Shekhar Gupta
Estimated duration:- 01/02/2011 to 30/05/2011
Organization with address:- Aerosoft Corp.
108, Ambikapuri EXTN.
AIRPORT ROAD
INDORE-452005,INDIA
www.aerosoft.in
Nature of project :- B2B project on Wordpress.
Project description :- “CAREER IN AIRLINE“
Project is related to career in airline. The project namely “Career in Airline” is very user friendly software so that the new user can also use it. . Mainly the main aim of the project is to keep information of vacancies in different airlines & different categories of jobs.
Scope of the project: - It can be used by any airlines who want to share their vacancies and information. It is also used for job seeker who wants to make career in airlines.
Signature of student:-
Manisha Malviya
(0822ca081021)
Signature of project in charge:
Capt. Shekhar Gupta
Date: 21/03/2011
Neelima Sapre,
Reader
Department of Computer Applications
SVCE,Indore
Reader
Department of Computer Applications
SVCE,
Thursday, March 17, 2011
carrier jobs
carrer jobs
Flight Attendant Jobs
Now Featuring 55 airlines (many offering flight attendant jobs):
Air Canada, Air Wisconsin, AirTran, Alaska, Allegiant Air, American, American Eagle, Atlantic SE, British Airways, Cathay Pacific, Chautauqua, Colgan Air, Comair, CommutAir, Continental, Delta, Easyjet, Emirates, Etihad Airways, ExpressJet, Frontier, GoJet Airlines, Gulf Air, Hawaiian, Horizon, JetBlue, Mesa, Mesaba, Miami Air, Midwest, NetJets, North American, Northwest, Omni Air, Piedmont, Pinnacle, PSA, Qantas (UK), Qatar Airways, Republic, Ryan Int'l, Ryanair, Shuttle America, Singapore Airlines, Skywest, Southwest, Spirit, Sun Country, Trans States, United, US Airways, USA3000, Virgin America, Virgin Atlantic, WestJet, and World
10 Ways Becoming A Flight Attendant Changed My Life
by Marsha Marks
Relaxing in 4 star hotels, with drivers on call.
Prior to becoming a Flight Attendant, I had a good job in middle management, with a large US Corporation, with lots of travel. But, I never relaxed when I traveled. Instead I had to attend meetings, and every minute of the day was scheduled. Imagine, my surprise, when I realized -- as a Flight Attendant, once we get to the hotels – our time is our own. Rooms, transportation and food is all paid for, and we have pre-scheduled drivers who pick us up on time and get us back to the airport the next day! They even drive us to shopping if we want. When I settle into a 4 star hotel, now, I take a bubble bath, order room service, and read -- something I never have time to do at home! (And would never do, if I were not a Flight Attendant.)
Parties that only Flight Attendants are invited to.
Before I became a Flight Attendant, I was trying to meet Mr. Right, but couldn’t seem to find him among the dross that everyone had to sift through to find a true Gem. Then I became a Flight Attendant and on my first night of Flight Attendant Training, I was invited to a party, (happening the next weekend) for Fight Attendants and Aerospace Engineers. There I met the man of my dreams, educated, intelligent, gainfully employed and incredibly handsome, and oh so grateful to be meeting and dating a Flight Attendant. We were married a year and a half later!
Able to pursue my second career – with time and energy left over.
The whole time I was in the corporate world, I would get up at 6AM to get ready and drive an hour to my work, and then work 8 hours and drive an hour home. I was exhausted. I only got 2 or 3 weeks vacation a year! I had no time to pursue what I really wanted – writing the great American Novel. But, shortly after becoming a Flight Attendant, I found I had tons of days off every month. Lots of months, I only worked 9 days! So, I had time to pursue my “dream career” of being a writer. In 2002, I became the first Flight Attendant ever to sign a three-book deal with a division of the largest publisher in the world. Many of my fellow Flight attendants are Nurses, Lawyers, Teachers, and Real Estate professionals, - all career’s they can pursue, on their days off.
Meeting and networking with the rich and influential.
When my husband and I were trying to sell a condo in LA and living in Seattle, we flew down to LA to check on our property. Of course we flew Space Available. And of course, the space most often available was in First Class. So, we sat next to the rich and influential, and met people who asked us if we could use what they couldn’t…like box seats to pro-games they weren’t going to be able to attend. Tickets to the symphony, - they wouldn’t be able to make the night in question. And invitations to top “benefactor” parties, where we met Senators, and congressmen, and CEO’s. Believe me, this would not have happened, if I had never become a Flight Attendant.
Glamour.
I always thought I’d grow up to be Miss America. It would just happen, I thought by write In ballot. But, it turns out, you actually have to compete for these titles, and I never did. When I told all this to my fellow wing sister, she said, “If you can’t be Miss America, and you can’t be a model, then you become a Flight Attendant.” And the glamour is there by profession.
Instant membership in a most elite sorority.
My Wing Sister, Melanie, (who now is a real estate mogul) tells of the time she was engaged to a Physician. They attended an exclusive black tie dinner party. At the table when everyone was introduced, Melanie said she was a bit intimidated by other people’s titles and education…until they asked her what she did, and she said she was a Flight Attendant. The whole table turned to her and said FLIGHT ATTENDANT! And for the rest of the evening, she was the “star”. Becoming a Flight Attendant is like gaining an entrance to an elite sorority. A sorority which everyone is curious about!
The longer you work, the less you work.
How would you like to work 8 days a month and make a full-time salary? (Legally). Flight Attendants make more and work less, with each passing year. It's the nature of the business - all schedules and pay - are based on seniority. The more senior you are, the better trips you have and the better the pay.
My family flies free anytime anywhere – and my friends get buddy passes.
I don’t think I need to say anymore about the wonder of being able to offer my family and friends trips to Hawaii, or Rome or New York, First Class. It’s great – and certainly would never happen if I were not a Flight Attendant.
Education.
Where else could I actually get paid, to discover up close and personal, that the Mona Lisa is in fact, a quite small painting. Or see what the Cathedrals look like, in Rome. Or visit the North Pole at Christmas. Some education can best be learned, while on the job. The job of a flight attendant!
The heartfelt knowledge that each day, I can make someone’s life, a little happier.
People who travel are usually tired, and stressed. They board my flight looking for someone with a smile and a reassurance that all will be well, and this flight will be wonderful. I love making someone’s day simply by offering a pillow and a blanket, or a beverage with lots of ice. I love my job. And there is not another job that can so change someone’s life, like that of becoming a Flight Attendant
============================
A Day in the Life of a Flight Attendant
by David Silverstein
A day on the job. For a flight attendant that could mean...a trip to Paris...or an emergency landing. It can be fun, an adventure, or both...but is it work? I’ve found that working for a major airline this past year has been one of the hardest jobs I have ever had, and yet one of the most enjoyable. The schedule and the passengers challenge me in ways I never could have imagined. But nothing beats hanging out in Las Vegas for 24 hours with a company-paid hotel room and expense money. The thousands of us flying encounter many different experiences during the course of a day. This is a day (well, technically a trip) in my life...
5:45 P.M. Friday: The Assignment
In the airline industry, seniority rules. Mechanics, pilots, flight attendants, customer service agents--all of these employees enjoy pay rates, schedules and benefits based on their length of service with the company. Among flight attendants, seniority determines status as a lineholder or reserve. Lineholders have a flying schedule set at least one month in advance; they know when and where they will work and on what types of aircraft. The airlines use reserves to fill open flying time and to cover positions vacated by lineholders calling in sick or on holiday. If you are a relatively new flight attendant, like me, you can expect to sit reserve for a couple of years. Flight attendants often receive a set schedule (known as a block) after less than two years, but at some bases, flight attendants can sit reserve for more than ten years.
As a reserve flight attendant, my "work day" begins with a call from a crew scheduler. Each airline operates differently; at mine, schedulers call reserves on-duty to ask what trips they want to fly the following day. Trips are paid by the flight hour, from the time the aircraft door is shut to the time it is opened. And for every hour away from base, flight attendants are paid expense money. This particular Friday evening, when crew scheduling calls, I choose a four-day trip on the Airbus 319--one of our newer aircraft. It pays better than average and overnights in Raleigh-Durham, Washington, DC and Denver. Working what the airline labels the "C" position, I serve in the economy cabin and sit in the front, near the boarding door. With my trip set, I pack. I take a few extra pieces of my uniform and some clothes for the overnight. I go to bed early since I must check in early the next morning.
7:30 A.M. Saturday: Check-in
This morning, I go down to the crew room below the airport concourse in Philadelphia. Each base has a crew room complete with couches, computers and supervisors’ offices. Pilots and flight attendants also have boxes or folders there for company mail. Before starting a trip, a crewmember must check in for it. First things first, I use the computer to sign in for the trip. If you do not sign in an hour before the trip departs, you are liable to get written up by your supervisor. Since boarding begins 30 minutes prior to departure, there’s not much time to spend in the crew room, but I have a few minutes to check my box for memos and chat with friends. I head to the plane to meet up with the rest of the crew.
Communication between the cockpit and the cabin plays a vital role in maintaining a safe environment, and the crew briefings at the beginning of a trip set the tone. Once on the airplane, Becky, the lead flight attendant, briefs Mike and me on safety procedures, delegates announcement responsibilities and confirms that we have our emergency manuals. Afterward, the captain conducts his briefing, reviewing safety-related issues, flight time, weather, and what he likes to drink.
Ready, Set, Go: Inflight
About 30 minutes prior to departure, the agent working our flight comes down the jetway to begin boarding. Becky nods okay, and we finish checking our emergency equipment and catering supplies. From the forward galley, Becky and I greet the passengers and prepare drinks for first class customers. Mike hangs out in the back, monitoring the dwindling space in the overhead bins. Boarding tends to provide the biggest headache, especially considering I do not get paid until that door is shut. With a nearly full flight, it is pretty much guaranteed that space in the overhead bins will go quickly. Tensions mount, but bags need to be checked. Though the company no longer requires passenger counts, many pilots prefer to have them. When you see the flight attendant slowly coming up the aisle silently moving his or her lips, sometimes motioning his or her hands, that flight attendant is taking a count. As easy as it may seem, it often takes more than one count to get it right.
Once all the overhead bins are shut and the passengers are seated, the flight is ready for departure. I verify that the passengers seated in the window exit row are willing and able to assist in an emergency if necessary. Before shutting the door, the agent hands Becky a copy of the manifest, which lists first class passengers, passengers with special needs or meals, and gate connections. We arm the exits, enabling the slides to inflate if the doors are opened. After the safety video and a final cabin walk-through, the three of us strap into our jump seats and I practice my 30-second review, which includes evacuation commands and door operation procedures. It is still a thrill when we taxi onto the runway and the engines roar. You learn to recognize the strange (and initially scary) noises as just the lavatory toilet seat coming down or unused hangars banging in the closet.
Once we level-off at 10,000 ft, I head to the back and help Mike prepare for the breakfast service. To no one’s surprise, we serve the staple of the skies: omelettes and French toast. In the back galley, we brew coffee, cook the meals in the ovens and set up the carts. Since the beverage cart comes stocked with cans of sodas and juices, we just add a few things on top such as some cream and sugar for the coffee. Once the meals finish cooking, we begin serving from the front of the cabin to the back. It turns out we are short a few meals and have to ask the company employees traveling on the flight to go without a breakfast. I hate doing that, but they do not seem to mind. Space is undeniably tight on the beverage cart, and accidents are bound to happen. I am no exception on this leg, knocking a can of soda on a passenger as I reach for it. Not much spills, but he is still peeved. I give him a sorry form to get his pants dry-cleaned at the airline’s expense. Finishing the service, I settle in the back row with a book, assisting in the cabin as needed. Passengers occasionally bring cups and other trash back for me to dispose of as they head to the toilet, but the remainder of the long flight is a coffee break of sorts for us.
Service in first class is usually more involved. With 12 or fewer passengers on the smaller jets, it also tends to be more intimate. No carts are needed, and food and beverages are presented in china and glassware. Various types of people fly first class, but that cabin mostly fills up with business people and other frequent flyers. Celebrities occasionally make an appearance. A friend served Sissy Spacek once, and another flew with the members of the Red Hot Chili Peppers.
During the flight, a problem arises, which is relatively common on longer flights. Sitting in the back, I notice the smell of cigarette smoke coming from the lavatory. A passenger exits and it is obvious he has been smoking. There is no sign of the cigarette in the trash, but I advise him that smoking in the lavatory is a violation of a federal law and comes with a large fine. There are set procedures to deal with situations like these and paperwork to complete.
We cruise through the rest of the day with little problem, except when I smash Mike’s finger in the overhead bin as we both try to close it. He’s okay, though he is quick to point out the tiny white scratch on his fingernail. An extra flight attendant joins us in Denver for our next leg to Charlotte. She notices a pregnant woman sitting in the exit row, and the four of us discuss whether the passenger is qualified to do so. Since no regulation explicitly excludes pregnant women from those seats and the passenger insists she is both willing and able to assist in an emergency, we decide to let her stay there. The last leg of the day is the easiest. Since the airline needs us in Raleigh-Durham, but does not need us to work from Charlotte, we deadhead on another crew’s flight.
Gas, Food, Lodging: The Layover
We arrive in Raleigh-Durham at 8:00 P.M. I take Mike and Becky to the restaurant where I once waited tables. My old boss gives us dinner on the house, certainly a welcome treat on our first-year salary. We have an early start again the next morning and there is not a whole lot to do near the airport in Durham, so we don’t stay out late.
On an overnight, the airline provides each crewmember with his or her own hotel room. Long layovers (at least 15 hours off) land you at a decent hotel downtown, near the beach or some sort of shopping venue. For shorter layovers, you will usually stay at or very near the airport. My crew, both the pilots and the flight attendants, stay together the entire trip--layover and all. Some airlines work a little differently, putting flight attendants and pilots in separate hotels. The airline also covers meals, if you count the expense money paid for the trip.
12:40 P.M. Tuesday: Check-out
The next few days of the trip are surprisingly uneventful. The video system on the Airbus, sophisticated as it is with its automatic preprogramming, occasionally malfunctions. Threatened with having to do the safety demo the "old-fashioned way," we manage to play the video manually. At the end of day two, as the plane pulls off the runway at National Airport in D.C., I persuade Becky to spice up the arrival announcement. "Ladies and gentlemen, welcome to our nation’s capital," she says, instead of the scripted "Welcome to Washington, DC." I cannot tell if anyone notices. By the end of the fourth day, most of the giddiness has been replaced with exhaustion.
At the end of the last leg, we land in Philadelphia. The trip is now over. I am released from duty 15 minutes later. This rest period lasts at least eight hours and is guaranteed to be free from phone contact from schedulers. Leaving the airport, I head out to the employee parking lot, pick up my car and head home. Back in my room, I unload my bags and unplug the phone.
===============================
Graduating from college? The sky is the limit
by David Silverstein
Attention college seniors: I am the voice of your not-so-distant future. I was once where you are now, sweating and worrying about my future, forced to answer the never-ending question from family and friends: "What are you going to do when you graduate?"
The Onset of Panic
I can relate. But you do not want sympathy; you want advice. The best advice I can give you is to relax. You do not have to figure out the rest of your life in the next six months. You have a lifetime to sketch out those dreaded career goals. In the meantime, take a job you can enjoy: teach in an under-served school system, try your luck in Hollywood, work your way across the world, or do as I did, and take to the skies -- become a flight attendant.
Peace Corps Volunteer or Flight Attendant?
I joined the "real world" just over a year ago, after four unfocused years of college. The flexibility of my psychology major allowed me to explore my many interests, from Latin-American music to the social constructions of health. I studied abroad for a year, wrote for the college newspaper and conducted HIV education programs. By senior year, I was confused. I did not know what to do following graduation -- which of those diverse paths to pursue. My senior year I took the minimum course load (12 hours in the Fall and an awesome 8 hours in the Spring) in order to devote most of my time and energy to the job search. I spent most of those days in the library, glued to a computer screen, combing through every imaginable online job listing. There were jobs I wanted that I never could have gotten and jobs I could have gotten but never wanted. Graduation day loomed, and I was freaking out.
All was not lost, though. I had two very real possibilities. The Peace Corps was a definite interest. I could experience some far-away place and contribute to the betterment of the world. The other idea emerged from my closet obsession with air travel, which I finally managed to do something about. Along with the Peace Corps, I applied for a flight attendant position. I know…it seems strange to mention being a Peace Corps volunteer and a flight attendant in the same breath. But both captured my overwhelming love of travel. It was not an easy decision, but in the end, I decided to put the Peace Corps on hold and take the job as a flight attendant. It was time to have some fun and fulfill an old dream.
Is It Right For Me?
You would not be reading this article if you weren’t at least mildly interested in an airline career. But how do you know if it is right for you? I have friends who often get frustrated with their 9 to 5 office jobs and toss around the idea of joining me. After we get past the benefits (which are fantastic) and get into the actual work, their interest sometimes waivers. It is a demanding job, and it takes more than a "people person" to solve crises - both large and small - in such tight quarters and with very limited resources. You must possess good self-esteem and the sense not to take everything to heart cranky passengers and crewmembers throw at you. You have to be able to work strange hours, including nights, weekends and holidays. But of course, there are many advantages: you do not have to go to work every weekday from 9 to 5, you typically get more time off than at a typical job, and you very rarely see any kind of a supervisor or boss. Plus, working holidays may mean having a hotel room in Times Square on New Year’s Eve!
Landing A Flight Attendant Job Is Difficult
Landing a job at one of the major airlines is very tricky since the number of applicants far outweighs the number of positions. There is good news though: most airlines are growing and hiring more flight attendants than ever. And a college degree does carry weight. While no carrier I know of requires an applicant to have a degree, many of the flight attendants I know have undergraduate degrees. A few have even pursued advanced degrees while continuing to fly.
Some airlines actually recruit on campus, though many conduct open interview sessions around the country. Consider applying if you’ve harbored that steward/ess dream since your first plane ride, or if the job sounds fun and you do not know what else you’d like to do. If you are headed to grad school but want a break or need to save some money, think about deferring. Airlines do not require minimum commitments; you can fly for a month, a year, or 30 years. If you only want to fly temporarily or decide it is not for you, no problem. You are not locked in. JFK-based JetBlue even designed a limited one-year program with recent grads in mind.
As I mentioned earlier, competition for these jobs is intense, and I recommend checking out AirlineCareer.com's online resource (forgive me for sounding like an advertisement). This will give you the best opportunity to get hired. Of course, you could just wing it, but I can almost guarantee you won't get hired without some assistance.
Why It's All Worth It
The benefits that come with an airline job cannot be beat, especially for those of us just starting to make our way in the world. Considering the work involved, the pay is decent. But it is the free travel that lures many into the industry. No matter how long you’ve worked for an airline, it is undeniably cool to be able to hop on a plane and go anywhere on a day off. This past year alone, I spent Thanksgiving in London and New Year’s in Frankfurt. For fun, I vacationed in Thailand. "What are you going to do when you graduate?"
==========================
Subscribe to:
Posts (Atom)