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) > > 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 is going to have to deal with the column names that are defined in your database. > 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 > Result and ResultSupport outside of a web app. A lot of people externalize SQL command strings into properties files so that they can tweak them for differences between databases. This would also give you a level of separation, in that you can reference the actual column names ONLY in the properties file strigns, and have your code using the result set deal only with the aliases set with "as". Craig --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]