My first break

http://www.southeastcdc.org.sg/1236595782298.html

Students who are eligible for consideration for this Award are those whose family’s total household income is not greater than S$3,000 per month and who have not personally traveled beyond Malaysia, Batam or Bintan over the last 3 years. (NB : students who have gone on an overseas trip with the college/secondary schools, ie. not personal holiday, qualify for this programme).

IFA Project

3-5 pages of write up consisting of

1) Project Specifications (Functionality, introduction, etc)

2) Market Research (Survey of Market Needs)

3) Site Map


Project minimum functionality

• Main page, The main page will include a link to login page and registration page.
• A login page
• A registration page
• Product Category page allow user to view all the products available in the web page after the user login.
• Product Detail page.
• Shopping Cart page,
• Check Out Page

IFA

1. Browse to www.sawmac.com/dw8/.

2. Go to tutorial page and download chapters 20-24:Dynamic Dreamweaver Tutorials

3. Unzip the file and move the nationalEx_root folder to c:\inetpub\wwwroot

Creating Site

1. Choose Site->New Site

2. Use Basic Tab

3. Type Exasperator Store in the first box and http://www.nationalExasperator.com

4. Click Next

5. Select server technology and ASP VBScript

6. Select Edit and test locally

7. Click the folder and select the nationalEx_root that you had copied to wwwroot earlier

8. Type the URL and Test

9. Click Next

10. Click No and Next followed by Done


Creating Dynamic Page at site (results.asp)

1. Open databases panel by choosing window->databases

2. Click the + sign at top right panel, choose connection string

3. In the connection Name box, type connNationalEx.

4. In the connection String box, type Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\nationalEx.mdb

5. Make sure Using driver on this machine is selected and Test

Creating Recordsets with Search function (results.asp)

1. In Name field, type rsProducts

2. Connection select the connection made earlier on

3. Choose Products table

4. Select Product Name, description and price

5. Select Filter -> prodPrice

6. Choose <>select Form Variable and key in prodPrice

8. Sort by Price


9. Create table and repeat region and drag the appropriate records to the appropriate columns

Creating a search page (search.asp)
1. Create a form
2. In the form include a menu and submit button
3. Action property of form to set as Post and point to results.asp created earlier on.
4. Name the menu as prodPrice and make sure values are keyed in. e.g below

5. Test the search page

Reading for IFA

Beginning Database:

http://www.adobe.com/devnet/dreamweaver/articles/beginners_databases.html

Creating Dynamic website

http://www.adobe.com/devnet/dreamweaver/application_development.html