nerds only... how i spent my last 2 days

We may earn a small commission from affiliate links and paid advertisements. Terms

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.
 
can't....

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...
 
Back
Top