Hi, all:

This sees a simple question because its all about is yes or no. However, I 

have truggled for days with it.

In my Access table I have a yes/no field. I am trying to insert a value 

with an asp page. My problem is what do I states that value? I tried 1/0, 

yes/no, true/false, with and without ', [], #... quoted, anyway, it does 

not work. Does anybody have this experience before? I appreciate your help!

By the way, what if I am using Oracel, SQL server, I guess it will bug me 

again.



kun 

INSERT INTO Table1 (YesNoField) VALUES (True)



-or-



INSERT INTO Table1 (YesNoField) VALUES (-1)



Cheers

Ken



~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

From: <kfeng@m...>

Subject: [access_asp] how to insert a yes/no type value?





: Hi, all:

: This sees a simple question because its all about is yes or no. However, I

: have truggled for days with it.

: In my Access table I have a yes/no field. I am trying to insert a value

: with an asp page. My problem is what do I states that value? I tried 1/0,

: yes/no, true/false, with and without ', [], #... quoted, anyway, it does

: not work. Does anybody have this experience before? I appreciate your

help!

: By the way, what if I am using Oracel, SQL server, I guess it will bug me

: again.



~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~