It seems to be exactly what I need but it doesn't work by my side.
I get this error:
Table 'magento131.Shipping' doesn't exist

Here is my mapping file:


  <class name="Shipping" lazy="false">
    <id name="Id">
      <generator class="assigned" />
    </id>
    <property name="Label" update="false" />
    <loader query-ref="shipping"/>
  </class>

  <sql-query name="shipping">
    <return alias="ship" class="Shipping" />
    select distinct shipping_method as {ship.Id}, REPLACE
(shipping_method , '_', ' ') as {ship.Label}
    from delivery_days
  </sql-query>

What am I doing wrong?

--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups 
"nhusers" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to 
[email protected]
For more options, visit this group at 
http://groups.google.com/group/nhusers?hl=en
-~----------~----~----~----~------~----~------~--~---

Reply via email to