Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Boolean SQL on a VFP table?
Message
From
22/01/2001 11:40:46
 
 
To
All
General information
Forum:
Internet
Category:
Active Server Page
Title:
Boolean SQL on a VFP table?
Miscellaneous
Thread ID:
00466676
Message ID:
00466676
Views:
37
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
Next
Reply
Map
View

Click here to load this message in the networking platform