<!--- 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>