I have an Access database containing a Column defined
as "True/False", a Boolean, I need to be able to update this column.
How can I force the Data type in the SQL to update the column? This
is running Server-Side.
I have tried:
*******************************************************
strSQL = "UPDATE [GROUP] SET VIP = " & Cbool(VIPValue) & " Where Name
= '" & strEnteredName & "'"
Set recordset = connection.Execute (strSQL)
********************************************************
also
********************************************************
strSQL = "UPDATE [GROUP] SET VIP = " & VIPValue & " Where Name = '" &
strEnteredName & "'"
Set recordset = connection.Execute (strSQL)
********************************************************
VIPValue I have tried setting to ("TRUE" and "FALSE") or ("on"
and "off")
I use the exact same code in other places to update string
information in a different column with no problem. I do have the
recordset available at this point in the code.
Madorick
Work like you don't need to
Love like you've never been hurt
Dance like no body is watching
---------------------------------------------------------------------
Home : http://groups.yahoo.com/group/active-server-pages
---------------------------------------------------------------------
Post : [EMAIL PROTECTED]
Subscribe : [EMAIL PROTECTED]
Unsubscribe: [EMAIL PROTECTED]
---------------------------------------------------------------------
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/active-server-pages/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
