A few weeks ago I wrote a blog post about using jQuery and JSON to automatically load data from a JSON file in to name-matched controls on an HTML page.
It is only now that I realise quite how powerful this is!
The great thing about it is that you do not have to edit your data-load function if you add a new field to the database. Because the jQuery function loops through all the fields in the JSON data, it will automatically insert the values in to the correct fields, providing those fields are named the same as the html form controls.
Here is the code again for those who dont want to check back.
$.getJSON("/yourJson.js, function(myJson){ $.each(myJson.rows, function(i,item) { for (prop in item) { $('#' + prop).val(item[prop]); } }); });