Thanks for the site recommendation, I'll be sure to check it out :)
The "nested select" seems to work fine in access ... giving no error ... it
just doesn't return the right data :(
-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>
==============
> From: "McCollough, Alan" <[EMAIL PROTECTED]>
> Reply-To: [EMAIL PROTECTED]
> Date: Tue, 24 Oct 2000 08:10:59 -0800
> To: Fusebox <[EMAIL PROTECTED]>
> Subject: RE: ... should be a simple query question ...
>
> That's called a 'nested Select'. Ya can't do it in Access. Either that or
> I'm wrong again.
>
> Anyhow y'all would be wise to hop over to www.swynk.com , there are some
> serious SQL gurus over there...
>
> Alan McCollough
> Web Programmer
> Allaire Certified ColdFusion Developer
> Alaska Native Medical Center
>
>> -----Original Message-----
>> From: Jeffrey Marsh [SMTP:[EMAIL PROTECTED]]
>> Sent: Tuesday, October 24, 2000 8:18 AM
>> To: Fusebox
>> 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?
> {redacted uh huh...}
> ------------------------------------------------------------------------------
> 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.
