What is wrong with this statement...
Set rsOrders = Server.CreateObject("ADODB.Recordset")
sSQL = "SELECT * FROM orders WHERE shipped = 'False'"
rsOrders.open sSQL, dbMain
If I write Response.Write rsOrders( "shipped") it prints False. To "stuff" a boolean variable into the table I have to use 0 for false and -1 for true. I have tried quering for False, 0, .F., F you name it, with and without quotes, but I keep getting an Operator/operand type mismatch error.
Perplexed and truly stumped
Please HELP!
zorfox@acceleration.net