sorting

[John Vinson]

Gary,

Please repost WITHOUT the attachment. Many of us use dialup and
downloading 1433 lines wastes a lot of our time - especially since
very few folks will open a binary file from an unvouched source.

Describe your problem in text. You'll be much more likely to get a
reply.

John W. Vinson[MVP]
Come for live chats every Tuesday and Thursday
[url]http://go.compuserve.com/msdevapps?loc=us&access=public[/url]

[Gary Nelson]

In Access2000, I have a form which contains four different fields which our
shipping department utilizes. Publisher, Author, Location and Carton. The
shipping manager has requested that he be able to sort the form by each of
the fields individually by pushing a command button. For example, he may
one day push the command button labelled "Sort By Publisher" and have a
report appear, sorted by publisher. Another day, he may push the command
button labelled, "Sort By Author" and have a report appear sorted by author.

I have already replaced the header labels with command buttons.

My question is: How can I set up the form so that once the command button
on each of the fields is pushed, the sorted report will appear?

Thanks in advance,
Gary

[analblas667t webforumsuser@macromedia.com]

You know these tear-off flyers where they have phone number you can tear off at the bottom the flyer?

I alread made one but I want to sort the 'tear-offs' so that it's 1 inch between each boxed-phone number....

So how can I sort objects?

[analblas667t webforumsuser@macromedia.com]

hehe nevermind, i figured it out!!!

[MaxSommer]

Howdy,

I need to be able to sort a column name X (with .pdf and .html) ascending.
this might be a simple question but it gives me error.
I tried to do it as a structure ...please see code:

<CFSET Fruit=structnew()>


<cfset Fruit.binary = "theSummary">
<cfset Fruit.html = "theURL" >


<cfoutput>
<cfdump var="#Fruit#">
<table cellpadding="2" cellspacing="2">
<tr>

<td><b>Fruit</b></td>
</tr>
<!--- Use cfloop to loop through the Fruit structure.
The item attribute specifies a name for the structure key. --->
<cfloop collection=#Fruit# item="i">
<tr>

<td>#Fruit#</td>
</tr>
</cfloop>
</table>
</cfoutput>



Another oprtion is to query...Please help!

[tbuntel]

Hi! First, I would use a query object instead of a struct. That will let you
perform in-memory queries (Query of Queries) which are ideal for sorting.
Second, binary is not a good field name as it's also a datatype! Try this code
below. You can see how the sorting is accomplished with standard SQL.

<CFSET Fruit=querynew("summary, html", "VarChar, VarChar")>
<cfset queryAddRow(Fruit,2) />
<cfset querySetCell(Fruit,"summary","theSummary",1) />
<cfset querySetCell(Fruit,"html","theURL",1) />
<cfset querySetCell(Fruit,"summary","anotherSummary",2) />
<cfset querySetCell(Fruit,"html","anotherURL",2) />


<cfquery name="sortedFruit" dbtype="query">
SELECT *
FROM Fruit
ORDER BY summary ASC
</cfquery>


<table cellpadding="2" cellspacing="2">
<tr>
<td><b>Fruit</b></td>
</tr>
<cfoutput query="sortedFruit">
<tr>
<td>#summary# #html#</td>
</tr>
</cfoutput>
</table>

[Arne]

I have a datagrid which is sorted one way. I have to run through the dataset
and add some data.
When I am done I would like to change the sort order.
How can I do that?

[Patrick.O.Ige]

Arne try looking at this sample at:-
[url]http://www.dotnetjohn.com/articles.aspx?articleid=108[/url]
Hope that helps
Patrick

"Arne" <Arne@discussions.microsoft.com> wrote in message
news:CAEA262C-8617-4653-91C8-A3F5A56B5D9C@microsoft.com...

> I have a datagrid which is sorted one way. I have to run through the

dataset

> and add some data.
> When I am done I would like to change the sort order.
> How can I do that?