[Date Prev][Date Next][Thread Prev][Thread Next][Minivend by date
][Minivend by thread
]
Re: Can you break out of a [sql type=list] loop?
****** message to minivend-users from Alan Sparks <asparks@nss.harris.com> ******
Unfortunately not Oracle. I've already been down the ROWNUM route
before, also, which doesn't work because I need to sort the rows in
descending order (which messes up the ROWNUMs.
So, I _really_ need a counter loop in MV. Or one hell of a good way to
implement a "top 5" query in Oracle.
-Alan
Dan Busarow wrote:
>
> On Thu, 4 Mar 1999, Alan Sparks wrote:
> > Sorry, but for what database does that work? I should have mentioned I'm
> > using Oracle.
>
> As far as I know it's SQL92. Should work for any vendor.
>
> Dan
> --
> Dan Busarow 949 443 4172
> Dana Point Communications, Inc. dan@dpcsys.com
> Dana Point, California 83 09 EF 59 E0 11 89 B4 8D 09 DB FD E1 DD 0C 82
--
Alan Sparks, Network Administrator <asparks@nss.harris.com>
Harris Communications, Camarillo CA (805) 389-2430
-
To unsubscribe from the list, DO NOT REPLY to this message. Instead, send
email with 'UNSUBSCRIBE minivend-users' in the body to Majordomo@minivend.com.
Archive of past messages: http://www.minivend.com/minivend/minivend-list
