Professional Web Applications Themes

SORT BY DATE - Adobe Photoshop Elements

Is it possible when downloading images and then modifying them to include the date they were taken and have that figure (along with Name, Type, Size, etc) as one of the criteria by which they can be sorted? Thanks again. Sorry if this and the previous question seem obvious but I am new to this....

  1. #1

    Default SORT BY DATE

    Is it possible when downloading images and then modifying them to include the date they were taken and have that figure (along with Name, Type, Size, etc) as one of the criteria by which they can be sorted?

    Thanks again. Sorry if this and the previous question seem obvious but I am new to this.
    Andrew Turek Guest

  2. #2

    Default Re: SORT BY DATE

    Andrew,

    Use Windows Explorer (if on a PC) and use Details view. then just click on Date and it'll sort ascending by date (click date again and it'll sort decending by date). Then just Control A (Select All) and right click the blue selected area and click Print. Or Batch in Elements and the list should be in the same order as Explorer put them. It's just not going to be easy to find files if you keep that option set that way instead of by Alpha.

    Bob
    BobHill Guest

  3. #3

    Default Re: SORT BY DATE

    Let us know how you make out, Andrew.

    Bob
    BobHill Guest

  4. #4

    Default Re: sort by date

    This is a sort by date?
    order by view_terminations_report.#COOKIE.sortItem# #COOKIE.sortOrder#

    Dan Bracuk Guest

  5. #5

    Default Re: sort by date

    User either sort by Last name or date. Order by
    view_terminations_report.#COOKIE.sortItem# #COOKIE.sortOrder# is also for my
    next/previous links
    Here is the nessary code.

    <CFPARAM name="URL.sortOrder" default="DESC">
    <CFPARAM name="URL.sortItem" default="lastname">

    <CFPARAM name="URL.firstRec" default="1">
    <CFPARAM name="URL.lastRecord" default="0">

    <CFCOOKIE name="sortOrder" value="#URL.sortOrder#">
    <CFCOOKIE name="sortItem" value="#URL.sortItem#">


    <cfquery name="get_distance_name" datasource="#db#">
    select lastname, firstname, middlename, TerminationDate,
    lower(left(Term_Trans,3)) as Term_trans , status
    from view_terminations_report
    group by lastname, firstname, middlename, TerminationDate,
    lower(left(Term_Trans,3)), status
    order by view_terminations_report.#COOKIE.sortItem# #COOKIE.sortOrder#

    </cfquery>
    <table width="700" cellpadding="0" cellspacing="0" border="1"
    style="border-color:#6666CC" align="center">
    <tr>
    <th width="255" scope="col" class="r_text">Name&nbsp;&nbsp;
    <A href="terminations.cfm?sortItem=lastname&sortOrder =ASC"><IMG
    src="../images/ascending.gif" border="0" alt="Sort Last Name in Ascending
    Order"></A>&nbsp;&nbsp;&nbsp;<A
    href="terminations.cfm?sortItem=lastname&sortOrder =DESC"><IMG
    src="../images/descending.gif" border="0" alt="Sort Last Name in Descending
    Order"></A>
    </th>
    <th width="260" scope="col" class="r_text">Termination Date&nbsp;&nbsp;
    <A href="terminations.cfm?sortItem=TerminationDate&so rtOrder=ASC"><IMG
    src="../images/ascending.gif" border="0" alt="Sort Termination Date in
    Ascending Order"></A>&nbsp;&nbsp;&nbsp;<A
    href="terminations.cfm?sortItem=TerminationDate&so rtOrder=DESC"><IMG
    src="../images/descending.gif" border="0" alt="Sort Termination Date in
    Descending Order"></A>
    </th>
    <th>State</th>
    </tr>
    <cfoutput query="get_distance_name">

    <tr>
    <td scope="row" class="#class1#">#UCASE(lastname)#,#Ucase(firstnam e)#
    #Ucase(middlename)#</td>
    <td class="#class1#">#dateformat(terminationdate,'mm/dd/yyy')#</td>
    <td class="#class1#">#status#</td>
    </tr>
    </cfoutput>
    </table>

    kt03 Guest

  6. #6

    Default Re: sort by date

    So the user decide's how to sort? Fair enough.

    For both sorting orders, what are you expecting, and what are you getting?

    Also, does this really run without a comma between the two cookie outputs?
    order by view_terminations_report.#COOKIE.sortItem# #COOKIE.sortOrder#

    If you have debugging turned on, could you show us the query that gets sent to
    your database?

    Dan Bracuk Guest

  7. #7

    Default Re: sort by date

    As I said early user have the option either sort by lastname or date. Here is
    the query return from the debuging. ASC or DESC is depend on what image user
    click (A-Z or Z-A).

    If I cick on A-Z under header: NAME: then I have the query below and it's
    working fine

    select lastname, firstname, middlename, TerminationDate,
    lower(left(Term_Trans,3)) as Term_trans , status
    from view_terminations_report
    group by lastname, firstname, middlename, TerminationDate,
    lower(left(Term_Trans,3)), status
    order by view_terminations_report.lastname ASC

    If I cick on A-Z under header: : TerminationDate then I have the query below
    and it's not sorting correctly. I was sort by the date just like I already
    provided on previous post

    select lastname, firstname, middlename, TerminationDate,
    lower(left(Term_Trans,3)) as Term_trans , status
    from view_terminations_report
    group by lastname, firstname, middlename, TerminationDate,
    lower(left(Term_Trans,3)), status
    order by view_terminations_report.TerminationDate ASC

    If I do the hard code for date looki like this then it work but this is not
    what i am looking to do
    order by year(TerminationDate) desc, month(TerminationDate) desc,
    day(TerminationDate) desc

    kt03 Guest

  8. #8

    Default Re: sort by date

    So you are getting
    09/30/04
    09/30/04
    09/30/03
    09/30/99
    09/29/04
    09/28/05

    and you want
    09/28/05
    09/30/04
    09/30/04
    09/29/04
    09/30/03
    09/30/99
    Is that it?

    You also suggest that terminationdate is a date/time field right?
    (I have the dateformat from the database look like this "Sep 30 2004 12:00AM)

    If you do this:
    <cfquery name="q1">
    select distinct terminationdate from view_terminations_report
    </cfquery>
    <cfdump var="#q1#">

    What do your dates look like? Your problem might be that the veiw is
    converting your dates to a string.



    Dan Bracuk Guest

Similar Threads

  1. SQL Sort by date
    By Lee in forum MySQL
    Replies: 13
    Last Post: May 1st, 07:53 PM
  2. Sort by Date in Datagrid
    By ChicoBuffalo in forum Coldfusion Flash Integration
    Replies: 0
    Last Post: February 6th, 04:25 PM
  3. Sort by Date (Latest Date that is)
    By Speegs in forum Dreamweaver AppDev
    Replies: 1
    Last Post: March 11th, 12:48 PM
  4. datagrid sort by date
    By rsj@gisportalen.dk in forum ASP.NET Data Grid Control
    Replies: 0
    Last Post: January 19th, 07:00 PM
  5. Sort on Date Column
    By Alan Z. Scharf in forum ASP.NET Data Grid Control
    Replies: 1
    Last Post: December 5th, 09:38 PM

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