Dynamic list selection problems 1

rotschreck · Jun 5, 2000

Hey there. I am working on trying to get some combo boxes to select a selection list in another selction list. So far the code seems to be ok except that it doesn't work. ... so obviously I missed something. As far as I can see, it has something to do with the FillArray command on line 39, as after that line, nothing prints to the screen. Here's the code and thanks in advance for any help you can offer: ____________________________________________________________ <%@ Language=VBScript %> <% Option Explicit %>   <% DIM Conn, rsPrimary, rsSecondary, intFirstPub, DB_CONNECTIONSTRING, objRecordset  ' Put your connection information here.  'Set Conn = Server.CreateObject("ADODB.Connection&quot

DB_CONNECTIONSTRING = "DRIVER={Microsoft Access Driver (*.mdb)};DBQ=" & Server.Mappath("mndm.mdb&quot

& ";" Conn = "DRIVER={Microsoft Access Driver (*.mdb)};DBQ=" & Server.Mappath("mndm.mdb&quot

& ";"  SET rsPrimary = Server.CreateObject("ADODB.RecordSet&quot

SET rsSecondary = Server.CreateObject("ADODB.RecordSet&quot

Set objRecordset = Server.CreateObject("ADODB.Recordset&quot

%> <HTML> <HEAD> <TITLE>Help </TITLE></HEAD> <BODY> <% objRecordset.Open "withdrawalsReopenings", DB_CONNECTIONSTRING, adOpenStatic, adLockPessimistic, adCmdTable rsPrimary.Open "SELECT primid, primpurp FROM purpose1 ORDER BY primpurp", Conn IF NOT (rsPrimary.BOF AND rsPrimary.EOF) THEN    intFirstPub = rsPrimary("primid&quot

ELSE    intFirstPub = 0 END IF rsSecondary.Open "SELECT primid, secid, secpurp FROM purpose2 ORDER BY primid, secpurp", Conn FillArray "arrpurpose2", rsSecondary, "primid", "secid", "secpurp" %> <CENTER> <H2>Dynamic Select List</H2> <FORM> <TABLE WIDTH=100%> <TR>  <TD>Primary List: <%SelectBox rsPrimary, "lstpurpose1", "primid", "primpurp", "lstpurpose2", "arrpurpose2" %>  </TD>  <TD>Secondary List: <%    rsSecondary.Filter = "primid = '" & intFirstPub & "'"    SelectBox rsSecondary, "lstpurpose2", "secid", "secpurp", "", " "    rsSecondary.Filter = adFilterNone %>  </TD> </TR> </TABLE> </FORM> </CENTER> </BODY> </HTML> <a href=mailto: > </a> <a href=

http://www.geocities.com/siltharin>Rotschrck's

Eclectic Page</a>

NickBulka · Jun 5, 2000

This example may help: <A HREF="

http://www.zdnet.com/devhead/resources/scriptlibrary/javascript/scripts/0334/index.html"

TARGET="_new">

http://www.zdnet.com/devhead/resources/scriptlibrary/javascript/scripts/0334/index.html</A>

nick bulka <a href=mailto: > </a> <a href= > </a>

rotschreck · Jun 5, 2000

pretty good code. Unfortunately, I'm working with tables and I think that some of the FillArray just doesn't work with the tables. All the tables are in Access. <a href=mailto: > </a> <a href=

http://www.geocities.com/siltharin>Rotschrck's

Eclectic Page</a>

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!

Dynamic list selection problems 1

rotschreck

Programmer

NickBulka

Programmer

rotschreck

Programmer

Similar threads

Part and Inventory Search

Sponsor