In Microsoft Access you can use true or false in queries, for example:
SELECT * FROM tablename WHERE booleanfield=TRUE SELECT * FROM tablename WHERE booleanfield=FALSESQL Server/MySql require a different approach:
SELECT * FROM tablename WHERE booleanfield=1 SELECT * FROM tablename WHERE booleanfield=0The Microsoft Access query will not work in SQL Server/MySql and the SQL Server/MySql query will not work in Access as it treats true as -1 not 1.
For a cross-platform solution you can use the following:
SELECT * FROM tablename WHERE booleanfield<>0 SELECT * FROM tablename WHERE booleanfield=0
by John Avis | March 21, 2017
I recently needed to change a client's website to send emails using Amazon SES and encountered a few issues.
by John Avis | June 8, 2016
Although probably no one cares about Classic ASP, except those who still need to support it, I was refreshing my memory today on how to use classes in Classic ASP and found a couple of options for simulating constructors with parameters.
by John Avis | July 31, 2015
As of July 2015, many of my Classic ASP websites have started logging strange errors, either 80004005 or not reporting any error code at all.