I have a question regarding to
the "Web FX Combo Box" that you recommend earlier:
I tested and it works well with a small amount of data, but I have a corporation table with 1,4016 records. When I try to use the Combo Box with this table, the Combo Box is very slow to populate the data and when you scroll and pick another record, it freezes.
* I also try to use <DIV> tag to specify different location to display the "Combo Box", it didn't work.
Here is my code with a small table of 11 records. You won't be able to run it, but you can take a look at the code;
<%@ Language=VBScript %>
<% option explicit %>
var varLocName, varLocID;
dim cn, rs, strSQL, strCorpName, lngCorpID, strlocName, lngLocID
// strSQL = "sp_sel_uncancelled_corporations"
strSQL = "select loc_id, loc_code, loc_name from location order by sort_order"
set cn = server.createobject("ADODB.Connection")
set rs = cn.execute(strSQL)
' set cn = nothing
' set rs = nothing
while not rs.eof
strLocName = rs("loc_name")
strLocName = left(strLocName,1) & Replace(trim(strLocName), "~", "`", 2)
strLocName = Replace(strLocName, "^^", " ")
lngLocID = rs("loc_id")
varLocName = '<%=strLocName%>';
varLocID = '<%=lngLocID%>';
new ComboBoxItem(varLocName, varLocID)
set cn = nothing
set rs = nothing
Thanks for your help,
Love all the creatures because of the creator.