Query of Queries error in Coldfusion when using LIKE

This very odd behaviour hit me the other day when querying an existing query which was in a scope (i.e request.query):

The query should look like this:

<cfquery dbtype="query" name="getReltrans">
SELECT * from request.translations WHERE ComposerID  LIKE '%#somevar#%';
</cfquery>

But it throws an error. The reason is, when querying a query object, you need to tell Coldfusion not to return NULL values.

This works:

<cfquery dbtype="query" name="getReltrans">
SELECT * from request.translations WHERE (ComposerID IS NOT NULL AND ComposerID LIKE '%#somevar#%');
</cfquery>

Thanks to Ben Nadel for the heads up!