>OK, you asked for it :o) -- the select statement was my latest try at
>retrieving just the highest numbered transaction ID and corresponding data
>for each member. FYI - the filtering statements are only invoked after
>someone does a new search from a form. The inital results, which is what I
>am after, uses the <cfcase value = "all fields">. The default URL.sortorder
>is "M.lastname" and URL.sortDir is "ASC".
>
>
>Thanks for helping me with this.
Can you post the actual, parsed SQL that is being executed against your DB?
This will be a little easier to troubleshoot with all of the variables and such filled in...
Thanks!
--
Ale
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
