Magento 1.9 – Fix Direct SQL Query Error: Column Not Found

databasemagento-1.9

I have a table with content:

I want to write a direct SQL query to select the time_delivery, where country is, for example, DK in this case.
So it should return 1-5.

I was following a tutorial: https://fishpig.co.uk/magento/tutorials/direct-sql-queries/
And tried modifying query myself like this:

$country= "DK";
$query = 'SELECT time_delivery FROM ' . $table . ' WHERE country = '
     .$country . ' LIMIT 1';

But I get an error: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'DK' in 'where clause'

I would assume that it has something to do with the fact the in the tutorial he uses an int but I want to use a string

Best Answer

try this way

$country= "DK";
$query = 'SELECT time_delivery FROM ' . $table . ' WHERE country ="'.$country.'" LIMIT 1';

Related Solutions

How to Add Email Address in Sales Orders Admin Grid in Magento 1.9

First of all, you need to get the customer email by performing a join with sales_flat_order table. Your _prepareCollection() function will be:

protected function _prepareCollection()
    {
        $collection = Mage::getResourceModel($this->_getCollectionClass());
        $collection->getSelect()->joinLeft(
           array('ordersTable'=>'sales_flat_order'),
           'ordersTable.entity_id = main_table.entity_id',
           array('ordersTable.customer_email')
         );
        $this->setCollection($collection);
        return parent::_prepareCollection();
    }

In _prepareColumns() you'll need to add:

$this->addColumn('customer_email', array(
            'header' => $this->helper('sales')->__('Email'),
            'index' => 'customer_email',
            'filter_index' => 'ordersTable.customer_email',
        ));

Now, to fix the search issue on order number, you'll need to add 'filter_index' on 'order number' column. The issue is happening because there is duplicate increment_id column. Here is the code:

$this->addColumn('real_order_id', array(
            'header'=> Mage::helper('sales')->__('Order #'),
            'width' => '80px',
            'type'  => 'text',
            'index' => 'increment_id',
            'filter_index'=>'main_table.increment_id'
        ));

Best Answer

Related Solutions

How to Add Email Address in Sales Orders Admin Grid in Magento 1.9

Related Topic