<!--- Insert the new  trip record  into the Compass Travel Database --->
<cfquery name="AddTrip" datasource="CompassTravel">
 INSERT INTO Trips (tripName, eventType, tripDescription, tripLocation, 
		departureDate, returnDate, price, tripLeader, photo,
		baseCost, numberPeople,	depositRequired)
  VALUES ( '#Form.tripName#', #Form.eventType#, '#Form.tripDescription#',
		'#Form.tripLocation#','#Form.departureDate#', '#Form.returnDate#',
		#Form.price#,'#Form.tripLeader#', '#Form.photo#',
		#Form.baseCost#, #Form.numberPeople#, '#Form.depositRequired#')
</cfquery>