IMHO this doesn't sound like an ideal way to do this. At a high level what are you trying to do? Is this a legacy DB or starting from scratch? If I had to do something like this I would instead use something like MappedLongForeignKey so that you have a direct reference to the other tables instead of having to do it manually. Something like:
class C extends LongKeyedMapper[C] with IdPK { def getSingleton = C object refA extends MappedLongForeignKey(this,A) object refB extends MappedLongForeignKey(this,B) def getRef = refA.obj or refB.obj def setRef(obj : A) = refA(obj); refB(Empty) def setRef(obj : B) = refB(obj); refA(Empty) } Derek On Wed, Dec 9, 2009 at 9:44 PM, Joern <joern.bernha...@gmx.net> wrote: > Hi there, > > I want to create a MappedField, which has one column as Type Long and > another column as Type Boolean, but I don't know, what I should put > into "dbFieldClass" and/or targetSQLType. If I look at MappedPassword > for example, I just see classOf[String] or Types.VARCHAR, which > somehow makes sense, because all columns of the MappedPassword are > Strings. How can I create such a MappedField ? > > Or maybe there is a completely different and/or better way to approach > my problem: > I have two tables (A and B), which are represented by my own mapper > classes having IdPK. > In a third table (let's call it C), I want to reference an instance of > A or B in table C. As mentioned above, I want to say for example that > Boolean "false" means look in table A for the Long (=index) and "true" > -> look in table B. > > Any tips, pointers or links to more documentation about multi-column > mappedfields? :) > > Thanks, > Joern > > -- > > You received this message because you are subscribed to the Google Groups > "Lift" group. > To post to this group, send email to lift...@googlegroups.com. > To unsubscribe from this group, send email to > liftweb+unsubscr...@googlegroups.com<liftweb%2bunsubscr...@googlegroups.com> > . > For more options, visit this group at > http://groups.google.com/group/liftweb?hl=en. > > > -- You received this message because you are subscribed to the Google Groups "Lift" group. To post to this group, send email to lift...@googlegroups.com. To unsubscribe from this group, send email to liftweb+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/liftweb?hl=en.