I have table, name FlightSchedule
Fields: DepartureDate, FlightNo, DepartureTime, Origin, Destination
I created a form for online reservation, i was successful in form validation. when the user enters his detail, and then origin, destination, departuredate, the control checks in the database table on the basis of "origin, destination, and departure date" whether the flight is available or not. if the origin, destination and departure date values of database and form input match then the process proceeds. i'm having trouble in this query
set rec=con.execute("Select from FlightSchedule....
What do i do in this?
Fields: DepartureDate, FlightNo, DepartureTime, Origin, Destination
I created a form for online reservation, i was successful in form validation. when the user enters his detail, and then origin, destination, departuredate, the control checks in the database table on the basis of "origin, destination, and departure date" whether the flight is available or not. if the origin, destination and departure date values of database and form input match then the process proceeds. i'm having trouble in this query
set rec=con.execute("Select from FlightSchedule....
What do i do in this?