[thelist] DSL & Home Networking Q

[Luther, Ron]

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
hardware-impaired?


Thanks,

RonL.

(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
CONVERT(DATETIME,field90,103) ELSE CONVERT(DATETIME,field92,103) END from
table_a WHERE foo_field='bar' order by field2

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

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.
</tip>