This is very useful On 8月12日, 下午12时18分, Fabio Maulo <[email protected]> wrote: > shipping_method as {ship.Id}inverted > > 2009/8/11 mathmax <[email protected]> > > > > > > > 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. > > -- > Fabio Maulo
--~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
