Delete Multi-point Duplicates from MySQL | ||
Given a table like tx_example_domain_model_resourcelocalized, some localization entries are duplicated for whatever reason. An easy way to clean them out is using SQL as shown below. Our magic to this SQL starts with the JOIN command. In particular, INNER JOIN helps us insist upon a one-to-one relation between database table records. Next, we use WHERE […] | ||
Category Archives / Tech
A place to share the stuff other than that about servers, travel, TYPO3, and WordPress.
Why Switch to TYPO3? A Mini-Case Study of a Site Migration | ||
There are many reasons to switch to a content management system, particularly TYPO3. Here is one mini-case study about how a move to TYPO3 saved a company money and drastically improved their ability to make timely updates and changes to their web site. Who: High tech company that develops and deploys software for enterprise level […] | ||
phpmaster | 10 Tips for Better Coding | ||
Thank you Abdullah for doing better than I with these 10 tips for better coding. Writing code can sometimes be the most difficult part of any software development process. If you don’t organize everything from the start – especially for big projects — the coding processes and code management afterwards may end up not just time […] | ||
Pure Geek - Google HTML/CSS Coding Guide | ||
All of us web workers should take a look at these Google coding guidelines. I thought I was up to date on best practices, but it seems I’ve got a lot to learn again. Did you know that with HTML5… head tag isn’t required optional tag closings are optional again and therefore recommended to be […] | ||
2 More How-to’s on Using TYPO3′s tt_news | ||
In past writings, I’ve been covering 10 ways of tt_news and 5 How-to’s on Using TYPO3′s tt_news . Today, I’ll cover the two more of 10 alternate ways of using tt_news. BPMinstitute.org White Papers lead generator BPMinstitute.org has really pushed what can be done with tt_news in many avenues in regards to lead generation. Whenever […] | ||