| Author |
 Replies: 52 / Views: 5,461 |
|
|
|
Pillar of the Community
 United States
7629 Posts |
Geesh...where were you guys this morning when I figured out that using a "SELECT DISTINCT" was completely useless when selecting the primary key - the item ID numbers. I had to figure out to select everything, then group by year, mint, grade, and die number. That solved the issue.
Another issue I quickly solved (while I was completely "logic lucid") was how to get the sort to correctly sort the mints by P, D, S - the way we assume all lists to be in coins. Of course when you do a natural "ORDER BY" it turns out as D, P, S - alphabetical. I simply created a little lookup table with IDs and mints in the order I wanted them, then did a LEFT JOIN by mintID and it worked like a champ. That killed about 20 lines of array multisort (grrr) code.
|
|
Pillar of the Community
United States
7629 Posts |
Okay, I officially take the "board robber" prize for the week. Two different threads I started this week went into burning status within an hour, and neither of them were asking or answering coin questions.
|
|
Valued Member
United States
402 Posts |
That was really nice of you coppercoins. Made alot of folks day.
|
|
Pillar of the Community
Canada
1161 Posts |
Goes to show how much people appreciate your efforts here on the forums. Just like E.F.hutton...when Chuck talks...people listen.  |
|
Pillar of the Community
United States
4897 Posts |
To paraphrase Liveanddie, Variety collectors are smarter than other people. So yeah when Chuck speaks we listen....LOL
|
|
Pillar of the Community
United States
7629 Posts |
I really don't think it's a "smarter" issue. Anyone who spends 30 years staring at pennies is BOUND to know something about them!
|
|
Pillar of the Community
United States
4000 Posts |
Yeah, I think all he meant was that the E/V collector has to know more about the minting process than the average year/mm collector.
|
|
Pillar of the Community
United States
2589 Posts |
Im sure there are some mint workers whove been staring at pennies for decades and hate them lol
|
|
Pillar of the Community
United States
4897 Posts |
Ok then how about more knowledgable....or at least more estute.
|
|
Moderator
 United States
56855 Posts |
Good job coppercoins. John1 |
|
Pillar of the Community
United States
900 Posts |
Quote:
Of course when you do a natural "ORDER BY" it turns out as D, P, S - alphabetical. I simply created a little lookup table with IDs and mints in the order I wanted them, then did a LEFT JOIN by mintID and it worked like a champ. That killed about 20 lines of array multisort (grrr) code.  Was that English? |
|
Pillar of the Community
United States
4085 Posts |
I'm embarrased to admit I understood every word he said! Nice work there, CD!  Edited by KenKat
04/08/2011 08:28 am
|
|
Valued Member
United States
355 Posts |
Quote:
All-right...I'm feeling especially generous today...but NO MORE after this post.
amida17, trent - you guys made it in by the skin of your teeth...I'm giving seven of these away now.
Send your addresses please. cd@coppercoins.com
Wow. I thought I missed out. I was the 4th reply when I hit the reply button. But then I was going to type some stuff about SQL assuming that post position is set when creating a post, not submitting a post. By the time I submitted there 6 extra replies before me. I though I lost. Thanks for being so generous! Oh, and the email has been sent. Edited by trent
04/08/2011 11:04 am
|
|
Valued Member
273 Posts |
Coppercoins, your lincolncent.com site is excellent. My compliments on having programming 'sense'.
|
|
Pillar of the Community
United States
4989 Posts |
Gets more fun when you start needing LEFT OUTER JOIN and RIGHT OUTER JOIN :)
Of course the trend is toward NO-SQL databases nowadays so start learning some map-reduce <grin>
|
| |
Replies: 52 / Views: 5,461 |
First Page
Previous Page
Posted 04/07/2011 10:07 pm
