It sounds like what you really want is a web front end to the
database, and some simple SQL queries to replace the ID fields in one
table with the Description field in another. Perl, PHP and ASP will
happily interface with MSSQL or your database of choice.
To get a room description from the room ID, try something like:
SELECT boxes.description, rooms.description FROM boxes, rooms
WHERE boxes.room_id = rooms.id;
Hope this helps.
John P. Looney wrote:
>On Mon, Jul 12, 2004 at 10:34:29AM -0700, Rick Moen mentioned:
>>>>Quoting John P. Looney (valen at tuatha.org):
>>>>>>>>> It's nice, but in this case, I'm looking for a web skeleton that'll talk
>>>to an MSSQL server. Hmm. Maybe I'll write one :)
>>>>>>>>I should have paid greater attention to your requirements list, for
>>which lapse I apologise -- but do I guess correctly that phpmyadmin
>>doesn't suffice? It's often handy.
>>>>>> Well, i'm looking to make up a tool that'll allow multiple users manage
>multiple tables, all interlinked. A subset of it's functionality would be
>to let me have a list of servers, with their IPs/operating systems etc. on
>them. This would be linked to our IP address list, so you could find out
>what ips are on what boxes, or what IPs are allocated to any box. A third
>table would be a list of locations, so I could tell where boxes were.
>> So, I'd have three tables...
> boxes: id, room_id, description
> ips: id, number, netmask, box_id
> rooms: id, description
>> So, I want a screen that showed:
>> Box number $id:
> click here for IPs for box $i
>> etc. But, rather than seeing $room_id as "2", I'd want that to
>automatically show up as "upstairs", the description in the room table.
>I've done most of such a system, but I'm running into design problems
>making it as generic as possible (too many exceptions), and hoped someone
>else had surmounted such problems before.
Maintained by the ILUG website team. The aim of Linux.ie is to
support and help commercial and private users of Linux in Ireland. You can
display ILUG news in your own webpages, read backend
information to find out how. Networking services kindly provided by HEAnet, server kindly donated by
Dell. Linux is a trademark of Linus Torvalds,
used with permission. No penguins were harmed in the production or maintenance
of this highly praised website. Looking for the
Indian Linux Users' Group? Try here. If you've read all this and aren't a lawyer: you should be!