> How do I use a url variable to link to a property details > page when the properties are in 8 different tables? The > issue really isn't the variable, since I can use the aliased > variable "property_id" (once I add it to the query). > > I know I could use > property_details.cfm?property_id=<cfoutput>#get_properties.pro > perty_id#</cfoutput>, > however, on the details page, I would need to search all > eight property tables for the correct property id. > > Is this the method I'm stuck with because all the properties > aren't in a single table? > Pass the aliased variable "property_id" and search all 8 > tables for it? > > Perhaps I should just put them all into one big property > table instead of keeping them separate as the data vender has > them...
Are all these tables identically constructed? That's what it looks like from the query. If so, I can't imagine why the vendor would tell you to do that. Did the vendor explain this to you? What database server are you using? How many records are we talking about? Are the tables properly indexed? Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Training: Adobe/Google/Paperthin Certified Partners http://training.figleaf.com/ WebManiacs 2008: the ultimate conference for CF/Flex/AIR developers! http://www.webmaniacsconference.com/ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:304126 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4