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:3219 Subscription: http://www.houseoffusion.com/groups/sql/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.6
