Re: inserting a record with a foreign key

2007-01-31 Thread Mark Volkmann
On Jan 30, 2007, at 10:33 PM, Larry Meadors wrote: Hey Mark, Assuming that you have something like this: Artist bean properties: - id - name - whatever else... ...and your Recording bean properties: - id - name - year - artist (bean) ...you should be able to use dot notation to refer to the

inserting a record with a foreign key

2007-01-30 Thread Mark Volkmann
Here's my situation. I have an artists table and a recordings table in a MySQL database. The artists table has the columns id and name. The recordings table has the columns id, name, year and artist_id (a foreign key to the artists table). I have Artist and Recording POJO classes. The

Re: inserting a record with a foreign key

2007-01-30 Thread Larry Meadors
Hey Mark, Assuming that you have something like this: Artist bean properties: - id - name - whatever else... ...and your Recording bean properties: - id - name - year - artist (bean) ...you should be able to use dot notation to refer to the artist id like this: insert id=insertRecording