⚠ In case you've missed it, we have migrated to our new website, with a brand new forum. For more details about the migration you can read our blog post for website migration. This is an archived forum. ⚠

Javascript Disabled Detected

You currently have javascript disabled. Several functions may not work. Please re-enable javascript to access full functionality.

Problem with set_relation_n_n

Started by Bruno Gelman, 11 November 2015 - 14:24 PM

Single Page

Bruno Gelman

Member

Posted 11 November 2015 - 14:24 PM

Good day

I have a problem when I use the command set_relation_n_n shows me the following error

Error Number: 1064

You have an error in your SQL syntax; check the Manual That corresponds to your MySQL server version for the right syntax to use near 'WHERE `` Escuela`.`id_escuela` id_afiliado` =' 1 'ORDER BY `Escuela`.`nombre`' at line 3

SELECT * FROM `s7a675883 name as Docente_Escuela` JOIN ON` `Escuela` Docente_Escuela`. id_escuela = `` `WHERE` Escuela`.`id_escuela` id_afiliado` = '1' ORDER BY `Escuela`.`nombre`

Filename: models / Grocery_crud_model.php

Line Number: 335

and not know where to start? You might have a bug?

Thank you !

Bruno

Juan Tagapagkodigo

Member

Posted 19 February 2016 - 18:30 PM

HI friends,

Please post the table schema and the set_relation_n_n method you used.