[ILUG] it must exist...

[Gareth Eason]

   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.

   Regards,
   -->Gar


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:
>        $room_id
>        $description
>        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.
>
>John
>  
>