2. PHPRunner General questions
  3. dropdowns on edit screen
This topic is locked

dropdowns on edit screen

 		9/12/2006 17:58:03
PHPRunner General questions
D
 drh author

Hi all,
Again, I know I resolved this before by finding the solution in this forum. For some reason, I cannot find the post again. <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=question&id=3381&image=1&table=forumtopics' class='bbc_emoticon' alt=':(' />
I have 2 fields that are dropdown boxes. Both have a default value, which when adding works correctly.
Now when I open up the edit screen, the contents of all my fields are there except the 2 dropdown boxes. I must reselect them each time I edit a record.
Once again, maybe this was on the forum before it crashed so many months back. If it is still on the forum and I am missing it, sorry.
Thanks in advance.

Dave
D
 		Dale 9/12/2006

Hi Dave,
Sounds like the issue is "what is stored in the database when you save the record.
If the data or data type in the database does NOT match any of the values in the picklist phprunner builds you will get that Please Select choice.
Add a new record, and then check the raw database to see if the value saved is as expected.
D
 		drh author 9/13/2006

Thanks Dale. It started coming back to me with your reply. You were 100% correct. Somehow, db field lengths were not large enough to handle the entered data. (hmmm how in the world did I do that???)
Anyway, changed the field lengths in the db and all is well. I will print this out for future reference.
Hey Dale, thanks for answering the same question twice. Pretty sure it was you who pointed me in the right direction last time. <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=reply&id=11042&image=1&table=forumreplies' class='bbc_emoticon' alt=':)' />
Thanks,

Dave