I can not add a new record with this query

This topic is locked

I can not add a new record with this query	8/12/2008 3:11:08 PM
PHPRunner General questions
S swanside author I keep getting this error, any ideas please? Helpdesk, Add new record <<< Record was NOT added >>> Unknown column 'Engineer_Name' in 'field list' `SELECT job.Order_Date, job.File_No, job.Job_No, job.Customer_ID, job.Order_Time, job.Contract, job.Order_Site_Address, job.Job_Description, job.VAT, job.Invoice_Printed, job.Invoice_Printing_Date, job.Invoice_Tax_Date, job.Payment_Received, job.Job_Finished, job.CustomerRef, job.Customer_Name, job.Payment_Due_date, job.Payment_Date, job.Locked, job.Note, labour.Engineer_Name FROM job INNER JOIN labour ON job.Job_No = labour.Job_No ORDER BY job.Job_No DESC` Thanks Paul


J	Jane 8/13/2008
	Hi, PHPRunner doesn't support updating multiple tables on one page. You can implement this manually using > Before record updated/added events. I.e. use something like this: global $conn; $sql = "update othertable set joinedfield=".$vales["joinedfield"]." ... "; db_exec($sql,$conn); unset($vales["joinedfield"]);