Set database with a drop down list

@number7Nov 02.2006 — #You should use [B]onchange[/B] event in your <select> element like:

<onchange='form.submit()'> and then fill the list with some data from a database you selected.

That's the way I understand what you need. Am I right ?

@yuling86authorNov 02.2006 — #<select name="database" method="get">

<option name="db">-----</option>

<option name="db" 
  <% OpenCMDBConnection CMDBConn 
   SET rs = CMDBConn.Execute("SELECT Name FROM Company") %>
   value="cmdb">CM </option>
 
  <option name="db" value="ipcdb">IPC</option>
 
  <option name="db" 
  <% OpenIVRDBConnection IVRDBConn 
   SET rs = IVRDBConn.Execute("SELECT Name FROM Organization") %>
   value="ivrdb">IVR </option>
 
  <option name="db" 
  <% OpenMLDBConnection MLDBConn 
   SET rs = MLDBConn.Execute("SELECT m_companyName FROM ContactList") %>
   value="mldb">ML </option>
 
  <option name="db" 
  <% OpenSCMDBConnection SCMDBConn 
   SET rs = SCMDBConn.Execute("SELECT Name FROM System_Company") %>
   value="scmdb">SCM </option>

</select>

I found some codes and I modified abit but only the last database data is captured. I think my codes are wrong because i dont even need to choose from the drop down list. Do I need some function to get the coding work???

Set database with a drop down list

2 Comments(s) _↴

Also in #JavaScript _↴

Success!

Social

Version

Set database with a drop down list

2 Comments(s) ↴

Also in #JavaScript ↴

Success!

The web is an endless sea of information. Don't miss the boat... Subscribe!

Social

Version

2 Comments(s) _↴

Also in #JavaScript _↴