Topic awaiting preservation: Add checkbox value to MS Access file (ASP) (Page 1 of 1)

Hi, guys. I am trying to update database file filed, which is checkbox.
In my database file, there are filed called Screw.
I am adding new product, which has sometimes screw.
So in my ASP file, I made textbox to enter some data about product. And there is a checkbox to see if it is screw or not. I am trying to pass that value to MS access database.
I did something like this:

Star = Request.Form("Star")

	If Not IsEmpty(Request.Form("Screw")) Then

	Screw = "True"

	Else

	Screw = "False"

	End If	

	

''''''''''''''''''''''''''''''''''

'SQL statement to add new product.

'But Screw is checkbox filed in msdb. 

'''''''''''''''''''''''''''''''''''

	

	sql = "INSERT INTO Wine_Winery (WineryID, WineID,  Screw) VALUES"

	sql = sql & "('"&WineryID&"','"&WineID&"', '"&Screw&"')"

Hmm.....I am not certain about how to add checkbox value to database itself.
Please help.

Hiroki Kozai

Try sending a 0 (zero) or a 1 (one) to the database. 1 is True, 0 is False.

Cheers, I will try that.


Hiroki Kozai

Many thanks.
It works fine!
Cheers,

Hiroki Kozai