[thelist] DSL & Home Networking Q

Jon Haworth jhaworth at witanjardine.co.uk
Fri May 18 12:49:03 CDT 2001

I've got a very similar setup at home:

- Win2k box (main development use)
- NT4 server box (gateway)
- Slackware box (you *have* to have a Linux :-)

The Windows boxen are quite happy with each other, I haven't got around to
networking the Linux one yet but I'll probably have a go this weekend.

Set up your gateway box as having IP, and your other box as In the gateway and DNS settings for your 0.2 box, click on
"specify a server" and stick in there.

Should be OK :-)


-----Original Message-----
From: Luther, Ron [mailto:Ron.Luther at COMPAQ.com]
Sent: 18 May 2001 18:36
To: 'thelist at lists.evolt.org'
Subject: [thelist] DSL & Home Networking Q

Hi Gang,

It looks like I may have managed to convince my boss to foot the bill for
home DSL service ... and lend me a Win2k box. The paperwork is being
generated now. Hurray!


I have an ornery dual boot system, (Win98 / Mandrake), at home already. [The
Linux works great ... the Windows is a mess. (video driver and hard drive
architecture problems) I need to tear it down and redo it --- now I'll have
a chance!]

For those of you keeping score at home ... that's one DSL line and at least
2 machines ...

What am I gonna be needin' here folks?   A router?   NIC cards?   Cabling?
Other junk?

Any links for 'step-by-step' instructions to home DSL networking for the



(still doing his 'happy dance' over the news!)

<tip type="Oracle select statements">
Did you know that you can use 'case switching' logic in your select
statements?  It was news to me... but I just debugged one this morning.

[Yes - you can do this on the 'server-side language of your choice' side as
well ... and it might be easier to read that way ... but I'm thinking this
might be more efficient... making the db do the work.]

SELECT field1, field2, field3=CASE WHEN ISDATE(field7)=1 THEN
CONVERT(DATETIME,field22,103) WHEN field30 in ('xxx','yyy') THEN
table_a WHERE foo_field='bar' order by field2

{Above is a modified excerpt from a much longer statement that actually does

You can string 'and's and 'or's in there and all kind of fun stuff.

Warning - since this technique can be used on a field by field basis your
SQL strings can get really really long in a hurry... and become quite a pain
to debug.

For unsubscribe and other options, including
the Tip Harvester and archive of TheList go to:
http://lists.evolt.org Workers of the Web, evolt ! 

'The information included in this Email is of a confidential nature and is 
intended only for the addressee. If you are not the intended addressee, 
any disclosure, copying or distribution by you is prohibited and may be 
unlawful. Disclosure to any party other than the addressee, whether 
inadvertent or otherwise is not intended to waive privilege or


More information about the thelist mailing list