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
-~----------~----~----~----~------~----~------~--~---