RE: QoQ and Like

2003-10-09 Thread Kola Oyedeji
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

RE: QoQ and Like

2003-10-09 Thread Suyer, Ed [PRD Non-JJ]
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]

RE: QoQ and Like

2003-10-09 Thread Suyer, Ed [PRD Non-JJ]
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

QoQ and Like

2003-10-08 Thread Suyer, Ed [PRD Non-JJ]
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

Re: QoQ and Like

2003-10-08 Thread Gyrus
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]