RE: simper and linking tables (many to many relationships)

Ok will do (join the mailing list) will also add the primary key column -Original Message- From: Bryan Field-Elliot [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 06, 2002 1:04 PM To: Struts Users Mailing List Subject: Re: simper and linking tables (many to many relationships) m-m

RE: simper and linking tables (many to many relationships)

Doh... I see where I have a primary key afterall... That was STUPID on my part. -Original Message- From: John Menke [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 06, 2002 12:56 PM To: struts-user Subject: simper and linking tables (many to many relationships) I have the following

Re: simper and linking tables (many to many relationships)

m-m is not yet supported in an elegent way by Simper. In the docs I mention 1-1 and 1-m but I don't mention m-m for this reason. As a tempoary workaround to get going, create another field in your portfolio_stock table, called "id", and use it as a (pseudo) primary-key (assigning it unique values

simper and linking tables (many to many relationships)

I have the following model: -- Table: stock CREATE TABLE "stock" ( "stock_pkey" int4 NOT NULL, "symbol" varchar(5) NOT NULL, "name" varchar(50) NOT NULL, "price" numeric(5, 3), CONSTRAINT "stock_symbol_key" UNIQUE ("symbol"), CONSTRAINT "stock_pkey" PRIMARY KEY ("stock_pkey") ); --