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 | February 20, 2019
I was recently doing some work on a website which has a mixture of older Classic ASP pages and ASP.NET Web Forms pages and ran into problems with custom error pages.
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.