Multiple datasources, one webpage?

Ask a Question related to Coldfusion Database Access, Design and Development.

  1. #1

    Default Multiple datasources, one webpage?

    I have a MS Access database in which a have a daily query for each day of the
    year that shows tennis court reservations for that day. I have a website page
    for each day of the year. On each day I would like the website to show under
    each time slot section on the page up to the 6 court reservations. I have
    successfully created a recordset which gives me all the desired data for the
    one day, but in one large table with all the time slots. What I need to have
    each time slot have just their own courts. As a possible solution, I tried
    creating multiple recordsets from the same query with different perimeters to
    give me the different time slots. When I tried this, I was successful in
    getting the first time slot (8:00-9:15am) to show only the 8:00-9:15 courts,
    but when I attempted to create a second recordset which pulls only the
    9:15-10:30am from my database and put it in its own section lower on the same
    webpage, I always get error messages. Can someone help with this? Thank you
    very much!

    troach79 Guest

  2. Similar Questions and Discussions

    1. Use CF Datasources outside CF
      I need to create a JSP on the coldfusion server, and access coldfusion datasources in that JSP. Is there anyway to do this in CF6.1 or CF7. ...
    2. Dynamic Datasources?
      I am porting an app from PHP to CF. The app requires the functionality to perform queries on different databases. I cannot utilize the CF Admin as...
    3. Problem Adding Columns to multiple datasources?
      I am using 6.1 updated, MS Access 2003, Windows Webserver 2003. Can anyone see a problem with my code. I am trying to find a better way to update...
    4. 2 datasources in 1 CFQUERY
      Hello, Some of our Access tables are being moved to our SQL Server, while some remain in Access. I have two datasources that separate the SQL from...
    5. How to bind multiple datasources to one grid?
      How can I bind my grid to more than one datasource - that is the question. Right now I bind to a DataView table that has a single DataTable as its...
  3. #2

    Default Re: Multiple datasources, one webpage?

    Could you show what you want the output to look out? (Use the Attach Code feature to get your alignment correct. ) Also, what error message do you get?
    jdeline Guest

Posting Permissions

  • You may not post new threads
  • You may 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