Include the value of a boolean field in SQL Insert string

[jcc285]

I have a form which has three variables, 2 text box string variables (strMembershipType & strIsType) and one checkbox boolean value (chkPayingMember) this can be True or False.


These represent values in an underlying table, fields Membership_Type (text), Membership_Code(text), Paying_Member(True/False)

Using data entered into the form I am trying to create an SQL INSERT string.

strSQL = "INSERT INTO tbl_Members (Membership_Type,Membership_Code, Paying_Member VALUES ('" & strMembershipType & "','" & strIsType & "',WHAT GOES HERE)"

I think I've tried every combination of single and double quote without success, all I want is for the last item to say True or False. It stubbornly refuses to do this constantly returning the variable name as a literal rather than a value.

Help gratefully received

[CJ_London]

Boolean is a number (True/False, Yes,No, -1,0), so no quotes required


.... & strIsType & "'," & True & ")"

or

.... & strIsType & "'," & -1 & ")"

or

.... & strIsType & "'," & chkPayingMember & ")"


note that chkPayingMember must not be null otherwise you will get an error

[jcc285]

Thank you, the third option is what I wanted. Can't believe I didn't try that!! Ah well, end of a long day.
I will trap a Null value before creating the string.
Many thanks