bits and booleans

catchy title eh

anyway.....

been a while since I've done SQL and I can't remember the reason this code

------------------
dim litem1

litem1 = false
if (litemid = "001") then litem1 = true
lidnumber = 1001
lemail = "whatever@gmail.com"

linsertstring = "INSERT INTO tbl_compdetails VALUES ("& lidnumber &",'"& lemail &"',"&litem1&")"

recset.Open linsertstring, conn
------------------

gives me this error message

Microsoft OLE DB Provider for SQL Server error '80040e14'

The name 'False' is not permitted in this context. Only constants, expressions, or variables allowed here. Column names are not permitted.

/aegonaccess/cookiesanddb/founditem.asp, line 57

help

Bits are 1 and 0, try passing those in instead of True and False.

god I'm so dumb, was thinking bits were booleans so true & false would work

thanks mod with scary avatar