Re: [Phpmyadmin-devel] foreign key on external database

Hi Isart,

what I've done is not in phpMyAdmin, it's for a project at my job. Let me verify how I could help you.

Marc

Isart Montane a écrit :

Thanks marc, where can I get this code? I've run a few grep on the code and couldn't find it

On Mon, Jun 15, 2009 at 11:38 AM, Marc Delisle <marc@infomarc.info mailto:marc@infomarc.info> wrote:

Hi Isart,
I've done something similar with Ajax. Also you should display a submit
button to trigger the update of the tables dropdown when javascript is
disabled in the browser.

Marc

Isart Montane a écrit :
 > Hi guys,
 >
 > If I add a new dropdown with the databases, the table dropdown
should be
 > updated when the database dropdown changes. Any suggestion on how
to do it?
 >
 >    1. Add the table dropdown on an iframe and reload it when the
 >       database dropdown changes (javascrpt)
 >    2. Ajax
 >    3. Others?
 >
 > Thx!
 > Isart
 >
 > On Sat, Jun 13, 2009 at 9:11 PM, Isart Montane
<isart.montane@gmail.com <mailto:isart.montane@gmail.com>
 > <mailto:isart.montane@gmail.com
<mailto:isart.montane@gmail.com>>> wrote:
 >
 >     My idea is to add it as a dropdown in the relational view. I will
 >     take a look at the designer page as well and see if I can do
both.
 >
 >
 >     On Fri, Jun 12, 2009 at 12:04 PM, Marc Delisle
<marc@infomarc.info <mailto:marc@infomarc.info>
 >     <mailto:marc@infomarc.info <mailto:marc@infomarc.info>>> wrote:
 >
 >         Isart Montane a écrit :
 >          > Hi all,
 >          >
 >          > For a personal project I need to create foreign keys
between
 >         different
 >          > databases. I've realised that phpmyadmin only allows
foreign
 >         keys on the
 >          > same db so I'm thinking on develop this feature.
 >          >
 >          > I know it's not a very good practice to create foreign
keys
 >         on different
 >          > databases... but I need it anyway...
 >          >
 >          > Any comments or guidelines to do it?
 >          >
 >          > Thanks,
 >          > Isart
 >          >
 >
 >         Hi Isart,
 >         good initiative! Are you thinking of implementing this in
 >         Relation View
 >         or the Designer page or both?
 >
 >         On Relation View, we could think of a database drop-down,
even
 >         if this
 >         can pose a problem with too many databases -- but we already
 >         have this
 >         problem at other places where we have such drop-down.
 >
 >         --
 >         Marc Delisle
 >         http://infomarc.info
 >
 >        
------------------------------------------------------------------------------
 >         Crystal Reports - New Free Runtime and 30 Day Trial
 >         Check out the new simplified licensing option that
enables unlimited
 >         royalty-free distribution of the report engine for
externally facing
 >         server and web deployment.
 >         http://p.sf.net/sfu/businessobjects
 >         _______________________________________________
 >         Phpmyadmin-devel mailing list
 >         Phpmyadmin-devel@lists.sourceforge.net
<mailto:Phpmyadmin-devel@lists.sourceforge.net>
 >         <mailto:Phpmyadmin-devel@lists.sourceforge.net
<mailto:Phpmyadmin-devel@lists.sourceforge.net>>
 >         https://lists.sourceforge.net/lists/listinfo/phpmyadmin-devel
 >
 >
 >
 >
 >
------------------------------------------------------------------------
 >
 >
------------------------------------------------------------------------------
 > Crystal Reports - New Free Runtime and 30 Day Trial
 > Check out the new simplified licensing option that enables unlimited
 > royalty-free distribution of the report engine for externally facing
 > server and web deployment.
 > http://p.sf.net/sfu/businessobjects
 >
 >
 >
------------------------------------------------------------------------
 >
 > _______________________________________________
 > Phpmyadmin-devel mailing list
 > Phpmyadmin-devel@lists.sourceforge.net
<mailto:Phpmyadmin-devel@lists.sourceforge.net>
 > https://lists.sourceforge.net/lists/listinfo/phpmyadmin-devel


--
Marc Delisle
http://infomarc.info

------------------------------------------------------------------------------
Crystal Reports - New Free Runtime and 30 Day Trial
Check out the new simplified licensing option that enables unlimited
royalty-free distribution of the report engine for externally facing
server and web deployment.
http://p.sf.net/sfu/businessobjects
_______________________________________________
Phpmyadmin-devel mailing list
Phpmyadmin-devel@lists.sourceforge.net
<mailto:Phpmyadmin-devel@lists.sourceforge.net>
https://lists.sourceforge.net/lists/listinfo/phpmyadmin-devel

---

---

Crystal Reports - New Free Runtime and 30 Day Trial Check out the new simplified licensing option that enables unlimited royalty-free distribution of the report engine for externally facing server and web deployment. http://p.sf.net/sfu/businessobjects

---

---

Phpmyadmin-devel mailing list Phpmyadmin-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/phpmyadmin-devel