Gossamer Forum
Home : Products : DBMan SQL : Discussion :

Re: [jean] Build select menu from other table

Quote Reply
Re: [jean] Build select menu from other table In reply to
Aha! Now I see. I keep trying to bypass the web interface, but it works like a charm they way you showed me. I'm really starting to like DBSQL!Smile

Still, it's unfortunate that the only way to manage these automatically generated select menus is through the browser. I'll be dealing with about 15 different menus, and it would be nice to manage the code in an editor. It appears the program doesn't store these globals in any of the ASCII files, but instead it writes them to a binary file (or files) within the /var/lib/mysql/name_of_database directory. At least that's the path on my machine. If there's another way to manage the globals, please let me know.

Uh-oh. It suddenly occurs to me that I need to build these menus using queries to another field, contact_type, in my contacts table. That way, I can have all the lawyers appear in one select menu, all the borrowers in another menu, etc.

It's probably easy if you only need one menu and one query, but I bet you're going to tell me it gets complicated to generate multiple menus built with multiple queries on one page, right? Thanks again for all your great help. Sorry to be such a bother...
Subject Author Views Date
Thread Build select menu from other table Halito 5344 Mar 1, 2002, 10:05 AM
Thread Re: [Halito] Build select menu from other table
jean 5212 Mar 1, 2002, 11:00 AM
Thread Re: [jean] Build select menu from other table
Halito 5221 Mar 2, 2002, 10:26 AM
Thread Re: [Halito] Build select menu from other table
jean 5243 Mar 2, 2002, 11:12 AM
Post Re: [jean] Build select menu from other table
Halito 5199 Mar 3, 2002, 10:46 AM
Post Re: [Halito] Build select menu from other table
LanceWilson2 4944 Mar 5, 2003, 3:07 PM