October 2003 23:12
To: CF-Talk
Subject: QoQ and Like
Hi Folks,
I'm encountering a problem with queries of queries and the like
statement:
This works:
cfquery name=results dbtype=query
select *
from assets
WHERE STATUSID = 6
AND ASSETTYPEID = 1
AND WORKSTATIONNAME = 'abcd'
/cfquery
Nope, I checked that, and CFMX 6.1 does support the LIKE statement for QoQ
Any other ideas?
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
FROM tableName
Then do your Q of Q with the LIKE operator.
Hien
-Original Message-
From: Suyer, Ed [PRD Non-JJ]
Sent: Thursday, October 09, 2003 8:06 AM
To: '[EMAIL PROTECTED]'
Subject: RE: QoQ and Like
Nope, I checked that, and CFMX 6.1 does support the LIKE statement for QoQ
Hi Folks,
I'm encountering a problem with queries of queries and the like statement:
This works:
cfquery name=results dbtype=query
select *
from assets
WHERE STATUSID = 6
AND ASSETTYPEID = 1
AND WORKSTATIONNAME = 'abcd'
/cfquery
but this doesn't:
cfquery name=results dbtype=query
select
At 18:11 08/10/2003 -0400, you wrote:
I'm encountering a problem with queries of queries and the like statement:
Check MM docs for QofQ limitations - they don't do everything that straight
DB queries do. Sorting by date fields is one, maybe LIKE is another?
Gyrus
[EMAIL PROTECTED]
5 matches
Mail list logo