SQL syntax for access

[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

 

[cfStarlight]

What is the error? Perhaps you have a data type mismatch problem. I have no problem running this query with the unicode driver.

SELECT * FROM SubNav1
WHERE menuID = 3 AND isLive = 1
ORDER BY Priority

 

[r937]

didn't you already post this question somewhere else and get an answer? i'm sure i've seen this before

replace isLive = 1 with isLive is true




r937.com | rudy.ca

 

[r937]

whoops, i was thinking of is null, sorry

it's actually isLive = True



and yes, you got this question answered in the Access forum already

r937.com | rudy.ca

 

[cfStarlight]

and yes, you got this question answered in the Access forum already

Thanks for that. No point spending time on a question that was already answered