I have seen that I can query a table that contains a name/value key pair but I am not doing something exactly right.
I have 3 main sql tables. 1. Attribute table that contains the "name" part of the pair (this name will change dynamically based on the users). This table maps to a control table by the AttributeId. 2. Control table - think of this table as sitting in between the Attribute table and the Value table. 3. Value table. As of now I have an sproc that builds a list of the column names dynamically. This @col variable is then applied to a pivot table so that I now have the records in the proper format. The problem is that my current mapping files for this makes the assumption that the column names will be the same (which is a major flaw). What I was thinking I need to do is join the Attribute table and the Control table together in one hbm file to come up with the "name" part. How can I reference that in the "table" attribute of the <map> tag in a different hbm file? Pleae let me know if you need the code that I have so far. --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
