<cfdbinfo type="columns" table="yourtable" datasource="yourDSN"
name="dbdata">
<cfquery name="getfk" dbtype="query">
SELECT REFERENCED_PRIMARYKEY, REFERENCED_PRIMARYKEY_TABLE
FROM dbdata
WHERE IS_FOREIGNKEY = 'YES'
</cfquery>
<cfdump var="dbdata">
<cfdump var="getfk">
On Tue, Mar 18, 2008 at 11:11 AM, Richard White <[EMAIL PROTECTED]> wrote:
> > You can look it up in the DB schema, from SQL. On CF8 the new DB info.
> > stuff
> > might help too.
>
> do you have any idea where i can find the info on the new dbinfo tag. all
> i can seem to find is articles saying its new in coldfusion 8 but cant find
> nothing about how to use it etc...
>
> thanks
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:301524
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
