how and where is that url/link generated? can you also pass the property type in the url? that can tell you which table to query...
Azadi Saryev Sabai-dee.com http://www.sabai-dee.com/ Rick Faircloth wrote: > Now's here's a new problem I haven't encountered. > > 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.property_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... > > Thoughts? > > Thanks, > > Rick > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:304133 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4