Tag Archives: SQL

MySQL Query – No Quote For String Fields

Posted on November 6, 2009 by lysender

One of the module in our project, it is experiencing a slow performance. The module will let the user scan the PCB barcode of an item and updated a record on the database. It was originally built on MyISAM table … Continue reading →

Posted in Database | Tagged , , , , , , | Leave a comment

From SQL Script to Zend Db Query

Posted on March 6, 2009 by lysender

Yesterday, I have debugged an AJAX request that gets a value from the database. It was actually me who developed that module and all calculations and SQL query are based on the specifications given by our analyst. The query was … Continue reading →

Posted in SQL, Zend Framework | Tagged , , , , | Leave a comment