Ask a Question related to Coldfusion Database Access, Design and Development.
-
troach79 #1
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
-
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. ... -
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... -
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... -
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... -
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... -
jdeline #2
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



Reply With Quote

