Professional Web Applications Themes

Filtering by today's date - Macromedia ColdFusion

Hi, I'm constructing an exhibitions list page....each entry has an opening date and closing date. The company wants (not sure why, but hey) all past exhibitions to stay in their database...so I obviously need to filter results out that have already taken place. So my question is....and bear in mind i'm practically a beginner please....how do I filter out results so that only exhibitions with a closing date after the present (today's) date are shown......and all those with a closing date before today are not pulled in?? Thanks in advance, Ben...

  1. #1

    Default Filtering by today's date

    Hi, I'm constructing an exhibitions list page....each entry has an opening
    date and closing date. The company wants (not sure why, but hey) all past
    exhibitions to stay in their database...so I obviously need to filter results
    out that have already taken place. So my question is....and bear in mind i'm
    practically a beginner please....how do I filter out results so that only
    exhibitions with a closing date after the present (today's) date are
    shown......and all those with a closing date before today are not pulled in??
    Thanks in advance, Ben

    benkayuk Guest

  2. #2

    Default Re: Filtering by today's date

    You can do that in you SQL query.
    Example:

    <cfquery name='getExhibitions' datasource='mydsn'>
    SELECT * FROM exhibitions where
    closingdate > #NOW()#
    </cfquery>
    sTg Guest

  3. #3

    Default Re: Filtering by today's date

    Thanks, worked straight off....note for beginners, but the WHERE clause before any ORDER BY statement. I made that mistake.

    Thanks again!
    benkayuk Guest

Similar Threads

  1. Help with Today's Date Display
    By kdennis4 in forum Macromedia Flex General Discussion
    Replies: 1
    Last Post: April 9th, 08:33 PM
  2. Prepopulate DateField with Today's Date
    By kdennis4 in forum Macromedia Flex General Discussion
    Replies: 5
    Last Post: April 8th, 07:10 PM
  3. filtering by Date in Recordset
    By cdlcruz in forum Dreamweaver AppDev
    Replies: 2
    Last Post: May 12th, 11:48 PM
  4. Update Access with today's date
    By Durwood Edwards in forum Macromedia Dynamic HTML
    Replies: 5
    Last Post: June 4th, 06:56 PM
  5. Code to put today's date into MM-DD-YY format
    By Ron in forum PERL Miscellaneous
    Replies: 13
    Last Post: July 22nd, 08:49 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