[web2py] Feature request: Support for SQL REPLACE INTO

2013-10-13 Thread Kevin Crowston
In the database abstraction layer, it would be useful to have support for the SQL REPLACE INTO command. update_or_insert doesn't do quite the same thing. -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.g

[web2py] Re: DAL, legacy keyed table, field references

2013-10-13 Thread Kevin Crowston
Another glitch with legacy keyed tables is that text fields of type 'reference table.field' aren't encoded for SQL correctly (at least, not for SQLite). They end up in the SQL as u'key', which creates a syntax error. On Friday, October 1, 2010 7:19:47 AM UTC-4, Ivan Matveev wrote: > > Hello