3 Replies Latest reply: Feb 13, 2013 12:52 PM by WolfShade

Query of Query - filtering

WolfShade Feb 13, 2013 10:29 AM

Hello, everyone.

I need to do a QoQ and get a COUNT() of the records that fit a certain criteria, using TRIM and UPPER to make sure the match is solid.

In Oracle, it would be SELECT COUNT(*) as TOTALS FROM tableName WHERE UPPER(TRIM(both ' ' FROM columnName)) = 'THISWORD'

But Oracle conventions don't work in QoQ. What would be the CF QoQ equivalent? (I'm sure it's something simple and I'm just too tired to see it.)

Thanks,

^_^

1. Re: Query of Query - filtering

Dan Bracuk Feb 13, 2013 11:19 AM (in response to WolfShade)

Are you sure that will work in Oracle? Looks like an incomplete subquery to me.

In any event, "upper" is supported by QofQ. I know you can do this:

select count(*)
from myQuery
where upper(myField) = 'FRED'

I've never tried trim before so I don't know if it's supported.
Like Show 0 Likes (0)

Actions
2. Re: Query of Query - filtering

WolfShade Feb 13, 2013 11:27 AM (in response to Dan Bracuk)

Hi, Dan.

I'll give the UPPER() a shot. TRIM(), I'll play around with and report back.

Much appreciated.

^_^
Like Show 0 Likes (0)

Actions
3. Re: Query of Query - filtering

WolfShade Feb 13, 2013 12:52 PM (in response to WolfShade)

UPPER() worked like a charm. As far as TRIM() - it's just TRIM(columnName), nothing else.

Thanks, Dan!

^_^
Like Show 0 Likes (0)

Actions