how about this?
db.define_table('thing', Field('name'), auth.signature)
user_to_delete = 5
first_thing = db(db.thing.created_by==user_to_delete).select(db.thing.id,
limitby=(0,1)).first()
db(db.thing.created_by==user_to_delete)(db.thing.id!=first_thing.id).delete()
On Sunday, 9 September 2018 13:11:41 UTC-7, Maurice Waka wrote:
>
> I am trying to delete rows.
> I want to delete rows only posted by a specific user and not just do
> db.post.delete()
> I also want to preserve the first row, something like if db.post.count()
> >1:deletable = True else deletable = False but this is not working for me.
> How do I achieve these two?
> Regards
--
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
---
You received this message because you are subscribed to the Google Groups
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
