Welcome Guest, Not a member yet? Register   Sign In
SQL
#1
Exclamation 

Hello, 
I build a query with query builder and sqlsrv driver, with this code
$this->join("[Ultrafog Sp_ z o_o_\$Production BOM Line] as job_items", "job_line.No_ = job_items.[Production BOM No_]", 'LEFT');
the driver generate this wrong query
LEFT JOIN "ultrafog_prod"."dbo"."[Ultrafog" Sp_ z o_o_$Production BOM Line]" as "job_items" ON "job_line"."No_" = "job_items"."[Production BOM" "No_]"
Seem it have problem with column and field name with space ignoring square bracket
Some one konw a work around?
Reply




Theme © iAndrew 2016 - Forum software by © MyBB