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.
