>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

WAG, but try:

sSQL = "SELECT * FROM orders WHERE !shipped"

and see if the VFP ODBC driver parses that correctly.

HTH.