It seems to be exactly what I need but it doesn't work by my side. I would like to use a sql query to load an entity.
I followed the instructions in the documentation (http://nhforge.org/ doc/nh/en/index.html#querysql-load) But 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? Thank you in advance for your help. --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
