!
--- Marina Hauptman <[EMAIL PROTECTED]> wrote:
> As long as you are using RNUM column from the
> subquery, you can collapse
> the query into two levels. It works for the same
> reason RNUM works in
> RNUM > nnn. I did test it.
>
> At 11:17 AM 1/30/2006 -0800,
Sorry, but this is not the case. Because of the way
Oracle issues ROWNUM values, you can't collapse the
query I presented into just two levels. See the
Oracle Database SQL Reference. On online version can
be found at http://tahiti.oracle.com (registration may
be required?). Quote: "Conditions t
One common way to return a "page" of record from
Oracle is to use a nested query. For example: assume
you display 25 records per page, and you wish to
retrieve page 2's records, your query would look
something like this:
SELECT * FROM (
SELECT * FROM (
SELECT *, ROWNUM AS RNUM FROM A_TABLE
Here's the code for the version of H::T that cross-compiles the stack language into an anonymous sub. I've see a significant improvement in rendering speed using this package over stock H::T. Would like to offer this up for review / discussion.
Thanks!
- Bob Diss
Do you
urlescape
I've been using this on my site for about a month now. It supports all of the features of H::T, and also includes the enhancements I've done locally. I would like to figure out a way to share it (if it's of interest) 'cause I'm sure the manner in
does weaken (or at least postpone) the strong type checking that occurs for a loop value (must be an arrayref).
-Bob Diss
Do you Yahoo!?vote.yahoo.com - Register online to vote today!
that FORMAT does not replace ESCAPE. Instead, they happen in sequence. First, the value is formatted, then it is escaped.
Comments? Thoughts? Suggestions?
- Bob Diss
__Do You Yahoo!?Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com
something like this:
output an item in column 1
output an item in column 2
output an item in column 3
I've found these enhancements to be very useful, as they save me from coding layout decision flags in my loop items, while enabling more sophisticated layout p
