N
nicholas
my insert works, but without the boolean value contentavailable.
When I try to insert this boolean I get a data mismatch error.
this "contentavailable" is an asp.net checkbox
I use a ms access dbase.
any ideas? THX
here's the code:
commInsert.Execute("INSERT INTO tbl_contents (contenttypeID, contentEN,
contentFR, contentNL, contentDU, contentdescriptionEN, contentdescriptionFR,
contentdescriptionNL, contentdescriptionDU, contentavailable, contentorder)
VALUES('" & ctype(contenttypeID.selecteditem.value,integer) & "','" &
contentEN.text & "','" & contentFR.text & "','" & contentNL.text & "','" &
contentDU.text & "','" & contentdescriptionEN.text & "','" &
contentdescriptionFR.text & "','" & contentdescriptionNL.text & "','" &
contentdescriptionDU.text & "','" & contentavailable.checked & "','" &
contentorder.text & "');")
When I try to insert this boolean I get a data mismatch error.
this "contentavailable" is an asp.net checkbox
I use a ms access dbase.
any ideas? THX
here's the code:
commInsert.Execute("INSERT INTO tbl_contents (contenttypeID, contentEN,
contentFR, contentNL, contentDU, contentdescriptionEN, contentdescriptionFR,
contentdescriptionNL, contentdescriptionDU, contentavailable, contentorder)
VALUES('" & ctype(contenttypeID.selecteditem.value,integer) & "','" &
contentEN.text & "','" & contentFR.text & "','" & contentNL.text & "','" &
contentDU.text & "','" & contentdescriptionEN.text & "','" &
contentdescriptionFR.text & "','" & contentdescriptionNL.text & "','" &
contentdescriptionDU.text & "','" & contentavailable.checked & "','" &
contentorder.text & "');")