4 Replies Latest reply on Aug 15, 2013 8:32 AM by straffenp

    Check form input against a list of data

    straffenp

      Hi all,

       

      I apologize in advance if I don't use the proper terminology here.  What I'm trying to do is rather simple, I think, but it's not something I've done before.  I have a short list of dates in a DB table.  Upon a user inputting a date into a form field and submitting it, I would like CF to check the date the user entered against the list of dates in the table.  I'd like to be able to create a cfif/cfelse statement if the input date matches any one of the table dates. Can someone point me in the right direction?

       

      Thanks!