Last post Mar 24, 2016 07:49 AM by Mikesdotnetting
Mar 23, 2016 06:46 PM|rossmgreenberg|LINK
Color me "extraordinarily frustrated"
I have a simple Access database, sitting on a server called http://www.server.com, called database.mdb. Within it is a table called "table" that has two alphanumeric fields, called "address" and "state".
I have a simple HTML page with a simple select/option statement with a unique value for each option and with a simple Onchange function handler.
I want to be able to open the database retrieve the database record corresponding to the value, dissect the database record into its various fields and then be able to display on the HTML the address and state.
It sounds like it *should* be very easy. But I'm not having any luck. Could someone help me out and, even better, give me an illustrative example?
Mar 23, 2016 09:09 PM|Mikesdotnetting|LINK
You need server-side code to read from and to the database. Are you developing a Web Forms, MVC or Web Pages site?
Mar 24, 2016 12:10 AM|rossmgreenberg|LINK
Just a simple website, read access to 1-3 tables and write access to 1-3 other tables. Via Dreamweaver CS5 when possible.
Mar 24, 2016 07:49 AM|Mikesdotnetting|LINK
As I said, you need server side code to be able to connect to a database and read and write data. This forum isn't the right place to teach anyone how to get started with that from scratch, so you should first choose which server-side framework you want
to use (ASP.NET, PHP) and then start learning how to use it. If you choose ASP.NET, I recommend the
Web Pages option. It's very similar to PHP, although Dreamweaver doesn't support it. If you are wedded to Dreamweaver, try PHP.