Welcome to Ryan's Pin Trading Database. ANOTHER one.
- Messages
- 3,208
- Location
- Cork, Ireland
FYI, we have a name and logo for it.
Pin Trading Database
http://www.pintradingdb.com/
Thank you to those who designed the logo. We have approximately 12939 pins listed (the number count is off as far as when you add a pin because we had to delete duplicate entries and the numbers don't then re-set.)
Do you mean the pin number / ID on your site doesn't match the actual quantity of pins in the database? So, for instance, I could add the 13,000th pin, but its "ID" in your system might be 13267? Or something along those lines?
If the mismatch bugs you, you can go online and find a bunch of different SQL and/or LINQ solutions that will allow you to always assign the first unused record number in the db. This will have the effect of "filling in the holes" for now, and then once they're filled, your record # and pin # should be the same moving forward, until you need to delete records again, and then it'll fill the holes again and so on.
If it bugs you, that is
Nice job on the database... was not really aware of it until seeing this thread, so the bumps do help get us in there.
Does anyone know the fastest way to identify pins as owns/wants/trades in this database?
We use cookies and similar technologies for the following purposes:
Do you accept cookies and these technologies?
We use cookies and similar technologies for the following purposes:
Do you accept cookies and these technologies?