I am having problems getting an IF statement to work, can you have an IF statement on a line like below

sSQL="SELECT * FROM asplinks WHERE a=true AND b=true"

The bits in bold will change in the IF variants, so there will be:

True - True
True - False
False - True
False - False

and there will be one final line with out the WHERE bit.

Its been such a long time since I used SQL

Not totally sure of what you're getting at but this example should work (assuming that a and b are names of fields in the database):

sSQL="SELECT * FROM asplinks WHERE ((a=true) AND (b=true)) OR ((a=false) AND (b=false))"