I've used Reactor on SQL 2000 and 2005 and never seen this issue so I suspect something else is going on, but I have no idea what it could be. My advice would be to take that query for the fields and see if you can do anything with it to eliminate the duplicate fields in the result set. Try DISTINCT. Try other conditions in the where clause. This is really the only way to figure out why you are getting duplicates.
Also, just for fun, are there other versions of these tables in the same database but perhaps in another schema?
On 11/9/06, Tom McNeer <
[EMAIL PROTECTED]> wrote:
Hi Brian,
I'm using MS SQL Server 2000, with all service packs.On 11/8/06, Brian Kotek < [EMAIL PROTECTED] > wrote:Also, if all the data in the query is the same, would it be enough to just add DISTINCT to the select statement as a stopgap measure? Does adding DISTINCT eliminate the duplicates?
If you mean adding a DISTINCT attribute on the query in the base ObjectDAO, it probably does. I'm just loathe to change any of the Reactor code. In case I haven't been clear, this is not a terribly pressing issue. I wrote a query to gather the info I need from this table that avoids the Reactor object.
I'm simply trying to explore whether this is something that needs to be addressed by Doug or others contributing to the Reactor codebase. Perhaps your suggestion of a DISTINCT attribute in ObjectDAO is appropriate. I just don't want to be the one to do it. Seems like we should find the underlying reason why this is happening.
As I mentioned earlier, when I have a little more time, I'll start working through the table, a piece at a time, to see if I can discover what's causing Reactor to duplicate the fields.
Thanks very much for your suggestions.
--
Thanks,
Tom
Tom McNeer
MediumCool
http://www.mediumcool.com
1735 Johnson Road NE
Atlanta, GA 30306
404.589.0560
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
Reactor for ColdFusion Mailing List
[email protected]
Archives at: http://www.mail-archive.com/reactor%40doughughes.net/
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
Reactor for ColdFusion Mailing List
[email protected]
Archives at: http://www.mail-archive.com/reactor%40doughughes.net/
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
