Here is my query:
When I run this query, nothing gets inserted into my database. Any ideas why?
Code:
INSERT INTO Car_Checkout
(CEmp_ID,CCar_ID,Date_Out,Date_In,Odometer_before,Odometer_after,Destination,Miles_Travelled,Business,Personal)
VALUES
(#form.EmpID#, #car_id#, #CreateODBCDate(form.StartDate)#, NULL, #form.car_present_odometer#, NULL,
'#form.Destination#', NULL,'#form.Business#','#form.Personal#')
When I run this query, nothing gets inserted into my database. Any ideas why?