Access 2003 query not same as in CF

[dtubbs]

Hello..

I'm hoping this is simple, but it seems odd to me. I created a query in CF
and when I run it in the cf page, it returns 0 records. I turned on debugging
and then reran the query, then cut and paste the query returned in debug mode
to Microsoft Access. It returns the records I'm expecting. I've used access
for quite a while now and have had consistent results using this method. I've
just started using MS access 2003. Any ideas would be greatly appreciated.

This is my query below:

SELECT DISTINCT assets.assetid, assets.fileName, assets.filePath,
assets.description, assets.mediaTypeFK
FROM mediaType INNER JOIN ((assetKeyword INNER JOIN keywords ON
assetKeyword.keywordIdFK = keywords.keywordId) INNER JOIN assets ON
assetKeyword.assetIdFK = assets.assetid) ON mediaType.mediaTypeId =
assets.mediaTypeFK
WHERE mediaTypeFK = 1

AND keywords.keywordDesc Like '*computer*'

[paross1]

Bad wildcard character. You can use * in Access, but from CF (through ODBC) you
need to use %

SELECT DISTINCT assets.assetid, assets.fileName, assets.filePath,
assets.description, assets.mediaTypeFK
FROM mediaType INNER JOIN ((assetKeyword INNER JOIN keywords ON
assetKeyword.keywordIdFK = keywords.keywordId) INNER JOIN assets ON
assetKeyword.assetIdFK = assets.assetid) ON mediaType.mediaTypeId =
assets.mediaTypeFK
WHERE mediaTypeFK = 1
AND keywords.keywordDesc Like '%computer%'

Phil

[dtubbs]

Thanks that did it.

Appreciate such a quick response.