Professional Web Applications Themes

CFCalendar & Sql - Coldfusion Flash Integration

Trying to do a query using the CFCalendar. After the user select the dates how do I pass the user select dates in my query? I have created 2 cf calendar for the user to select from Here's the query I want to use, but not sure how I would write the query statement. I would like to display the data as the user selects . Do I need to create a function on change, or do data binding ? Select * from Inventory where Date >= "1st Select Date" and Date < "2nd Selected Date"? Thanks, Jimmy...

  1. #1

    Default CFCalendar & Sql

    Trying to do a query using the CFCalendar. After the user select the dates how
    do I pass the user select dates in my query?

    I have created 2 cf calendar for the user to select from
    Here's the query I want to use, but not sure how I would write the query
    statement. I would like to display the data as the user selects . Do I need
    to create a function on change, or do data binding ?

    Select * from Inventory where Date >= "1st Select Date" and Date < "2nd
    Selected Date"?

    Thanks,
    Jimmy


    hhr_jb Guest

  2. #2

    Default Re: CFCalendar & Sql

    Invoking the cfquery will not work in client-side onchange() scripting because
    the selected date must be passed back to the server in order to process the
    query.
    CFML code is always processed on the server.

    LL@Work Guest

  3. #3

    Default Re: CFCalendar & Sql

    Thanks for your reply. Would you happen to know how this could be done? I've
    seen this worked on sites like this one. It's written in cfml.

    [url]http://reservations.ihotelier.com/onescreen.cfm?hotelID=2054[/url]

    Thanks,

    hhr_jb Guest

Similar Threads

  1. deactivating certain days via cfcalendar
    By sofioga in forum Coldfusion Flash Integration
    Replies: 0
    Last Post: July 26th, 08:16 PM
  2. cfcalendar Bug
    By Xuan Mai in forum Coldfusion Flash Integration
    Replies: 7
    Last Post: October 10th, 01:42 AM
  3. cfcalendar
    By alien3d in forum Coldfusion Flash Integration
    Replies: 4
    Last Post: July 8th, 01:38 AM
  4. Scoll by year in cfcalendar
    By JCox in forum Macromedia ColdFusion
    Replies: 2
    Last Post: June 30th, 03:35 AM
  5. cfcalendar component
    By Nick in forum Coldfusion Component Development
    Replies: 1
    Last Post: April 11th, 05:45 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