On Fri, 19 May 2006 14:47:10 +0200, Julien ARNOUX <[EMAIL PROTECTED]> wrote:
> cur.execute("select foo from test where foo regex 'aa.[0-9])") > and the error is: > cur.execute('select foo from test where foo regex tata') > apsw.SQLError: SQLError: near "regex": syntax error I think you're missing a closing quote on that regex; or perhaps that's an extra closing parenthesis at the end. Also, it's probably best to let the database module do any escaping you may need. For example: fooregex = r'aa.[0-9]' sql = 'select foo from test where foo regex %s' cur.execute( sql, tuple( fooregex ) ) See the DP API spec for more information. Regards, Dan -- Dan Sommers <http://www.tombstonezero.net/dan/> "I wish people would die in alphabetical order." -- My wife, the genealogist -- http://mail.python.org/mailman/listinfo/python-list