3 Replies Latest reply on Jun 30, 2006 8:41 AM by Dan_K.

    If statements and cfquery

    Dan_K. Level 1

      Here is what I would like to do. I am in the process of building a calendar application. I know there are some commercial ones available but I would like to try to solve this on my own before I go that route. I have my calendar in html and to get the event days to match up with the calendar days this is what I am thinking. Preform a query on the database that returns all the records in DB between the first and the last day of the month. I would then write in each <td> an if statement that looks to see if the date has an event associated with it and if so set what I would like displayed as a variable and then display the variables. If not set the variables to blank. My questions is can I do it this way by running the results from the query against if statements. I tried it and I was able to get it to work for just one date but not for the other date. I do not have the page code in front of me, I will post that tomorrow. Any help with this will be greatly appreciated.

      Thanks in advance.

      Daniel Krajc