I've started creating asp pages in Dreamweaver to write data to MS Access 2000 but I'm stuck on sending multiple records - I'd like the project completed with comments to allow me to learn how to do it. PLEASE NOTE: You do NOT have to use the attempts that I've made - if it's easier for you to start from scratch, then do so.
To take bookings for craft parties - the bookings might be made by the customer from his/her PC (which means they have internet access and, therefore, an email address) or might be made by me at my shop on their behalf, in which case they might not have an email address.
To be completed by guardian of birthday child: (NOTE - NOT ALL FIELDS ARE MANDATORY)
At the moment, parties are held *only on Sundays*
Party date (pull the dates from a database so that only free slots are accessible - I need to be able to manually block out dates - note that each date has two possible parties - a.m. or p.m. )
Party time ([url removed, login to view] or [url removed, login to view])
Host first name
Host last name
Host address (address 1, 2, 3, suburb, postcode)
Host mobile ‘phone
Child’s first name
Child’s last name
Child’s notes (e.g., allergies, dietary requirements)
Number of guests (minimum 3, maximum 9)
For each guest: first name, last name
This should update the database, send an email to me to say there’s a new booking (with same details as are sent to the host), send a confirmation email to the host with the booking details (date, time, place, invitation, project & menu choices, guest list, cost, login name & password), and generate a login & password for the guests (one login, one password?) The guest login for Mary Smith’s party on 30 August 2007 could be marysmith300807. **Note** ??" if the host has no email address, that should be pointed out to be in the email to me. Can we check if email bounces?
The host should be able to log back in later to make changes ??" emails should be sent to me & the host as above.
To be completed by guardians of guests
They need to login ??" could the login they type automatically take them to the correct child’s party?
They check that first & last names are correct & amend if necessary
Child notes (allergies, etc.)
Guardian first name
Guardian last name
Guardian address (address 1, 2, 3, suburb, postcode)
Guardian mobile ‘phone
This would update the guests database & send an email to me to let me know that they’ve done it.
I will not grant extensions under any circumstances.
I will want you to reiterate to me your understanding of the project before I award it to you.
Thanks - Cath
A server running Windows. I want to be able to edit the asp files in Dreamweaver and want the database to be MS Access 2000.