asked on

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

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.

Michel Plungjan

That is not really asking a question, it is more the beginning of a spec for a project.
What leve of skills do you have? Can you code the db access or is that part of what you need help with? Can you make a start and ask specific questions?

HawthorneAdmin

ASKER

i can access the database, i need help with how to display the table(s) names and fields / column names in a multi tier dropdown list allowing the user to select the correct field and table for the specific input file(s). does this make more sense?

Michel Plungjan

I would start here

http://www.prodiven.com/jcombo/

ASKER CERTIFIED SOLUTION

Mark Brady

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

sammySeltzer

Ok, do you have connectionstring that can connect to the database in your .hta app?

About dropdowns, I am not really clear about how you are planning to go about it.

.hta app, as far as I know, is comprises a bunch of vbscript functions, js and css.

I don't believe it can be done using php but I could be wrong.