Remember SQL used by Access isn't the same as ANSI SQL - and compatibility varies by Access version. I think you'd run into this a lot...
On Monday, October 20, 2014 10:24:48 AM UTC-4, ksotiris wrote: > > 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.
