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