2. PHPRunner General questions
  3. Duplicated Jobs displaying in Liis page
This topic is locked

Duplicated Jobs displaying in Liis page

 		6/3/2008 4:55:08 AM
PHPRunner General questions
S
 swanside author

Hello.
I have re-written my SQL query to this.

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.Payment_Due_date,

job.Payment_Date,

job.Locked,

job.Note,

sites.site_address,

customer.Customer_Name

FROM job

LEFT OUTER JOIN customer ON job.Customer_Name = customer.Customer_Name

LEFT OUTER JOIN sites ON job.Customer_Name = sites.Customer_Name

ORDER BY job.Job_No DESC


But now it is duplicating the list view with 2 or sometimes 3 duplicates, but the job number is staying the same and the SQL database is only showing the one input?
Cheers
Paul.
J
 		Jane 6/4/2008

Hi,
PHPRunner doesn't create duplicate records.

I recommend you to execute and debug this query in the database directly.
S
 		swanside author 6/4/2008

Hi,

PHPRunner doesn't create duplicate records.

I recommend you to execute and debug this query in the database directly.


Hi Jane, SOrry I was not too clear.
The database does not have any duplicates init, but when it is displayed, it is showing duplicate jobs with duplicate job numbers which is auto incremented anyway, It is something to do with my SQL script I think, I have played around wiith it this morning and it seems to be ok now.
Thanks for our help
Paul.