Sorted DW vs. Sorted records
I've been handed a project from another programmer, and the first thing
they've asked me to do is to fix some functionality concerning a "detail" DW
(I say "detail" because the original programmer didn't build it that way,
even though that's what it is - he's not what you would call a "top shelf"
programmer [I don't even think he knows a shelf exists, much less sees
Anyway, the issue they've given me is that when they add records to the
detail section, they can be out of order, since the user has to highlight a
row to ...Difference between dw sort & group sort.
Does anyone know the differences between the datawindow sorting & the group
sorting inside it??
They conflict with eachother. You can actually setup a DW sort which is
different than your groupings and your groups will come out all messed up.
Basically, the grouping still works but the it groups based on how the
records are sorted so you could have the same group multiple times at
different places in the list.
Its best to set your DW sort to be the same as your grouping order.
Andy Cheung wro...How do you get a dw's sort string before changing the sort ?
This seems to be something very basic, but for the life of me I can't find
any documentation on this.....
I would like to capture the sort string of my datawindow before I change it.
How can I capture the sort??
Thanks in advance.
Andrew Joos wrote:
> This seems to be something very basic, but for the life of me I can't find
> any documentation on this.....
> I would like to capture the sort string of my datawindow bef...DW Sort Order differs from SQL Server Sort Order
We have a table with a column sku_cd defined as char(20) not null. Three of
the sku_cd values are:
Three rows are returned by the following query (you can add an ORDER BY
select * from sku where sku_cd between '50-SN16LG-AL' and '50-SN16LG2'
No rows are returned by the following query:
select * from sku where sku_cd between '50-SN16LG2' and '50-SN16LG-AL'
So, this establishes the SQL Server sort/collation order, wherein the '-'
precedes the '2'. (We are using Code Page 1252).
...Sorting DataGrid, Maintane Sort
I have made a sorting datagrid which pages fine and maintanes the sort. But the problem is that when I go to a differnt page while one column is being sorted it still has it sorted but the arrow on the header is gone and it goes back to looking like that column is not sorted even tho it really is.
You can see a the Actual page here: http://company4.go-look.com/Liquids.aspx When you click on the headers it displays that arrow but when pages arrow is gone.
<script runat="server" language="VB">
Protected Dim R...Sorting Arrays with TList.Sort
Several posts suggest using TList for sorting arrays. I have a two-dimensional dynamic array named CashArray, an array of array of double. I would like to sort the rows using the second column.
1. I'm not sure how to properly assign the row pointers to the TList.
2. Even if they are properly assigned, I have no idea how to write the compare function.
Make fun of my ignorance if you like, but please help me correct my code below.
procedure TfMain.Button3Click(Sender: TObject);
function CompareCash(Item1, It...Sorting Issue: Sort by Star
This is my first post, so I apologize if I'm breaking existing etiquette
somehow and beg your pardon. I have a question about folder sorting
behavior (specifically when sorting by "star"):
Right now, when sorting by star, the starred messages are always grouped
with the oldest non-starred messages (that is, a message from yesterday
that I've marked with a star will sit next to the oldest email that I
have, from years ago). This happens when sorting by star on either
ascending or descending. This seems to me to be less useful than the
alternative (sorting s...dw sorting
I want to sort the dw( with a charecter column in it) with numeric
sorting(considering the numeric part of the values in the charecter
column)...I have address in the charecter column like 1a,1b,20 etc.,
Any help is greatly appreciated
Thanks in advance
it might be a bit clunky but you could create a computed field which uses
a complex if statement using isnumber datawindow function and basically
create computed fields which represents the number portion and the letter
portion(this wouldn't be too difficult, considering the field length is
probably only 10 or...Sort only sorts current page???
If there is more than 1 page returned from the HTMLDW and .SetSort/.Sort is
called the current page is sorted. Great, but when ScrollNextPage is called
the data reverts back to the original sort. Apparently the sort criteria is
not maintained in Jaguar. We did a describe anf the sort definition is lost
the next time the page is loaded.
How can we have the sort order maintained after SetSort() ScrollNextPage()?
Thanks but not the best solution, I think.
For example, the first retrieve has a page of data sorted by column1.
Execute sort and page1 has a different ...Sort in DW
I built a DW who contents a column with a code of product.
But i display a Designation of product via a Drop
How can i sort the result on the designation of the product.
Not on the code. I do this to avoid a jointure.
Thanks for your help.
Check out LookupDisplay() in the help
<Allo> wrote in message news:firstname.lastname@example.org...
> Hi Everybody,
> I built a DW who contents a column with a code of product.
> But i display a Designation of product via a Drop
> How can i sort the ...Sort
I would like to add sort to an existing script that was written by
someone else. I've taken an Intro to Perl class and a CGI-Perl
class. I can't understand the script AT ALL and at this point I've
written a bulletin board program, contact form/auto-email-responder,
as well as an apartment locator search and database program. The
script converts files in Pagemaker / text into html files. We want
to output the html files alphabetically, seemed simple but I can't
make heads or tails of it.
The script is about 700K but I could put it on a web page or send it
Name: An Almost Satisfied User
Would you please provide an option to keep all folders and sub-folders
sorted alphabetically all the time and keep them that way even when new
bookmarks are added. It is annoying to have to sort each folder separately.
Browser Details: Mozilla/5.0 (Macintosh; U; Intel Mac OS X 10.5; en-US; rv:1.9) Gecko/2008061004 Firefox/3.0
From URL: http://hendrix.mozilla.org/
I have a problem with retrieveasneeded and sort.
I have a dw with 35000 rows. I have specified retrieevasneeded for dw so
that data can been shown as it is got from the db.
But after retrieval i want user to select the column that
he wants to sort and then show result set in sorted order.
As setsort cancels the retrieveasneeded , it gets all rows and then sorts
and that takes up lot of time.
My question is ,How can i use retrieveasneeded and also
allow user to sorting after rows are retrieved from db.
Simple answer you can't. RetrieveAsNeeded is doing exactly w...sort
Hi, i have a dw_ and call the sort function. I don't want it to display all
the columns from the dw_ though. Is this possible?
yes, simply select the
in the datawindow painter
and delete them.
"John Kingan" <John.Kingan@ukgateway.net> schrieb im Newsbeitrag
> Hi, i have a dw_ and call the sort function. I don't want it to display
> the columns from the dw_ though. Is this possible?