#Fruit# Another oprtion is to query...Please help! [allowsmilie] => 1 [showsignature] => 0 [ipaddress] => [iconid] => 0 [visible] => 1 [attach] => 0 [infraction] => 0 [reportthreadid] => 0 [isusenetpost] => 1 [msgid] => [ref] => [htmlstate] => on_nl2br [postusername] => MaxSommer [ip] => webforumsuser@m [isdeleted] => 0 [usergroupid] => [membergroupids] => [displaygroupid] => [password] => [passworddate] => [email] => [styleid] => [parentemail] => [homepage] => [icq] => [aim] => [yahoo] => [msn] => [skype] => [showvbcode] => [showbirthday] => [usertitle] => [customtitle] => [joindate] => [daysprune] => [lastvisit] => [lastactivity] => [lastpost] => [lastpostid] => [posts] => [reputation] => [reputationlevelid] => [timezoneoffset] => [pmpopup] => [avatarid] => [avatarrevision] => [profilepicrevision] => [sigpicrevision] => [options] => [akvbghsfs_optionsfield] => [birthday] => [birthday_search] => [maxposts] => [startofweek] => [referrerid] => [languageid] => [emailstamp] => [threadedmode] => [autosubscribe] => [pmtotal] => [pmunread] => [salt] => [ipoints] => [infractions] => [warnings] => [infractiongroupids] => [infractiongroupid] => [adminoptions] => [profilevisits] => [friendcount] => [friendreqcount] => [vmunreadcount] => [vmmoderatedcount] => [socgroupinvitecount] => [socgroupreqcount] => [pcunreadcount] => [pcmoderatedcount] => [gmmoderatedcount] => [assetposthash] => [fbuserid] => [fbjoindate] => [fbname] => [logintype] => [fbaccesstoken] => [newrepcount] => [vbseo_likes_in] => [vbseo_likes_out] => [vbseo_likes_unread] => [temp] => [field1] => [field2] => [field3] => [field4] => [field5] => [subfolders] => [pmfolders] => [buddylist] => [ignorelist] => [signature] => [searchprefs] => [rank] => [icontitle] => [iconpath] => [avatarpath] => [hascustomavatar] => 0 [avatardateline] => [avwidth] => [avheight] => [edit_userid] => [edit_username] => [edit_dateline] => [edit_reason] => [hashistory] => [pagetext_html] => [hasimages] => [signatureparsed] => [sighasimages] => [sigpic] => [sigpicdateline] => [sigpicwidth] => [sigpicheight] => [postcount] => 5 [islastshown] => [isfirstshown] => [attachments] => [allattachments] => ) --> sorting - Macromedia ColdFusion

sorting - Macromedia ColdFusion

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]...

  1. #1

    Default Re: Sorting

    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]
    John Vinson Guest

  2. #2

    Default Sorting

    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


    Gary Nelson Guest

  3. #3

    Default Sorting

    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 Guest

  4. #4

    Default Re: Sorting

    hehe nevermind, i figured it out!!!


    analblas667t webforumsuser@macromedia.com Guest

  5. #5

    Default sorting

    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!

    MaxSommer Guest

  6. #6

    Default Re: sorting

    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>

    tbuntel Guest

  7. #7

    Default Sorting

    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?
    Arne Guest

  8. #8

    Default Re: Sorting

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

    "Arne" <Arnediscussions.microsoft.com> wrote in message
    news:CAEA262C-8617-4653-91C8-A3F5A56B5D9Cmicrosoft.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?

    Patrick.O.Ige Guest

Similar Threads

  1. Sorting array vs sorting paginated array
    By limitedwave777 in forum Macromedia Flex General Discussion
    Replies: 0
    Last Post: May 14th, 01:58 PM
  2. Sorting XML
    By CUA web dev in forum Coldfusion - Advanced Techniques
    Replies: 0
    Last Post: May 18th, 01:35 PM
  3. PHP Sorting
    By J J in forum PHP Development
    Replies: 7
    Last Post: August 29th, 05:06 PM
  4. Help with sorting... please.. :)
    By Sarah in forum ASP Database
    Replies: 1
    Last Post: July 21st, 08:30 AM
  5. Sorting in SQL
    By Jacco Schalkwijk in forum Microsoft SQL / MS SQL Server
    Replies: 0
    Last Post: July 9th, 08:11 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139