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

Carol,

> The problem with SQL is that folks do not list in the same order and
> SQL is very 'driven' by that.

   Which is why I consider, for instance, doing a query for data and using that
data as separate issues.  Not sure, though, how useful the order info in a
nodelist is...  (Although that does remind me that I don't think that nodes
underneath a hub is being properly reflected in the database, with the
ftndbpl-nodelist script as it is now...)


> The primary part is in order, but once you get after the 'phone field'
> all bets are off.

   I think, rather, the baud rate field;  but yes that can be an issue.  It's
why I think I'd try processing the flag field into a hash (associative
array) and then get the more specific info being looked for.  Just use an
SQL query to get a set of records for a particular flag, like IBN, then do
the rest of the processing from there.  
   
    

> BTW, the battlenet nodelist is pretty small and makes a decent testing
> ground.  Not but about 25 nodes in there if you want a sample one to use.
> Email or netmail me for a copy. email is cshenk1{at}cox.net

     Well, I wouldn't mind having it also;  particularly if it's one you're
using.   (Not as easy to compare what we're doing if we're not using the same
dataset...)  






Jame
jame{at}rocasa.us
rjclay{at}gmail.com


--- BBBS/LiI v4.01 Flag
* Origin: Rocasa BBS (1:120/546)
SEEN-BY: 3/0 633/267 640/954 712/0 313 550 620 848
@PATH: 120/546 544 140/1 261/38 712/848 633/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™.