I'm building a ColdFusion image viewing app that needs to be able to automatically insert an image link to an SQL database each day and automatically update the image selection form with that date. The image file names are date based so they are predictable and there will only be one new image each day. I want the past images to be selectable through the image selection form so that the user can select a year and month and day to view an image. The image itself will be generated manually so ColdFusion does not need to be involved in image creation.
Does anyone have an idea of how this can be accomplished in ColdFusion?