Thanks it 's work just fine now :) -- Alexandre >-- Original Message -- >Reply-To: "Struts Users Mailing List" <[EMAIL PROTECTED]> >Reply-To: <[EMAIL PROTECTED]> >From: "Vinh Tran" <[EMAIL PROTECTED]> >To: "Struts Users Mailing List" <[EMAIL PROTECTED]> >Subject: RE: [OT] trouble with JDBC >Date: Fri, 28 Feb 2003 16:16:30 -0500 > > >do this... > >SELECT p.name, p.firstName, p.adress, f.name as formation_name >FROM person p, formation f > >-----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] >
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]