thankyou for your response, Charlie.
sadly, the JSTL seems to satisfy only one criteria. easy iteration to
access the data.
>From my understanding and research, the JSTL query "object" can *only*
be populated by throwing it against a database, not dynamically filled
like an arrayList, linkList or a CF query using QueryAddRow() /
QuerySetCell() / QueryAddColumn().
then there's the ability to filter and return rows based on simple SQL
syntax, which ADO.NET just manages to do** but CF's QueryOfQueries
does in style.
unless I can find otherwise, the humble CFQUERY seems to be unique in
the way it looks like a collection/structure/datatype but has it's own
properties and methods to work with the data it holds. Thanks to a
simple API, it's much more than just the hashMap that's used under the
covers.
as a side note re JSTL connecting to a database and returning results:
maybe it's just me but that idea (tight coupling between model and
view) just seems to be so.... 1998....
thanx anyhoo, Charlie.
**internal storage of ADO.NET's datasets and datatables is (IIRC) XML
and all the methods do is query (XPath?) the xml or append nodes, etc.
While this is a possible solution, it's the sort of thing that you'd
wish someone else had written!
(PS: Dale: Amen to that - but I am only a small voice in the crowd)
On 6/15/06, Charlie Arehart <[EMAIL PROTECTED]> wrote:
>
> Barry, if I'm understanding your question correctly, have you looked at the
> JSTL (JSP Standard Tag Library)? It makes JSP look a lot more like CFML,
> particularly a query:
>
> <sql:query var="deejays">
> SELECT * FROM mytable
> </sql:query>
>
> <%-- Get the column names for the header of the table --%>
> <c:forEach var="columnName" items="${deejays.columnNames}">
> <th><c:out value="${columnName}"/></th>
> </c:forEach>
>
> <%-- Get the value of each column while iterating over rows --%>
> <c:forEach var="row" items="${deejays.rows}">
> <tr>
> <c:forEach var="column" items="${row}">
> <td><c:out value="${column.value}"/></td>
> </c:forEach>
> </tr>
> </c:forEach>
>
> The JSTL has been included in JSP 2.0, which has been out for a couple years
> now (and I think it grew out of work that the Jrun team did, being familiar
> as they were with CFML). It's now available on all the J2EE and Servlet
> Engine implementations
>
> For more, see:
>
> http://www.devx.com/webdev/Article/16973/1763/page/3
>
> http://www.oracle.com/technology/sample_code/tech/java/codesnippet/jsps/jstl
> sql.html
>
> And many other resources.
>
> /charlie
>
> -----Original Message-----
> From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf
> Of Barry Beattie
> Sent: Thursday, June 15, 2006 1:41 AM
> To: cfaussie@googlegroups.com
> Subject: [cfaussie] in praise of ColdFusion (and an OT Java question)
>
>
> <snip>
>
> anyhoo, I'm looking for a java replacement of the humble CFQUERY - but not
> the database connectivity side of it.
>
> perhaps a class than can
>
> - be an object masquarading as a 2D data structure that can be dynamically
> resized (ie: no db required) and has a simple API to do so (as easy as
> QueryAddRow, QuerySetCell, QueryAddColumn)
>
> - be accessed/iterated over with obj["keyname"][row] or obj[i][j]
>
> - have simple SQL thrown against it.
>
> Microsoft's ADO.NET can (mostly) do this (albeit with 10 times more code
> than CF) http://msdn2.microsoft.com/en-us/system.data.datatable.aspx
>
> but is there a java version of the same? Surely someone has already done
> this (apart from Alaire/Macromedia/Adobe)
>
>
> >
>
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"cfaussie" group.
To post to this group, send email to cfaussie@googlegroups.com
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at http://groups.google.com/group/cfaussie
-~----------~----~----~----~------~----~------~--~---
