CodingForums.com - View Single Post - Converting MS Access iif statement in SQL

Old Pedant · 10-23-2012, 01:18 AM

Oh, and I would use <> 0 instead of = -1 unless the field can have other possible values.

I would bet you only got the -1 in there when you converted from Access YES/NO field to MySQL, yes? I'd be sorely tempted to change all the -1's to just 1 in the DB, but that's up to you.

10-23-2012, 01:18 AM	PM User \| #7
Old Pedant Supreme Master coder! Join Date: Feb 2009 Posts: 23,209 Thanks: 59 Thanked 3,996 Times in 3,965 Posts	Oh, and I would use <> 0 instead of = -1 unless the field can have other possible values. I would bet you only got the -1 in there when you converted from Access YES/NO field to MySQL, yes? I'd be sorely tempted to change all the -1's to just 1 in the DB, but that's up to you. __________________ An optimist sees the glass as half full. A pessimist sees the glass as half empty. A realist drinks it no matter how much there is.