Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
reddymade
Posting Yak Master
165 Posts |
 Posted - 2006-05-02 : 12:07:14
|
| I have the following insert, i am trying to push true or false into a Bit datatype field.I thought True means 1, false means 0.because these are the values i am receiving from client, i am straight away passing true or false.What is wrong with the query.*******************insert into categorylist(description,fatherid,id,lastlevel,orderby,systemcat) values('FreeTunes',0,349,True,0,0)********************Thank you very much for the information |
|
|
Kristen
Test
22859 Posts |
Posted - 2006-05-02 : 12:08:35
|
| Change True to 1 ?Kristen |
 |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2006-05-03 : 02:38:33
|
| or with any number not zeroMadhivananFailing to plan is Planning to fail |
|
|
|
|
|
|
insert query how to pass true or false into a bit