SELECT `Foto`.`id`, `Foto`.`immobile_id`, `Foto`.`nome`, `Foto`.`codice_riferimento`, `Foto`.`nome_file`, `Foto`.`nome_eng`, `Foto`.`nome_file_miniatura`, `Foto`.`extra_path`, `Foto`.`extra_path_miniatura`, `Foto`.`descrizione`, `Foto`.`descrizione_eng`, `Foto`.`note`, `Foto`.`created`, `Foto`.`modified`, `Foto`.`horiz`, `Immobili`.`id`, `Immobili`.`agenzia_id`, `Immobili`.`tipologia_id`, `Immobili`.`comune_id`, `Immobili`.`CAP`, `Immobili`.`descrizione`, `Immobili`.`latitudine`, `Immobili`.`longitudine`, `Immobili`.`testo_mappa`, `Immobili`.`testo_mappa_eng`, `Immobili`.`cliente_id`, `Immobili`.`note`, `Immobili`.`indirizzo`, `Immobili`.`riferimento`, `Immobili`.`localita`, `Immobili`.`codice_riferimento`, `Immobili`.`metri_quadrati`, `Immobili`.`superficie_terreno`, `Immobili`.`created`, `Immobili`.`modified` FROM `Foto` AS `Foto` LEFT JOIN `Immobili` AS `Immobili` ON (`Foto`.`immobile_id` = `Immobili`.`id`) WHERE `id` = '$id' LIMIT 1 Warning: SQL Error: 1052: Column 'id' in where clause is ambiguous in ........./cake/libs/model/datasources/dbo_source.php on line 437
On 11 Dic, 17:30, AD7six <[EMAIL PROTECTED]> wrote: > On Dec 11, 5:12 pm, Paolo <[EMAIL PROTECTED]> wrote: > > > HI! > > > I'm trying to delete a row from a model, using > > Modelname->del($id) > > > But I receive the error > > > SQL Error: 1052: Column 'id' in where clause is ambiguous > > > Why is this happening? How can i solve itP? > > > Thanks > > How about showing the sql which is generating that message. > > AD --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Cake PHP" group. To post to this group, send email to cake-php@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cake-php?hl=en -~----------~----~----~----~------~----~------~--~---