Thanks Erik, the patched orbeon.jar works just fine. ~ Dieter
> -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf > Of Erik Bruchez > Sent: Tuesday, October 12, 2004 2:28 PM > To: [EMAIL PROTECTED] > Subject: Re: [orbeon-user] SQL result over multiple tables > > > I hadn't understood that the value was incorrect, I > thought you wanted a > different element name! > > This is a good catch, and an easy fix: instead of > accessing the columns by > name in the SQLProcessor, I now access them by index. I > just checked in the > fix. You can get the source from CVS, and I am also > sending you by separate > email the updated SQLProcessor classes so you can patch > your current > orbeon.jar. Please let us know if that fixes the issue. > > -Erik > > Dieter Stein wrote: > > > Hi, > > > > > We could do a little more if two columns have the > same name, > > > but that would have to be configurable. > > > > Not really, e.g. Cocoon responds with the correct values > for identical > > column names in different tables without any additional > configuration. > > Also, I think it's problematic to add another element > (here: <id>) but > > fill > > it with the wrong *value*. > > > > ~ Dieter > > > > > > > > > Dieter, > > > > > > That's right, we just read the column names as > returned by the > > database. We > > > could do a little more if two columns have the same > name, but > > that would have > > > to be configurable. Maybe the best solution is > simply for you to > > provide an > > > alias, as you suggest. Different databases also behave > > differently. Some, like > > > Oracle I think, will automatically append numbers > if different > > columns have > > > the same name. > > > > > -Erik > > > > > Dieter Stein wrote: > > > > > > > > > Hi, > > > > not very critical, but I would like to report that: > > > > > > > > The sql generator produces identical entries for queries > > > over multiple > > > > tables w/ identical column names, e.g.: > > > > > > > > SELECT table_a.id, table_b.id FROM table_a, table_b > > > > > > > > table_a has got a column 'id' as well as table_b. > The result is > > > > something > > > > like: > > > > > > > > <id>12345</id> <!-- this comes from table_a --> > > > > <id>12345</id> <!-- this also is the value of > table_a, NOT > > > > table_b's! --> > > > > > > > > Defining SELECT table_a.id AS table_a_id, table_b.id AS > > > table_b_id > > > > FROM ... solves the problem, and is probably the better > > > solution for > > > > getting the entries afterwards as <xsl:value-of > > > select="table_b_id"/> > > > > rather than <xsl:value-of select="id[2]"/>. But, as I > > > said, maybe > > > > there is something that can be improved. > > > > > > > > ~ Dieter > > > > > > > > PS: Thanks for opensourcing your software, Orbeon. > > > > > > > > > > > > > > > > ------------------------------------------------------- > > > > This SF.net email is sponsored by: IT Product Guide on > > > > ITManagersJournal Use IT products in your business? Tell > > > us what you > > > > think of them. Give us Your Opinions, Get Free > ThinkGeek Gift > > > > Certificates! Click to find out more > > > > http://productguide.itmanagersjournal.com/guidepromo.tmpl > > > > _______________________________________________ > > > > orbeon-user mailing list > > > > [EMAIL PROTECTED] > > > > https://lists.sourceforge.net/lists/listinfo/orbeon-user > > > > > > > > > > > > ------------------------------------------------------- > > > This SF.net email is sponsored by: IT Product Guide on > > > ITManagersJournal Use IT products in your business? Tell > > > us what you think of them. Give us Your Opinions, Get Free > > > ThinkGeek Gift Certificates! Click to find out more > > > > > > http://productguide.itmanagersjournal.com/guidepromo.tm > > > > pl > > > > > > > > > _______________________________________________ > > > > > > orbeon-user mailing list > > > [EMAIL PROTECTED] > > > > > > https://lists.sourceforge.net/lists/listinfo/orbeon- > user > > > > > > > > > > > > ------------------------------------------------------- > > This SF.net email is sponsored by: IT Product Guide on > > ITManagersJournal Use IT products in your business? Tell > us what you > > think of them. Give us Your Opinions, Get Free ThinkGeek Gift > > Certificates! Click to find out more > > http://productguide.itmanagersjournal.com/guidepromo.tmpl > > _______________________________________________ > > orbeon-user mailing list > > [EMAIL PROTECTED] > > https://lists.sourceforge.net/lists/listinfo/orbeon-user > > > > ------------------------------------------------------- > This SF.net email is sponsored by: IT Product Guide on > ITManagersJournal Use IT products in your business? Tell > us what you think of them. Give us Your Opinions, Get Free > ThinkGeek Gift Certificates! Click to find out more > > http://productguide.itmanagersjournal.com/guidepromo.tm > pl > > > _______________________________________________ > > orbeon-user mailing list > [EMAIL PROTECTED] > > https://lists.sourceforge.net/lists/listinfo/orbeon-user > ------------------------------------------------------- This SF.net email is sponsored by: IT Product Guide on ITManagersJournal Use IT products in your business? Tell us what you think of them. Give us Your Opinions, Get Free ThinkGeek Gift Certificates! Click to find out more http://productguide.itmanagersjournal.com/guidepromo.tmpl _______________________________________________ orbeon-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/orbeon-user
