Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Boolean SQL on a VFP table?
Message
De
22/01/2001 11:40:46
 
 
À
Tous
Information générale
Forum:
Internet
Catégorie:
Active Server Page
Titre:
Boolean SQL on a VFP table?
Divers
Thread ID:
00466676
Message ID:
00466676
Vues:
36
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
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform