Managing Hierarchical Data in MySQL

Introduction Most users at one time or another have dealt with hierarchical data in a SQL database and no doubt learned that the management of hierarchical data is not what…

Read more »

4019965324

Following SQL code will add Indian state records in directory_country_region and directory_country_region_name tables. INSERT INTO `directory_country_region` VALUES (NULL , “IN”, “Andaman Nicobar”,”Andaman Nicobar”), (NULL , “IN”, “Andhra Pradesh”,”Andhra Pradesh”), (NULL…

3143171104

Add CSS & Js to Magento Layout xml file

Below is the correct way to add css & js files from your theme’s skin and js folder . Add css from theme’s skin in layout xml file- <action method=”addCss”><stylesheet>css/styles.css</stylesheet></action>…

Read more »

7047448072

Note for recent versions of Magento – Broken Seems like this tutorial doesn’t work anymore for recent versions (1.6.2 for me), because of magento prices indexing. Price is not calculated…

(615) 806-4752

Learning Ruby on rails

What is Rails? Rails is a web application development framework written in the Ruby language. It is designed to make programming web applications easier by making assumptions about what every…

Read more »

Nginx + Passenger to serve rails apps in different sub URIs

Let you have 2 directories and wants to configure, make sure u have installed passenger already. server { listen 80; server_name 127.0.0.1; location /first/ { root /home/hector/webapps/first/public; passenger_base_uri /first/; proxy_pass…

Read more »

Running Ruby on Rails on Nginx

Follow below steps to install Ruby on rails successfully. Ruby 1 2 3 4 5 6 export PATH=”${PATH}:/var/lib/gems/1.8/bin/” echo ‘export PATH=”${PATH}:/var/lib/gems/1.8/bin/”‘ >> /etc/bash.bashrc aptitude install ruby rubygems vim-ruby ruby-dev libzlib-ruby…

Read more »

(518) 402-1030

A collection is a Model type containing other Models, it is basically used in Magento to handle product lists (ie. from a category or a bundle option), but not only. TO DO: Explain…

9016746125

List all payment methods in Magento

How to get a list with all available payment methods in Magento. If for any reason you need to a get a list with all payment methods in Magento, you…

Read more »

Magento addAttributeToFilter SQL Conditionals

If you want to customize query or product collection data you can easily to do that with addAttributeToFilter funcation in magento. In short you can easily customize product collection select…

Read more »