This query

> db((db.table1.data == data) & (db.table2.table1_id ==
> db.table1.id)).delete()

involves two tables therefore it is well defined in a select (it is a
join) but not in a delete. You can only delete if a query involves a
single table.

Massimo

On Nov 23, 8:48 pm, Tari <[EMAIL PROTECTED]> wrote:
> Hi, I would really appreciate help with this one:
>
> db((db.table1.data == data) & (db.table2.table1_id ==
> db.table1.id)).delete()
>
> This condition works quite OK in a select, but how can I delete these
> rows? Instead deleting the appropriate rows from both tables, py gives
> me an "Unable to determine what to delete".
>
> I'm unable to determine how to solve this.
> Thanks in advance.
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups 
"web2py Web Framework" group.
To post to this group, send email to web2py@googlegroups.com
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at 
http://groups.google.com/group/web2py?hl=en
-~----------~----~----~----~------~----~------~--~---

Reply via email to