Home | How it works | Projects archive | Contact Us
Air Compressor Bot 		 
The Career Path of Freelance Programming Jobs 

   Asp Msacess Reservations Site
Bidding Time:
02/09/2005 21:48 - 07/09/2005 21:48
Budget:
$1-400
Status:
 Closed

Job Type:
Visual Basic, ASP
Description:
This MS Access database already exists with these fields. With 2 Tables

Properties(table)
prop_name
prop_id

reservations(table)
reservation_id
first_name
last_name
email_add
phone
checkin_month
checkin_day
checkin_year
checkout_month
checkout_day
checkout_year
occupancy
reservation_property


I will need the following 2 part scripts/pages made:


1) Property Availability Query
I will pass the page querystring variable "r_date=MO/DY/YR" to your
script/page.

1a.
The query selects all UNIQUE "prop_name" from properties, then displays a table
in the results with each UNIQUE property as a left column.

1b.
It takes the variable r_date, and queries the database for any reservations on
that date AND for that "reservation_property". IF the date AND
reservation_property has a reservation, then SHOW redimage.gif in the right
column, next to the corresponding name of the "reservation_property". If the
property does not match the date AND reservation_property, then show
greenimage.gif.


2) Add New Reservation script. I can write a straight insert script into the
database myself, but I need someone to write a script for handling multiple date
insertions.

For example, if a person reserves the dates, 10/11 though 10/17, there needs to
be 7 records inserted, one for each day. 10/11, 10/12, 10/13, etc. I think we
can use the VB script "DATEDIFF" to count the days by comparing the 2 dates, but
I do not know how to insert the 7 records, with the same reservation_id.

I am pretty good at ASP and can provide you with alot of assistance, I just
need someone to make these 2 pieces work smoothly. I know if can be done in a
few hours by anyone who knows ASP fluently.

Get $20 Off Panda Internet Security 2008. Coupon Code: WOWPISUSD20.

Related Projects:
Product review/survey script like amazon custom - read carefully
Programming
Website Design Eshopping Cart
User Directory
Mambo Theme Desighn

This project is the proprietary information of . Click here to remove this project from OUR database.
Operating System:
 Windows
Database System:
 SQL
<<< back

Recent Projects Archive:

Friday - Thursday - Wednesday - Tuesday - Monday - Sunday - Saturday

View all freelance web projects
 
Home | Projects archive | RSS | Resources | Links | Contact Us © 2004-2009 ProjectsList.biz /0.584