SQL and Coldfusion - sql syntax for access 1

[jenmerr]

Hi
I am using Coldfusion with MS Access. The it's datasource is running on a setting called Access with Unicode.
The code that runs perfectly in MS Access will not run under the new setting MS Access with Unicode.

Here is an example

<CFQUERY NAME="getMenu3" DATASOURCE="#APPLICATION.DSN#">
SELECT * FROM SubNav1#SESSION.lang#
WHERE menuID = 3 AND isLive = 1
ORDER BY Priority</CFQUERY>

If i take out isLive = 1 the query works.

So i am wondering if there is some other way in writing the SQL syntax?

Thanks a million

 

[jrbarnett]

Is the IsLive field based on a numeric data type (byte, long, integer etc)?

John

 

[jenmerr]

The Data Type is Yes/No in the access database

 

[jrbarnett]

Use

IsLive = True

or

IsLive = False

then instead. Access treats 0 as False and anything other than 0 as true, but if you look at the ordinal value of True it is -1.

John