Can you do it with ColdFusion then? I mean the subquery? select * from table where mydate = #dateQuery.maxDate#
> -----Original Message----- > From: Andy Matthews [mailto:[EMAIL PROTECTED] > Sent: Wednesday, May 31, 2006 2:05 PM > > I don't have access to subqueries. We're running an old > version of mySQL. > > -----Original Message----- > From: Munson, Jacob [mailto:[EMAIL PROTECTED] > Sent: Wednesday, May 31, 2006 2:58 PM > > > How about something like: > select * from table > where mydate = (select top 1 mydate from table order by mydate desc) > > > -----Original Message----- > > From: Andy Matthews [mailto:[EMAIL PROTECTED] > > Sent: Wednesday, May 31, 2006 1:48 PM > > > > Ooops... > > > > I stand corrected. That idea is what I need, but I have to > > return EVERY row > > that has that date. There could be thousands of rows, and I > > need all of > > them. This transmission may contain information that is privileged, confidential and/or exempt from disclosure under applicable law. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or use of the information contained herein (including any reliance thereon) is STRICTLY PROHIBITED. If you received this transmission in error, please immediately contact the sender and destroy the material in its entirety, whether in electronic or hard copy format. Thank you. A1. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:241866 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
