> 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
