Query of Query LIKE and Wild Card chars

[Ramboni]

I am tyring to use the 'LIKE' comparison within a Query of Query. The Query is
shown below.

<cfquery dbtype="query" name="GetFileList">
select * from ResFiles where name LIKE '#url.rid#_%'
</cfquery>

The Url.rid is always a positive integer.
I am trying to search within a directory for files whos name is of the forme
'123_AnyName.doc'. The problem is that both '_' and '%' are both valid
wild-card characters.
According to a CF MX Reference book we have, you can use forward-slash '/' as
an escape character. Therefore, I tried #url.rid#/_% to try to escape the '_'
character; and just to hench my bets I also tried #url.rid#\_%, but they do not
escape the '_' at all. In fact the RecordCount = 0 when I try this because, of
course, the query will be looking for e.g. '123\_AnyName.doc'.
How do I escape the flaming '_' in the query above.

Regards RS.

[paross1]

Hmmm, does using two _'s in a row escape the special meaning? I haven't tried it , but you might give it a shot.

Phil