> If I did that for the "commercial properties" table, then I'd have a 
> property_type
> field in each property table that I could add to the url link and pass to the
> property details page to specify which table to search for the property.

I don't think you would need to add the property type field. The table
is the property type right? So, when you select from a given table,
you can just select a string to represent the property type:

SELECT   sa.*,
               'acr' as propertyType
FROM     smlc_acr sa

UNION ALL

SELECT  sc.*,
              'com' as propertyType
FROM    smlc_com sc

etc

(I only put the select * for readability in this example).

HTH

Dominic

-- 
Blog it up: http://fusion.dominicwatson.co.uk

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
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:304151
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Reply via email to