troubleshooting Question

How To Display a list of Database field(s) in a HTA dropdown list using JavaScript

Avatar of HawthorneAdmin
HawthorneAdmin asked on
DatabasesJavaScriptHTML
5 Comments1 Solution828 ViewsLast Modified:
I created an HTML form with several different input fields. these input fields will have different database field / column names(input CompanyName = table1.field, input Address1 = table1.field, etc.). i need to be able to connect to a any type of database, the user will provide either a connection string or DSN in a few input fields on the HTML form. After i have the database info i will need to connect to the database and display in a drop down list the table name(s). After i have the table that the user will use i need to create a list in a drop down of all the fields / columns in that table. I will then allow the user to select different field / column names for each input in the form. i will also need a way for the user to select a different table if fields / columns are located in seperate tables (table1.Company, table2.email, table3.description_of_items). if the user selects more than one table i need to know which fields / columns join each table. All this needs to be dynamicly in my HTML form. I will be writing this in a HTA using HTML and JavaScript.

if you need any further info please let me know.

Any help would be appreciated.
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 5 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 5 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros