> So you can't delete all data in table without where="1=1" hack. Funny, yeah?
> May be you need to fix documentation. Documented error not a bug but feature
I think that web.delete(), as well as other database utility functions
founded at db.py such as web.select() and web.insert(), etc., were
created to ease the common use of database commands in a 'normal' web
application. It would be hard to find a web application where you will
wish to let users delete all the rows in a table.
In your case you can get things done easily with:
cur = sqlite3.connect('/path/to/db/file').cursor().execute('delete
from table_name')
cur.connection.commit()
cur.connection.close()
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"web.py" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at http://groups.google.com/group/webpy?hl=en
-~----------~----~----~----~------~----~------~--~---
