AW: AW: AW: foreign-key generation maps NumberKey to int, and code fails to compile

2007-08-14 Thread Thoralf Rickert
ns(). This method is implemented in BaseCcsMember. > -Ursprüngliche Nachricht- > Von: brycenesbitt [mailto:[EMAIL PROTECTED] > Gesendet: Dienstag, 14. August 2007 10:14 > An: torque-user@db.apache.org > Betreff: Re: AW: AW: foreign-key generation maps NumberKey to > int, and

Re: AW: AW: foreign-key generation maps NumberKey to int, and code fails to compile

2007-08-14 Thread brycenesbitt
Each coupon is owned by one member. A member may have any number of coupons. SQL has no trouble setting up such a relationship without a third table. Do I need the third table to satisfy Torque? Thoralf Rickert wrote: > > Ah, okay, a coupon has only one member. Is it possible to have a member

AW: AW: foreign-key generation maps NumberKey to int, and code fails to compile

2007-08-14 Thread Thoralf Rickert
AW: foreign-key generation maps NumberKey to > int, and code fails to compile > > > > Hmm, ok. But if I flip it around like that, I don't get a > BaseCcsMemberPeer.doSelectJoinCcsCoupon(). > > > required="true" type="I

Re: AW: foreign-key generation maps NumberKey to int, and code fails to compile

2007-08-14 Thread brycenesbitt
Hmm, ok. But if I flip it around like that, I don't get a BaseCcsMemberPeer.doSelectJoinCcsCoupon(). How can I get a BaseCcsMemberPeer.doSelectJoinCcsCoupon(), which will do essentially: S

AW: foreign-key generation maps NumberKey to int, and code fails to compile

2007-08-14 Thread Thoralf Rickert
Hi! I'm not sure if I understand you problem. But does it make sense to declare a foreign key for primary key in the same table? Normally you declare the foreign key in COUPON and make a reference to MEMBER. Maybe Torque doesn't "like" this double "key-definition" in MEMBER. But I'm not sure...