Logical Field Update Problem

[eagle1wi]

I am getting the 37000 ODBC error. I have narrowed it down to my logical fields.
What is the correct syntax for updating a logical value via ODBC?

I am inserting using a form variable.
I have tried to insert T, TRUE, YES, Y, 1 and nothing seems to work.

I am using Cfquery and have tried single and no quotes.

Thanks in advance for any input.

Craig

 

[Silvano]

this is what I have used to update field and it worked fine:

<cfquery name=&quot;allTables&quot; datasource=&quot;dbn&quot; dbtype=&quot;ODBC&quot;>
UPDATE Table1
SET unchecked = true;
</cfquery> Sylvano

dsylvano@hotmail.com

 

[eagle1wi]

That syntax didn't work for me.
It is probably my database.
Does anyone have any CF experience with Dbase, FoxPro or similar? I seem to only have an issue with logical fields.

Craig