TIP: Click on subject to list as thread! ANSI
echo: bbs_carnival
to: Jame Clay
from: Carol Shenkenberger
date: 2010-11-25 14:31:26
subject: SQL related...

> > Yeah, the logic is the same but the usage differs a bit.  What I see from
 > > reading about, is we can generally figure out one another and ajust althou
 > > nested selects can get a little hairy.
 > 
 >     Besides any separate test databases I might create (and I'm sure I've se
 > reference to scripts for creating such things...), I'm thinking of adding
 > another table to the nodelist database I'm already working with.  Specifical
 > one for DNS related info.  Have the zone/net/node/point fields in that table
 > well, and can then do joins on that.  One thing I would take into account is
 > that there could be multiple entries for a particular node in the DNS relate
 > table...   (A & AAAA, for instance, not that IPv6 is being used
much yet...)

Definately 1 tables needed to handle it at minimum. Pkey will be the issue to
make it easier so you'd add to a full nodenumber (4d likely bet).  Add a
possible populated 5d {at}netname to the initial set and you have a generatable
key set with the + that covers more than fidonet.  substrib(15,4) sounds
right to hndle the INA but you'd need to NVL or coalesce for null values?

Just catching up with messages.  We've been busy with our new rescue pup. 
Mabel Anne.

http://www.beaglestotherescue.org/mabelanne.cfm

She came home with us last Saturday and it getting along well with all here.
      xcarol
--- SBBSecho 2.11-Win32
* Origin: SHENK'S EXPRESS (1:275/100)
SEEN-BY: 10/1 11/200 331 14/250 400 18/200 34/999 120/228 123/500 128/2 187
SEEN-BY: 140/1 222/2 226/0 230/150 249/303 250/306 261/20 38 100 1381 1404
SEEN-BY: 261/1410 1411 1418 266/1413 280/1027 320/119 396/45 633/104 260 267
SEEN-BY: 633/285 690/682 734 712/848 800/432 801/161 189 2320/105 200 303
SEEN-BY: 5030/1256
@PATH: 275/100 140/1 261/38 633/260 267

SOURCE: echomail via fidonet.ozzmosis.com

Email questions or comments to sysop@ipingthereforeiam.com
All parts of this website painstakingly hand-crafted in the U.S.A.!
IPTIA BBS/MUD/Terminal/Game Server List, © 2025 IPTIA Consulting™.