Thanks, Will... I've decided to just merge all the property data from the two databases into one massive property table. I'm going to incorporate a "source field", as well, with the data for that field specifying the data vendor. I need that if for no other reason because each vendor supplies much data that is different from the other and I have to adjust the display depending on the vendor. :oP
While merging the databases is huge headache in the beginning, I'm hoping it will simplify all manner of queries, especially the "search by many various parameters" query, and perhaps speed up the queries, too. Utilizing data from two different vendors with little consistency between the schemas has been the biggest pain in the rear I've come across. I going to charge $50,000+ the next time someone calls on me to do merge two vendors' data into a single active database. And to have to do it daily, to boot! Once I get it all automated with scheduled tasks it won't be a problem, hopefully. But, this has taken waaaaaay too much time! I should have contracted this project by the hour... Rick > -----Original Message----- > From: Will Tomlinson [mailto:[EMAIL PROTECTED] > Sent: Sunday, May 18, 2008 7:36 PM > To: CF-Talk > Subject: Re: How do I use "order by" for this? > > >Well... I can't figure out how to use the "order_by" column > >I've put into each real estate office table. > > > >Let's say (to make this simpler) that I've got six tables. > > > >1 - hmls_offices > >2 - hmls_lots > >3 - hmls_homes > > > >4 - smlc_offices > >5 - smlc_lots > >6 - smlc_homes > > > > It looks like you don't have the tables right. > > If it were me, I'd have a listingtypes table. > Types are hmls, smlc > > Then you can use an offices table, linking it to the types table. Then do the > same with lots and homes. > > my .02 at first glance. > > Will > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:305586 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
