Have you tried to use "distinct"? --- On Sat, 5/23/09, Scott Doc <[email protected]> wrote:
From: Scott Doc <[email protected]> Subject: Re: Top N rows not working - Access / CF7 To: "sql" <[email protected]> Date: Saturday, May 23, 2009, 9:22 PM I spoke too soon. I was wrong. It STILL doesn't work. I was testing with a maxrows="200" (my query returns roughly 2000 rows) NOW it returns two rows, regardless of if they are the same or not. It's like it just ignores the "TOP 1" (I also tried putting the 1 in quotes "Top (1)" .. that was a syntax error) This is my error message.. please help! Diagnostic: Error Executing Database Query. [Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft Access Driver] At most one record can be returned by this subquery. The error occurred on line 307. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/sql/message.cfm/messageid:3221 Subscription: http://www.houseoffusion.com/groups/sql/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.6
