Answer to Question #38159 in Action Script | Flash | Flex | ColdFusion for Anita

Question

You can use anything you want to complete this. I recommend http://help.adobe.com/en_US/ColdFusion/9.0/CFMLRef/index.html as it is the offical documentation on the language.

PROJECT:

Create a query set from scratch that holds five city names, the state the city is located in and a telephone area code from this city.

Example:
row1: 'dallas', 'tx', '214'
row2: 'fort worth', 'tx', '817'
row3: 'san antonio', 'tx', '210'
row4: 'L.A.', 'ca', '213'
row5: 'Austin', 'tx', '512'


This can be accomplished by building the query set from scratch or by making a csv and calling it in. Look up the Query functions in coldfusion live documentation.
OR
To use a csv look up the cffile and cfquery tags in coldfusion documentation and google how to use them together to query a csv file.


Once you have built the query set run a query against it to retrieve the results. Add the data into a two diminsional array. Example of the array:

CityInfo[1][1] = 'dallas'
CityInfo[1][2] = 'tx'
CityInfo[1][3] = '214'
CityInfo[2][1] = 'fort

Answer 1

Dear customer,
Unfortunately, your question requires a lot of work and cannot be done for free.
Please submit it with all requirements as an assignment to our control panel and
we'll assist you.