This is my first time using this platform and have a problem with the dropdown input type. If I use the following code:
Dropdown field type problem
- Single Page
Posted 08 November 2017 - 19:02 PM
Posted 09 November 2017 - 04:17 AM
Well my friend,
very 1st thing - can you update me on 1 thing - is there a field (agency) stored in the table? if so, can you cross check if the relevant value is going into the table during insert?
1 thing - if you always have this static values - then i will rather recommend u change the field to enum. If you anyways going to store just IDs - then u better have another table to which u join in with relation.
Posted 09 November 2017 - 12:21 PM
Amit, thanks for your help. I do have a field 'agency' and I will only have a small number of possible values stored there, so thought it overkill to have a table with just 4 or 5 values. I think I may have this working. The field 'agency' is a type varchar(20) and I think my original code was storing a numeric value there. I chanced it to the following and it seems to be working now.
I know just enough to be dangerous :)