Archive: sql

If you are working with collections and would like to verify that the actual SQL being used is what you expect it to be then this little tip might prove really handy. For any collection you can call the method getSelect(). This retrieves the actual Select object that handles the query. If you cast this [...]

If your osCommerce checkout starts behaving badly and bits of info seem to go missing eg billing address then you should definitely try this fix before you tear your hair out completely. Most osCommerce installs store session information to a MySQL table called (suprisingly) sessions. Sometimes (I have only seen this twice on umpteen osCommerce [...]

If you develop using Zend Framework you will know that it is sometimes tricky to see exactly whats going on in terms of SQL queries. After trying a few different ideas including subclassing the database classes or other complex systems, the easiest I have found is this: 1. Edit your app.ini config file and add [...]