Home » Archive

Articles tagged with: query

Magento »

[19 Mar 2012 | No Comment]

Here is a quick tip to add OR query and AND query to collection object. I am implementing this on product collection. Getting product collection

Magento »

[15 Nov 2010 | 11 Comments]

In my previous article (Magento: Very Useful Collection Functions), I had written about database interaction functions present in class Varien_Data_Collection_Db. Here, I am going to explain some database interaction functions present in the class Mage_Eav_Model_Entity_Collection_Abstract. These collection functions are very useful to select data from Magento database. We need them almost all the time for [...]

Magento »

[2 Aug 2010 | 2 Comments]

Scenario: You have created a custom module. You have entered certain data in your database. You need to show the data randomly. Solution:

Database, MySQL, SQL »

[15 May 2010 | 2 Comments]

The JOIN keyword is used in an SQL statement to query data from two or more tables, based on a relationship between certain columns in these tables. [@via w3schools] A SQL JOIN clause combines records from two or more tables in a database. It creates a set that can be saved as a table or [...]

Database, SQL »

[10 Mar 2009 | One Comment]

Error description: Cannot insert the value NULL into column ‘SourceId’, table ‘Advisory.dbo.AdvDocSource’; column does not allow nulls. INSERT fails. The statement has been terminated. The ‘CompanyAdd’ procedure attempted to return a status of NULL, which is not allowed. A status of 0 will be returned instead. ——————————- This error occurs because the ‘SourceId’ column in [...]