Discussion in 'Computers, Games, Electronics etc' started by pissedoffsol, Jan 16, 2007.
SkeyMedia Â» Scripting Around Poor Table Design
no not you TurboMirage....all that hibbity hoo-blah that B posted in that article
simple, the answer is 42.
stoners crack me up
Bah, i wouldnt have done i woulda said fuck it and done it right. Im weird that way. I scrapped my entire website twice because i realized that my schema was jacked.
the table gets updated nightly from a 3rd party program. Changing it is not possible.
A complete software rewrite. Probably something the company doesn't want to spend extra bucks for.
Well it looks like simple tables. If it was me I would of made the thing more complicated than it has to be. I don't know much about ASP, I'm a PHP and MySql man here. I heard there almost alike but different in major ways. To me it looks like you created a 3rd table with a whole knew array so the software can run a reference to when it does a check on the price.
It works though, lets hope the server that up dates the DB doesn't screw up the other two arrays. I think a forth array would of helped that contained all the references from the first array. So if anything jumped positions during the update the software will recognize this and update the third and forth arrays to correct it.
the system runs on a 3rd party $200,000 enterprise e-commerce solution. There is no way for me to change it, and the client can't either. It's how the thing was built.
The tables are updated nightly via DTS, so i cannot touch the source table.
Perhaps a view would have been a better solution to use, but I don't need to limit permissions or anything on it, as the table in itself is pretty much meaningless...
Separate names with a comma.