[ILUG] it must exist...
bigbro at skynet.ie
Tue Jul 13 11:16:59 IST 2004
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.
More information about the ILUG