How about changing ">=" to just ">"?
-David
On Tue, 24 Oct 2000 00:05:13 -0400 Russell Jones <[EMAIL PROTECTED]>
writes:
> Hmmm ... do you think it has something to do with
> "m.MessageDateCreated >=
> ALL" being a date field? I'm not sure. I can't find very goo d
> documentation
> onthe rules of SQL. Can someone recommend a website?
>
> please :(
>
> -Russ
>
>
-------------------------------------------------------------------------
> 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
________________________________________________________________
YOU'RE PAYING TOO MUCH FOR THE INTERNET!
Juno now offers FREE Internet Access!
Try it today - there's no risk! For your FREE software, visit:
http://dl.www.juno.com/get/tagj.
------------------------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message
with 'unsubscribe' in the body to [EMAIL PROTECTED]
