You have a query and you want to display the results on a web page but because there are so many results you want to paginate the data so the user can have some links like “prev page, page 1, page 2, next page, last page” that you can see on a lot of sites […]
Monthly Archives: January 2009
SQL Join syntax: Theta vs ANSI
At the heart of every dynamic website is some form of data source, whether it’s a simple flat text file, XML schema, or full blown database. In this article, I’ll be addressing database table joins with SQL (specifically MySQL).
Good database design should adhere to the third normal form, or “3NF”. In a nutshell, relating bits […]
Typo3 and MySQL replication
Apparently the TYPO3 version we are using, doesn’t play too nice with the MySQL MasterMaster replication.
Sometimes, something like this is going to happen:
070826 0:44:32 [ERROR] Slave: Error ‘Duplicate entry ‘75-222419149′ for key 1′ on query. Default database: ‘t3nb’. Query: ‘INSERT INTO cache_pagesection
070826 0:44:32 [ERROR] Error running query, slave SQL thread aborted. Fix the […]
5 Legal Tips To Save Startups Money & Headaches
Being smart about legal matters can make a huge difference in the value of your company. Each legal decision you make - each strategic partnership, each trademark or patent filing - can add or subtract from it.
During the ’90s, my law firm worked with an internet software company whose proposed $400 million sale was stopped […]
JDeveloper free as in beer
Infoworld is reporting that JDeveloper will be gratis: Oracle to offer JDeveloper tool for free.
Out of the box, JDeveloper has a lot more functionality than Eclipse in many areas. Visual JSP editing, visual support for JSF, support for some of the UML diagrams, wizard support for it’s ORM frameworks ADF Business components and Toplink. […]
Wilfred’s summary of CB’s migration from Designer to JDeveloper on OTN!
Wilfred’s story about Jules de Ruijter’s presentation on their migration from Designer to Developer made it to OTN’s frontpage! I have to agree with Wilfred, the presenation, Oracle Designer versus Oracle JDeveloper, was really interesting, Jules is a good speaker who likes to provoke his audience.
AppsLab Hackathon
So, yet another last-minute OpenWorld announcement, but that’s how we roll. We’re going to host an informal hackathon at the OTN Lounge during the conference.
The OTN Lounge will be in Moscone West, Third Floor, coincidentally right near the Unconference sessions, which should work out well.
So, we’re calling it informal because Rich, Anthony and I will […]