RE: Iterating the resultset contents in the view (jsp)

2003-07-18 Thread Sandeep Takhar
Is this display tag library better now with i18n and formatting dates etc... Do I still have to create objects to format the values in the table? Curious to know if someone has had real life experience with this nice product and maybe has some best practices... sandeep --- Raible, Matt [EMAIL

RE: [OT]RE: Iterating the resultset contents in the view (jsp)

2003-07-16 Thread Edgar Dollin
: Tuesday, July 15, 2003 1:55 PM To: 'Struts Users Mailing List' Subject: Re: [OT]RE: Iterating the resultset contents in the view (jsp) --- Vijay Balakrishnan [EMAIL PROTECTED] wrote: Hi, Is there a way to return this resultset from a SQL Query as an xml file using a beanutils

RE: Iterating the resultset contents in the view (jsp)

2003-07-16 Thread Richard Hill
: Monday, July 14, 2003 7:25 PM To: Struts Users Mailing List Subject: Re: Iterating the resultset contents in the view (jsp) On Mon, 14 Jul 2003, Richard Hill wrote: Date: Mon, 14 Jul 2003 16:36:17 -0700 From: Richard Hill [EMAIL PROTECTED] Reply-To: Struts Users Mailing List [EMAIL PROTECTED

Re: Iterating the resultset contents in the view (jsp)

2003-07-15 Thread Kris Schneider
Well, okay, that makes the discussion a bit more abstract ;-). I understand your point, but the bottom line is that it's just a namespace (package) and an external library (JAR file). To my mind, the real question with either Result or RowSetDynaClass is how far from the data layer do you want the

Re: Iterating the resultset contents in the view (jsp)

2003-07-15 Thread David Graham
--- Kris Schneider [EMAIL PROTECTED] wrote: Well, okay, that makes the discussion a bit more abstract ;-). I understand your point, but the bottom line is that it's just a namespace (package) and an external library (JAR file). To my mind, the real question with either Result or

Re: Iterating the resultset contents in the view (jsp)

2003-07-15 Thread Ben Anderson
That is true, but when columns are added to the table - you need not edit any file other than the jsp(doing it Kris' way). From: David Graham [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Struts Users Mailing List [EMAIL PROTECTED] Subject: Re: Iterating the resultset contents in the view

Re: Iterating the resultset contents in the view (jsp)

2003-07-15 Thread Craig R. McClanahan
On Tue, 15 Jul 2003, Kris Schneider wrote: Well, okay, that makes the discussion a bit more abstract ;-). I understand your point, but the bottom line is that it's just a namespace (package) and an external library (JAR file). To my mind, the real question with either Result or

Re: Iterating the resultset contents in the view (jsp)

2003-07-15 Thread Kris Schneider
Sure, understood. In fact I do this myself. But the reality is it's still an identifier that's defined in the data layer, in this case embedded in SQL. My point was that I'd be more concerned with identifiers defined in the data layer getting referenced in the view layer then I would with using

Re: Iterating the resultset contents in the view (jsp)

2003-07-15 Thread Craig R. McClanahan
On Tue, 15 Jul 2003, Kris Schneider wrote: Date: Tue, 15 Jul 2003 12:42:36 -0400 From: Kris Schneider [EMAIL PROTECTED] Reply-To: Struts Users Mailing List [EMAIL PROTECTED] To: Struts Users Mailing List [EMAIL PROTECTED] Subject: Re: Iterating the resultset contents in the view (jsp

Re: Iterating the resultset contents in the view (jsp)

2003-07-15 Thread David Graham
: Re: Iterating the resultset contents in the view (jsp) Sure, understood. In fact I do this myself. But the reality is it's still an identifier that's defined in the data layer, in this case embedded in SQL. Isn't that going to be true even if you bury SQL inside a DAO? Someone somewhere

[OT]RE: Iterating the resultset contents in the view (jsp)

2003-07-15 Thread Vijay Balakrishnan
: Iterating the resultset contents in the view (jsp) On Mon, 14 Jul 2003, Richard Hill wrote: Date: Mon, 14 Jul 2003 16:36:17 -0700 From: Richard Hill [EMAIL PROTECTED] Reply-To: Struts Users Mailing List [EMAIL PROTECTED] To: '[EMAIL PROTECTED]' [EMAIL PROTECTED] Subject: Iterating the resultset

Re: [OT]RE: Iterating the resultset contents in the view (jsp)

2003-07-15 Thread David Graham
-Original Message- From: Craig R. McClanahan [mailto:[EMAIL PROTECTED] Sent: Monday, July 14, 2003 7:25 PM To: Struts Users Mailing List Subject: Re: Iterating the resultset contents in the view (jsp) On Mon, 14 Jul 2003, Richard Hill wrote: Date: Mon, 14 Jul 2003 16:36:17

Re: [OT]RE: Iterating the resultset contents in the view (jsp)

2003-07-15 Thread Kris Schneider
Subject: Re: Iterating the resultset contents in the view (jsp) On Mon, 14 Jul 2003, Richard Hill wrote: Date: Mon, 14 Jul 2003 16:36:17 -0700 From: Richard Hill [EMAIL PROTECTED] Reply-To: Struts Users Mailing List [EMAIL PROTECTED] To: '[EMAIL PROTECTED]' [EMAIL

RE: [OT]RE: Iterating the resultset contents in the view (jsp)

2003-07-15 Thread Vijay Balakrishnan
Message- From: David Graham [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 15, 2003 11:55 AM To: Struts Users Mailing List Subject: Re: [OT]RE: Iterating the resultset contents in the view (jsp) --- Vijay Balakrishnan [EMAIL PROTECTED] wrote: Hi, Is there a way to return this resultset from

RE: Iterating the resultset contents in the view (jsp)

2003-07-14 Thread Shane Mingins
Hi Richard For what it is worth this is how I am doing it: My form has a Collection called products which contains product objects. A product has a name and description. The id value product is then used to refer to each object in the collection in a bean write statement, displaying the name

RE: Iterating the resultset contents in the view (jsp)

2003-07-14 Thread Raible, Matt
The easiest way IMO is to do the following: 1. Create ActionForms or POJOs to represent each row returned from your table. 2. Put these in a List and put them in a scope (i.e. request or session). 3. Display them with the Display Tag Library (http://displaytag.sf.net). HTH, Matt

Re: Iterating the resultset contents in the view (jsp)

2003-07-14 Thread David Graham
--- Richard Hill [EMAIL PROTECTED] wrote: Hi, I'm working on an action that gets a resultset from a database table containing 4 columns. I need to pass that information back to the view (jsp) which will iterate over results. My question is what is the best way to do this. Do I create an

Re: Iterating the resultset contents in the view (jsp)

2003-07-14 Thread Craig R. McClanahan
On Mon, 14 Jul 2003, Richard Hill wrote: Date: Mon, 14 Jul 2003 16:36:17 -0700 From: Richard Hill [EMAIL PROTECTED] Reply-To: Struts Users Mailing List [EMAIL PROTECTED] To: '[EMAIL PROTECTED]' [EMAIL PROTECTED] Subject: Iterating the resultset contents in the view (jsp) Hi, I'm working

Re: Iterating the resultset contents in the view (jsp)

2003-07-14 Thread Kris Schneider
Another datapoint: JSTL provides an interface called javax.servlet.jsp.jstl.sql.Result: public interface Result { public SortedMap[] getRows(); public Object[][] getRowsByIndex(); public String[]getColumnNames(); public int getRowCount(); public boolean

Re: Iterating the resultset contents in the view (jsp)

2003-07-14 Thread David Graham
That's certainly another option but keep in mind that it ties your app to the web. That may be ok if you don't plan on reusing any of the code from the app but DynaBeans are more appropriate for building layers that are reusable in any environment. David --- Kris Schneider [EMAIL PROTECTED]

Re: Iterating the resultset contents in the view (jsp)

2003-07-14 Thread Kris Schneider
I'll admit that using a package called javax.servlet.jsp.jstl.sql in a non-Web app is a bit odd, but I'm not seeing any dependencies on other javax.servlet classes or interfaces or a Web container. I haven't tried it, but I'd bet the examples below would work outside a Web app. Worth a try

Re: Iterating the resultset contents in the view (jsp)

2003-07-14 Thread David Graham
--- Kris Schneider [EMAIL PROTECTED] wrote: I'll admit that using a package called javax.servlet.jsp.jstl.sql in a non-Web app is a bit odd, but I'm not seeing any dependencies on other javax.servlet classes or interfaces or a Web container. I haven't tried it, but I'd bet the examples