[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Oaks, Harold
Sent: Saturday, 20 February 2010 1:52 AM
To: U2 Users List
Subject: Re: [U2] TOP/LIMIT Equivalent?
Adrian:
Here's a dumb little solution that might work for you if you can run a VOC
paragraph (I don't know how your interface
In a message dated 2/21/2010 5:42:59 PM Pacific Standard Time,
adrian.ha...@itvision.com.au writes:
Keeping a saved list does not guarantee that all the records in that list
are still valid. New records could of been created that should be included
and old records may be deleted that
Of Adrian Halid
Sent: Thursday, February 18, 2010 8:45 PM
To: U2 Users List
Subject: Re: [U2] TOP/LIMIT Equivalent?
If I have a file of 100,000 products and I want to page them in a list
of 100 on my website sorted by product name in attribute 1.
SELECT PRODUCTS BY A1
This would return me all
Wouldn't you just SELECT xxx FIRST 100
?
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of
fft2...@aol.com
Sent: Thursday, February 18, 2010 9:38 PM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] TOP/LIMIT
.
___
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Dan Fitzgerald
Sent: Friday, 19 February 2010 9:29 AM
To: 'U2 Users List'
Subject: Re: [U2] TOP/LIMIT Equivalent?
You could save the list
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Andrew E. Tegenkamp
Sent: Thursday, February 18, 2010 12:50 PM
To: u2-users@listserver.u2ug.org
Subject: [U2] TOP/LIMIT Equivalent?
In UniVerse, I can't seem to find the syntax like MSSQL's SELECT TOP 100 or
MySQL's LIMIT 100 clause.
Does
-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Andrew E.
Tegenkamp
Sent: Thursday, February 18, 2010 9:50 AM
To: u2-users@listserver.u2ug.org
Subject: [U2] TOP/LIMIT Equivalent?
In UniVerse, I can't seem to find the syntax like MSSQL's SELECT TOP 100
, dude
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Oaks, Harold
Sent: Thursday, February 18, 2010 10:21 AM
To: U2 Users List
Subject: Re: [U2] TOP/LIMIT Equivalent?
Andrew:
Indeed, the word is 'sample
In a message dated 2/18/2010 10:27:46 AM Pacific Standard Time,
cla...@hme.com writes:
You can sort first and then SAMPLE, too.
Caryl has the idea here if you really want the Last 100.
You can Sort BY-DSND which means by descending so if you want the last
alphabetically or the last by ID or
-users@listserver.u2ug.org
Subject: Re: [U2] TOP/LIMIT Equivalent?
In a message dated 2/18/2010 10:27:46 AM Pacific Standard Time,
cla...@hme.com writes:
You can sort first and then SAMPLE, too.
Caryl has the idea here if you really want the Last 100.
You can Sort BY-DSND which means
Subject: Re: [U2] TOP/LIMIT Equivalent?
But how would you get the 2nd 100 (101 - 200) and the 3rd 100 (301 to 400)
without writing a subroutine to do it?
Regards
Adrian Halid
Senior Analyst/Programmer
IT Vision Australia Pty Ltd (ABN: 34 309 336 904)
PO Box 881, Canning Bridge WA 6153
Level 3
.
___
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Dan Fitzgerald
Sent: Friday, 19 February 2010 9:29 AM
To: 'U2 Users List'
Subject: Re: [U2] TOP/LIMIT Equivalent?
You could save the list, and edit
No that reply wasn't paying attention to the point that we were *sorting*
the list.
True if you simply Sample the list, they are in random hashed order. But
that is not true is the list comes into your program sorted by you execute a
sort as the first statement in your program.
No you do not
13 matches
Mail list logo