What do you mean? Are you still trying to get 'formation.name'? If so, you should be using the alias (formation_name).
-- James Mitchell Web Developer/Struts Evangelist http://jakarta.apache.org/struts/ > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > Sent: Friday, February 28, 2003 4:06 PM > To: Struts Users Mailing List; 'Struts Users Mailing List' > Subject: RE: [OT] trouble with JDBC > > > It's still doesn't work .. > > I'm been using postgresql 7.3 on cygwin with the jdbc driver > comming with > jboss. > > -- > Alexandre Jaquet > > >-- Original Message -- > >Reply-To: "Struts Users Mailing List" > <[EMAIL PROTECTED]> > >From: "James Mitchell" <[EMAIL PROTECTED]> > >To: "'Struts Users Mailing List'" <[EMAIL PROTECTED]> > >Subject: RE: [OT] trouble with JDBC > >Date: Fri, 28 Feb 2003 15:54:49 -0500 > > > > > >Use an alias. > > > >Depending on the vendor you could have: > >SELECT name, firstName, adress, formation.name formation_name FROM > >person, formation > > > >Or > > > >SELECT name, firstName, adress, formation.name as > formation_name FROM > >person, formation > > > > > >-- > >James Mitchell > >Web Developer/Struts Evangelist > >http://jakarta.apache.org/struts/ > > > > > > > >> -----Original Message----- > >> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > >> Sent: Friday, February 28, 2003 3:49 PM > >> To: Struts Users Mailing List; [EMAIL PROTECTED] > >> Subject: [OT] trouble with JDBC > >> > >> > >> Hi know this is really out of topic but I get trouble with > >> query who require > >> multiple tables with same column name through JDBC. > >> > >> Ex : > >> SELECT name, firstName, adress, formation.name FROM > >> person, formation > >> ..... > >> > >> With a query like this one I got en exception : The column > >> name formation.name > >> not found .... > >> > >> But work fine in a console... > >> > >> Any idea ?? > >> > >> -- > >> Alexandre Jaquet > >> > >> sunrise premiumsurf - ne vous contentez pas du minimum! > >> http://internet.sunrise.ch/fr/internet/int_sps.asp > >> > >> > >> > >> > >> > --------------------------------------------------------------------- > >> To unsubscribe, e-mail: [EMAIL PROTECTED] > >> For additional commands, e-mail: > [EMAIL PROTECTED] > >> > > > > > >--------------------------------------------------------------------- > >To unsubscribe, e-mail: [EMAIL PROTECTED] > >For additional commands, e-mail: [EMAIL PROTECTED] > > > > > sunrise premiumsurf - ne vous contentez pas du minimum! > http://internet.sunrise.ch/fr/internet/int_sps.asp > > > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
