Query in Magento can be quite troublesome, if you are a starter..or non-starter. So I’ve tried to share some of the difficult queries using collection in Magento, so that it will be helpful to my blog readers and also a place where I can later refer to. Here is one of them, may not be dificult to all, but for me I had a very bad time initially, when I first started on Magento about a year ago. I had always thought to post on my blog, but when one of my collegue asked me about this I remembered and here’s the query.
Posts Tagged ‘ String ’
Getting Customer’s Info Using Single Query Including Billing and Shipping Addresses
Posted on January 18, 2010 by Subesh Pokhrel | 2 Comments
Using Custom Query in Magento
Posted on December 8, 2009 by Subesh Pokhrel | No Comments
Magento has given us very good features to manage Models and Collection for interacting with Database tables. Nowonder, they are very helpful in most of the cases. Yet, we may need to write custom query in some cases (if you need it quick or if you are new to Models & Collection in Magento). But by Magento’s standard this is not recommended. If you are a starter you may find this quering to database very helpful. Here is how you can do this.
Continue reading “Using Custom Query in Magento” »
How to get Query as a String in Magento?
Posted on November 16, 2009 by Subesh Pokhrel | No Comments
Magento as you might know or not! has really a very PIA (Pain in the A**) type of methods to create SQL, execute and fetch! There are two ways of getting SQL from the collection of Magento. Here are the two ways.
Continue reading “How to get Query as a String in Magento?” »