To LUGNET HomepageTo LUGNET News HomepageTo LUGNET Guide Homepage
 Help on Searching
 
Post new message to lugnet.admin.databaseOpen lugnet.admin.database in your NNTP NewsreaderTo LUGNET News Traffic PageSign In (Members)
 Administrative / Database / *515 (-20)
  Re: Unique keys for sets
 
(...) No, the primary keys in that DB haven't changed since they were first created in April of 1998. When the DB is reborn out of its current form and into its new form, the old keys will be obsolete, but there will be a backward compatible (...) (25 years ago, 28-Dec-99, to lugnet.admin.database)
 
  Re: Unique keys for sets
 
A few minutes ago, I posted: (...) But... hm. A possible problem with documenting the key is that the unique key used in the Pause database appears to change over time. If TLC were to come out with another set numbered 8880, what would the keys be (...) (25 years ago, 27-Dec-99, to lugnet.admin.database)
 
  Unique keys for sets
 
Would it possible and reasonable to add a unique key to the Pause database setlists? In effect, to add another column to: (URL) the related lists. I've got a fairly hairy spreadsheet that I use to keep track of my sets. I use the Pause database as a (...) (25 years ago, 27-Dec-99, to lugnet.admin.database)
 
  Re: Missing Information from Db
 
(...) Thanks, Craig! --Todd (25 years ago, 21-Dec-99, to lugnet.admin.database)
 
  Missing Information from Db
 
Hi all, I was creating a local db of my collection (which included adding all set information since 1980...right now I don't plan on collecting anything earlier than that) and ran across some missing piece counts that can be found in the current (...) (25 years ago, 21-Dec-99, to lugnet.admin.database)
 
  Re: Do you like monorails?
 
Ouch, Toys R Us stuck me for more than MSRP! (...) (25 years ago, 16-Dec-99, to lugnet.admin.database)
 
  Re: Do you like monorails?
 
The Pause 'Price' appears to be in US$. Likewise I suspect that this is the US MSRP. Does TLC have MSRPs for countries other than the US ? Should we care about those numbers ? Ray (...) (25 years ago, 16-Dec-99, to lugnet.admin.database)
 
  Re: Do you like monorails?
 
(...) MSRP --Todd (25 years ago, 16-Dec-99, to lugnet.trains, lugnet.admin.database)
 
  Missing sets uploaded - 1977, 1032, 9604
 
I uploaded some sets which are missing from the database. ftp.lugnet.com/incom...g/dropbox7 files are 1977f.jpg, 1032.jpg, 1033.jpg, and 9604.jpg Information on each: 1977 copyright 1983 Legoland Space System value pack containing 6801, 6822, and (...) (25 years ago, 14-Dec-99, to lugnet.admin.database, lugnet.space, lugnet.dacta)
 
  Re: Help: Re: review: LEGO '99
 
(...) It would sure be a win for the S@H phone specials postings! :) --Todd (25 years ago, 14-Dec-99, to lugnet.admin.general, lugnet.admin.database)
 
  Re: Help: Re: review: LEGO '99
 
(...) I didn't know that. But the pause database already comes up with a list of sets when there's more than one. Might not an improvement to the database be to add sets with letters or leading zeros to the list? You can pick out which one you (...) (25 years ago, 14-Dec-99, to lugnet.admin.general, lugnet.admin.database)
 
  Re: Help: Re: review: LEGO '99
 
(...) ^^^^^ I mean: "admit" Sometimes I really hate touch-typing finger-memory! I had just typed lugnet.admin.database... :-/ --Todd (...) (25 years ago, 14-Dec-99, to lugnet.admin.general, lugnet.admin.database)
 
  Re: Help: Re: review: LEGO '99
 
(...) Actually, adding leading zeros would be worse. There are many cases of sets with the same integer number but with different leading-zero number-names. For example, there are at least two different sets numbered "20" and at least one set (...) (25 years ago, 14-Dec-99, to lugnet.admin.general, lugnet.admin.database)
 
  Re: Thumbnail images (was: Re: FreeNetnames comes up trumps!)
 
(...) I din't personally I think Selcuk Gore did, I read a post in admin.general I believe which states what Selcuk had uploaded. (...) I thought as much, it's just that I keep getting lists of service packs by set number that can be bought but (...) (25 years ago, 13-Dec-99, to lugnet.admin.database)
 
  Duplo 2694 'Farm'
 
Todd, Please add this entry to the Pause set database, all information was gathered from the box. Name: 'Farm' Set number: 2694 Theme: Duplo Price: $40 Piece count: 43 (C) date: 1996-1997 Thanks, Ray Sanders (25 years ago, 8-Dec-99, to lugnet.admin.database, lugnet.duplo)
 
  Re: 2000 Dealer catalogue Removal Request Backfire?
 
(...) (leaping out of bed to follow-up on this) Wait a second. The pictures that went in *were* legitimate consumer catalog photos -- from the sheet catalog/brochure someone got in a copy of a Technic set at a store in the UK, and from one other. (...) (25 years ago, 8-Dec-99, to lugnet.off-topic.debate, lugnet.admin.database)
 
  Re: 2000 Dealer catalogue Removal Request Backfire?
 
(...) I think you would be wasting your time there, Todd. I'm sure that TLC employees would rather spend their time by trying to make more money and by further juniorizing those sets and themes that are still decent rather than spending hours or (...) (25 years ago, 8-Dec-99, to lugnet.admin.database)
 
  Re: 2000 Dealer catalogue Removal Request Backfire?
 
(...) So that's why no-one responded to my WTB request for 6500 :) -- Jonathan Wilson wilsonj@xoommail.com (URL) (25 years ago, 8-Dec-99, to lugnet.admin.database)
 
  Re: 2000 Dealer catalogue Removal Request Backfire?
 
(...) Maybe what we should do is this: I could print a list of all the sets and set numbers we know about, and send that to someone at LEGO, and ask them to send it back with any set numbers crossed out that they felt weren't appropriate to appear (...) (25 years ago, 8-Dec-99, to lugnet.admin.database)
 
  Re: 2000 Dealer catalogue Removal Request Backfire?
 
Todd Lehman <lehman@javanet.com> wrote in message news:FMEzxF.Au8@lugnet.com... (...) the (...) intended (...) leaks (...) lines (...) I'm with the second one completely, although it is fun to watch the rumours and "spy works" around..:-) Actually (...) (25 years ago, 8-Dec-99, to lugnet.admin.database)


Next Page:  5 more | 10 more | 20 more

Redisplay Messages:  All | Compact

©2005 LUGNET. All rights reserved. - hosted by steinbruch.info GbR