DataAssist datepicker date to db help needed
Hi,
I need help inserting the date from a date picker created by a function. The function creates three dropdowns (month, day, year), but no matter what I try the mysql date remains 0000-00-00 in the database.
A group of older adults will use the datepicker in forms and want this style of datepicker because it's easy to use and read. I want to avoid using javascript or jquery because it adds another layer of code to the page that I (as a volunteer) don't have the time or experience to understand.
I have tried to combine the variables into one variable, tried to reformat the date variables as a mysql formated date, tried rearranging the code blocks, tried to ensure all the variables and code names matched, tried putting different values into the $WA_fieldValuesStr row, and tried solutions from the WA forum and Google. My level of knowledge about what I'm doing is limited and my understanding appears to be dropping by the minute.
The page I'm working on just has the datepicker on it because I want to get the datepicker working before adding it to larger forms. I used the WA Insert Single Record to create the insert. The insert appears to work---when the form submits the database shows a new row of 0000-00-00 and the page redirects to the results page. However, I can't capture the newly selected date to correctly reenter the date into mysql when the form submits.
The database table (datepicker) has two columns: an auto-incrementing ID column DatePickerID (small int, length 3, key) and a date column DatePicked (date, NOT NULL). The date needs to be NOT NULL because the forms will be referenced to, and searched by date. I couldn't find an explanation of how the $WA_columnTypesStr = row works to check that row in the insert form.
I hope that someone at WA might be able to take a look at my files and lead me out of the woods. I enclosed both the date picker and the results page in the zip file. The files are working copies before I tried different code changes. Thank you for your time and attention.