How do I pre-populate input fields with data retrieved from a database?
There are several solution. For example, you can send them over an URL with the syntax http://www.foo.com/calc.htm?bar=56 will set the field call bar to 56. You name cells in Excel. This assumes that you are prefilling an input cell. Here is a better solution that can be used to set any value. If you know ASP, the simplest solution is to take the HTML page, make it into a ASP-page over replace statements like p1A1 = 1234 with p1A1 = <%= reference to variable which contains the value for cell A1 on sheet 1 %> where 1234 is the default value that you set in Excel and which you want to read from the database instead. This solution also works for PHP.
Related Questions
- If I input data as "<5", the database knows to interpret this as not detected with a detection limit of 5? And then will calculate statistics based on 1/2 of the detection limit for this value?
- How do I pre-populate input fields with data retrieved from a database?
- Where does the database store data that I input into the database?
