 | | Re: Unique keys for sets
|
|
(...) Oya definitely. I didn't mean overwriting one of the existing ones, sorry for the confusion. There are 8 columns now, so the new one would make sense either at 1 (first), 2 (first), or 9 (last). IMHO, it makes the most sense in column 1, but I (...) (25 years ago, 28-Dec-99, to lugnet.admin.database)
|
| |
| | Re: Unique keys for sets
|
|
Separate column please, don't make me parse it out of an existing one.. that's my opinion. As to what the keys are, I don't care, just as long as they are unique. However, as I have pontificated before, you are right. The primary key should be (...) (25 years ago, 28-Dec-99, to lugnet.admin.database)
|
| |
| | Re: Missing sets uploaded - 1977, 1032, 9604
|
|
(...) ow, ow, bittersweet! :-) Question: Where is the number 1977 shown? (I don't see it on the scan.) How do we know that the value pack's official number is 1977, in other words? (...) The copyright on 1033 is also (c)1985 then? Do you know if (...) (25 years ago, 28-Dec-99, to lugnet.admin.database, lugnet.space, lugnet.dacta)
|
| |
| | Re: Unique keys for sets
|
|
(...) Ok, I can stuff those in one of the columns. Are they most helpful in column 1, 2, or 9? --Todd (25 years ago, 28-Dec-99, to lugnet.admin.database)
|
| |
| | Re: Unique keys for sets
|
|
Todd, I guess what several of us want is for those keys (regardless of whether they should be seen by humans or not) to appear in the Pause listings. Many (?) of us use the Pause listings to generate tables in our own databases and then use that for (...) (25 years ago, 28-Dec-99, to lugnet.admin.database)
|
| |
| | 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)
|
