I found 2 errors: when using db.(db.table).select() i get the following sql query :
sql=SELECT <tablename>.<fieldname1>,<tablename>.<fieldname2>, ...FROM <tablename> WHERE <tablename>.<fieldname1> IS NOT NULL <fieldname1> : the primary key, i think that's why " .. is not null" errors : db.executesql crashes the same as the db.(db.table).select() when using the same sql query. If i remove the <tablename> from field the query works. I mean sqlnew = SELECT <fieldname1>,<fieldname2>, ...FROM <tablename> WHERE <fieldname1> IS NOT NULL and the where clause does not work with the NULL. Return *zero data the "is not null" and all data the "is null*" but the primary key is always not null. Any help ? Maybe new Adapter for access ? -- 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 [email protected]. For more options, visit https://groups.google.com/d/optout.
