Complex Select with Connector

Suite and Optimus Suite 5
#1

Hi,

i’m tring to create a complex select with render_sql method but i’m surelly not doing the right stuff on syntax:



my quesry is:



$timeshhet->render_sql(“SELECT * FROM hs_hr_employee b JOIN(hs_hr_emp_locations a JOIN hs_hr_attendance c ON(a.emp_number=c.employee_id) JOIN hs_hr_location l ON(a.loc_code=l.loc_code)) ON(b.emp_number=a.emp_number) WHERE b.employee_id=” ."’". $_GET[“filter”] ."’",“attendance_id”,“employee_id,punchin_time,in_note,punchout_time,out_note,status”);



in other cases the query works but i have to convert in render_sql syntax…



could u pls help me?



Thank u

#2

What version of dhtmlxGrid do you use? dhtmlxConnector version 0.9 has issue with complex sql query. Please try to use latest version dhtmlx.com/docs/products/dhtmlxC … ndex.shtml

#3

I’m using 0.95 php version…