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 | May 6, 2020
If you are having intermittent problems sending email in .NET using System.Net.Mail consider switching libraries.
by John Avis | November 4, 2019
As support ends for Microsoft Windows Server 2008 I have recently gone through migrating some websites to a new server running Windows Server 2016 and IIS 10 but some of the websites did not work.
by John Avis | October 15, 2019
For a website project I needed a way to enter multiple tags. I just wanted something simple that I could easily modify to suit my own needs, so I wrote my own.