The select in the where clause being surrounded by parenthesis seems to work
fine in access.
Any ideas on how I can get this query to work?
-Russ
==============
I need this query to get all messages in a thread except the first message
that started it. What I have clearly does not work. I seems like it should,
but it doesn't.
<cfquery name="request.getMessageTaxonomy" datasource="#request.userdsn#">
SELECT m.*, m.MessageID AS ItemID, m.MessageParent AS ParentItemID
FROM Messages m
WHERE m.ThreadID = #attributes.ThreadID#
AND m.MessageDateCreated >= ALL
(
SELECT Min(m.MessageDateCreated)
FROM Messages m
WHERE m.ThreadID = #attributes.ThreadID#
)
ORDER BY m.MessageDateCreated ASC
</cfquery>
==============
> From: Jeffrey Marsh <[EMAIL PROTECTED]>
> Reply-To: [EMAIL PROTECTED]
> Date: Tue, 24 Oct 2000 09:17:52 -0700
> To: Fusebox <[EMAIL PROTECTED]>
> Subject: RE: ... should be a simple query question ...
>
> How come you have the SELECT statement in the WHERE clause surrounded by
> parenthesis without an AND conjunction? Does this query work from within
> Access?
>
> --
> Jeffrey B. Marsh
> Amateurs built the Ark.
> Professionals built the Titanic.
>
> -----Original Message-----
> From: Russell Jones [mailto:[EMAIL PROTECTED]]
> Sent: Monday, October 23, 2000 7:38 PM
> To: Fusebox
> Subject: ... should be a simple query question ...
>
> First off, I'm using Access 2000...
>
> I need this query to get all messages in a thread except the first message
> that started it. What I have clearly does not work. I seems like it should,
> but it doesn't.
>
> ==============
> <cfquery name="request.getMessageTaxonomy" datasource="#request.userdsn#"
> cachedwithin="#CreateTimeSpan(0,0,IIF(Flush,0,QueryCacheTime),0)#">
> SELECT m.*, m.MessageID AS ItemID, m.MessageParent AS ParentItemID
> FROM Messages m
> WHERE m.ThreadID = #attributes.ThreadID#
> AND m.MessageDateCreated >= ALL
> (
> SELECT Min(m.MessageDateCreated)
> FROM Messages m
> WHERE m.ThreadID = #attributes.ThreadID#
> )
> ORDER BY m.MessageDateCreated ASC
> </cfquery>
> ==============
>
> I know I could cut out the first record with CF when I output it, but I'd
> like to do it in the query because I know it can be done.
>
> Are there any giving experts out there to answer my cry for help?
>
> Thanks.
>
> -Russ
>
> ----------------------------------------------------------------------------
> --
> To Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/fusebox or
> send a message to [EMAIL PROTECTED] with 'unsubscribe' in
> the body.
> ------------------------------------------------------------------------------
> To Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/fusebox or
> send a message to [EMAIL PROTECTED] with 'unsubscribe' in the
> body.
>
------------------------------------------------------------------------------
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/fusebox or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
