--- "Craig R. McClanahan" <craigmcc@(protected):
>
>
> On Tue, 15 Jul 2003, Kris Schneider wrote:
>
> > Date: Tue, 15 Jul 2003 12:42:36 -0400
> > From: Kris Schneider <kris@(protected)>
> > Reply-To: Struts Users Mailing List <struts-user@(protected)>
> > To: Struts Users Mailing List <struts-user@(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".

I've found this approach to be quite useful. It gets tough when you need
to dynamically create a query based on a user's search form values. In
that situation I define each SQL search chunk under it's own key and use
MessageFormat to insert values appropriately.

David

>
> Craig
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: struts-user-unsubscribe@(protected)
> For additional commands, e-mail: struts-user-help@(protected)
>


__________________________________
Do you Yahoo!?
SBC Yahoo! DSL - Now only $29.95 per month!
http://sbc.yahoo.com

---------------------------------------------------------------------
To unsubscribe, e-mail: struts-user-unsubscribe@(protected)
For additional commands, e-mail: struts-user-help@(protected)