Hi all,
I'm working on a site for a art gallery. They'll publish their exhibitons through a CMS.
I created a form that has three select (drop down) fields: day, month and year. Writing it into the database was easy enough (connect to a string with / as denominator and then use the dateformat in the insert sql code.
Now, they'll also be able to edit an existing exhibition, which means I'll have to display the opening date in the same manner. I'm a bit stuck now. How do I take the date format from the DB and split it into the three strings that I need (will use <cfif #openingDay# EQ 1> selected</cfif>, etc.).
Any recommendations, hints, codes for this?
Thanks a lot.
Adrian
I'm working on a site for a art gallery. They'll publish their exhibitons through a CMS.
I created a form that has three select (drop down) fields: day, month and year. Writing it into the database was easy enough (connect to a string with / as denominator and then use the dateformat in the insert sql code.
Now, they'll also be able to edit an existing exhibition, which means I'll have to display the opening date in the same manner. I'm a bit stuck now. How do I take the date format from the DB and split it into the three strings that I need (will use <cfif #openingDay# EQ 1> selected</cfif>, etc.).
Any recommendations, hints, codes for this?
Thanks a lot.
Adrian