That will probably work ...
I always make queries more complicated than they need to be.
thanks! :)
-Russ
--
Russell Jones
Webmaster
ImproveNow.com
Phone: 207.236.0146
e-mail: [EMAIL PROTECTED]
> From: Bert Dawson <[EMAIL PROTECTED]>
> Reply-To: [EMAIL PROTECTED]
> Date: Tue, 24 Oct 2000 19:50:44 +0100
> To: Fusebox <[EMAIL PROTECTED]>
> Subject: RE: ... should be a simple query question ...
>
> Well dunno then, I just created a table in Access 2000, and ran:
> SELECT *
> FROM my_table
> WHERE date > (SELECT MIN(date)
> FROM my_table);
> and it worked fine.
>
> When you say "That just screws up the query" what actually happens?
>
> Bert
>
> -----Original Message-----
> From: Russell Jones [mailto:[EMAIL PROTECTED]]
> Sent: 24 October 2000 18:26
> To: Fusebox
> Subject: Re: ... should be a simple query question ...
>
>
> Thanks Bert, I've tried that though. That just screws up the query.
>
> -R
>
> ==============
> 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>
> ==============
>
> --
> Russell Jones
> Webmaster
> ImproveNow.com
> Phone: 207.236.0146
> e-mail: [EMAIL PROTECTED]
>
>> From: Bert Dawson <[EMAIL PROTECTED]>
>> Reply-To: [EMAIL PROTECTED]
>> Date: Tue, 24 Oct 2000 18:13:23 +0100
>> To: Fusebox <[EMAIL PROTECTED]>
>> Subject: RE: ... should be a simple query question ...
>>
>> I don't really know access, but maybe you want to drop the '=' sign from
> the
>> condition:
>> ie
>> AND m.MessageDateCreated > ALL
>> (
>> SELECT Min(m.MessageDateCreated)
>> etc
>>
>> Bert
>>
> ------------------------------------------------------------------------------
> 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.
