I have a page I use to update entries in my database in which I keep my students’ assignments. I have various dropdowns and other input fields that I populate on a live page on my site.
When I submit with the “new” action, some of the times I see a new entry, and other times, it appears to have overwritten a previous entry. I am not sure how this would happen if I have various fields assigned but am using the “new” action.
Any ideas as to how/why I am experiencing this or how to avoid or figure out what’s happening.
thanks!
I was having a similar problem on a page where I was both querying my collection to prepopulate some form elements and then writing user input elements back to the collection. I found that changing the associated dataset parameter to “write only” fixed the problem for me.
Thanks, Brian, I’ll see if this might help me.
what to do if i need the database to be read also because it’s displayed?
Use separate pages to read and write info. Or if you are using the same page, then have two different datasets, one to read and one to write data. Then use code to refresh the read dataset when a new item is added.