The O&M databse

[Softpaw]

Holy crap O.O

[Tavis]

<!--QuoteBegin-FelixSoftpaw+Nov 13 2005, 09:35 AM--> <table border='0' align='center' width='95%' ><tr><td class='quotetop'><b>Quote:</b> (FelixSoftpaw @ Nov 13 2005, 09:35 AM)</td></tr><tr><td class='quotebody'> Holy crap O.O <!--QuoteEnd--> </td></tr></table> <!--QuoteEEnd--><br> Seconded. O.O

[Mista_B]

Ahaha, Richard K Niner = win!

[norsenerd]

I woudl be happy if this fight would just drop. Either apreciate what I've done or don't but stop tryign to arguee with me over this. I'm nto itnerested in it and it's gettign on my nerves.

[Zaaphod]

I appreciate it norse, even if others don't. <!--emo&:)--><img src='http://definecynical.mancubus.net/forum ... /smile.gif' border='0' style='vertical-align:middle' alt='smile.gif' /><!--endemo--><br>

[norsenerd]

Thank you Zaaphod.

[Gizensha]

<!--QuoteBegin-Richard K Niner+Oct 27 2005, 03:17 PM--> <table border='0' align='center' width='95%' ><tr><td class='quotetop'><b>Quote:</b> (Richard K Niner @ Oct 27 2005, 03:17 PM)</td></tr><tr><td class='quotebody'> Umm... Access is just a database. Excel is a spreadsheet. As such, Access is capable of smaller sizes.<br>And here are some things you can do in Access that are not in Excel:<ul><li>User-based securty</li><li>ODBC</li><li>OLE DB (using the Microsoft Jet driver)</li><li>Transformations to other, faster databases</li><li>Server-side HTML rendering, allowing anybody to view it (even those who don't have Microsoft Office), without requiring a copy of said software product in the first place.</li></ul> <!--QuoteEnd--> </td></tr></table> <!--QuoteEEnd--><br> Not to mention 'elimination of update and deletion anomalies'.

[Steve the Pocket]

I'm wondering ... is there perhaps a way to make a "searchable database" where you can enter data in a <FORM> and get a page of results? I believe Kevin and Kell has a search tool that even lets you search by keywords and dialogue. It would be awesome if we could come up with something like that.<br><br>*wishes he knew PHP and MySQL*

[Gizensha]

PHP front end to a... Hell, even an access database should be able to manage it. As long as you don't need to do the type of join in SQL that access doesn't know how to do, that is... And I can't remember which type that is.

[Richard K Niner]

The CROSS JOIN? It isn't even in the SQL2003 standard. <!--emo&:P--><img src='http://definecynical.mancubus.net/forum ... tongue.gif' border='0' style='vertical-align:middle' alt='tongue.gif' /><!--endemo-->

[Tavis]

Anyway.... all this database/spreadsheet talk aside, this was definitely the result of a lot of effort in painstakingly gathering data on all of the O&M strips in the archive up to its creation. Let's not downplay that over semantics and technicalities.<br><br>If someone wants to make a database from it, ask Norsenerd if you may collaborate with him on it. Or make your own database. I'd like to see what other reference material could be produced on this stuff.

[Arloest]

/me is still trying to figure out what was so "Holy Crap" about that...

[Softpaw]

It was an exceptionally complex SQL database query, which was probably typed from scratch (without copy & paste from something else), thus making RKN the database god <!--emo&:P--><img src='http://definecynical.mancubus.net/forum ... tongue.gif' border='0' style='vertical-align:middle' alt='tongue.gif' /><!--endemo-->

[Arloest]

...wow! Yeah, ok. ^^

[Richard K Niner]

Eh, it was needlessly complex. All it said was "get me the links to the strips with exactly 3 characters in them".