I'm working in interdev creating ASP pages. I've created forms that will interface with a SQL database but I can't figure out how to create a combobox. The combobox is needed so that a user could enter a new name or select one from the list. Drop-down lists simply don't have the functionality that I need, does anyone know how to create a combobox?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Creating Combo Boxes in InterDev ASP pages
- Thread starter jms1885
- Start date
<OBJECT classid=CLSID:8BD21D30-EC42-11CE-9E0D-00AA006002F3 id='blah' style='WIDTH: 62px; HEIGHT: 19px'></OBJECT>
This is a vb like combo box.
here is a microsoft link for using it.
This is a vb like combo box.
here is a microsoft link for using it.
- Thread starter
- #3
- Thread starter
- #5
- Thread starter
- #7
Adding/using a ListboxDTC to do comboboxes is pretty easy. Honest. And it gives a handy object model for traversing the list, adding in extra items etc.
Add a database connection via the Global.ASA (right click it!)
Add a recordset DTC to your page. Put in parameters as question marks (?) in the where clause. And test it. Set the recordset to NOT auto-open (third tab) if it has parameters.
Add a listboxDTC, pick the recordset, and the two columns on the SECOND parameter tab.
Add a PageObjectDTC. This makes life a tiny bit easier.
You can now add a function that runs each time the page opens:
Sub thisPage_onenter()
if thisPage.firstEntered then
'page initialisation
'populate combo boxes...
' passing in any parameters...
'rsList.setParameter 0, "a value"
rsList.open
'combo box will now be populated, so rs can be closed
rsList.close
'add any additional items...
cmbMyCombo.addItem '<please select>', -1, -1
end if
end sub
The item list is only fetched once from the database, and is cached as a hidden field on the page - so you only need to open the recordset once.
If you need to refresh the combo-list then you must clear the list first (cmbMyCombo.clear) before re-opening the recordset.
The (Content Management)
Add a database connection via the Global.ASA (right click it!)
Add a recordset DTC to your page. Put in parameters as question marks (?) in the where clause. And test it. Set the recordset to NOT auto-open (third tab) if it has parameters.
Add a listboxDTC, pick the recordset, and the two columns on the SECOND parameter tab.
Add a PageObjectDTC. This makes life a tiny bit easier.
You can now add a function that runs each time the page opens:
Sub thisPage_onenter()
if thisPage.firstEntered then
'page initialisation
'populate combo boxes...
' passing in any parameters...
'rsList.setParameter 0, "a value"
rsList.open
'combo box will now be populated, so rs can be closed
rsList.close
'add any additional items...
cmbMyCombo.addItem '<please select>', -1, -1
end if
end sub
The item list is only fetched once from the database, and is cached as a hidden field on the page - so you only need to open the recordset once.
If you need to refresh the combo-list then you must clear the list first (cmbMyCombo.clear) before re-opening the recordset.
The (Content Management)
- Status
Similar threads
- Locked
- Question
- Locked
- Question