|
| » Our Members & Brokers |
|
Our Members & Brokers
|
|
|
| Our Members & Brokers |
| Mm.
No. |
Clearing Members |
<%
set dbconn=getDB()
DIM sqlStr1
sqlStr1 = "SELECT * FROM ourmembers_new where memberlist='Clearing Members' order by mnmno asc"
Set rs1 = Server.CreateObject("ADODB.Recordset")
rs1.cursortype=1
rs1.Open sqlStr1, dbconn
While not rs1.EOF
%>
| <%=rs1("broker_code")%> |
<%=rs1("ourmember")%> |
<%
rs1.MoveNext
wend
%>
| |
| Broker Code |
Brokers |
<%
set dbconn=getDB()
DIM sqlStr
sqlStr = "SELECT * FROM ourmembers_new where memberlist='Non Clearing Members' order by mnmno asc"
Set rs = Server.CreateObject("ADODB.Recordset")
rs.cursortype=1
rs.Open sqlStr, dbconn
ibro=1
While not rs.EOF
%>
|
<%=rs("broker_code")%> |
<%=rs("ourmember")%> |
<%
rs.MoveNext
ibro=ibro+1
wend
%>
|
|
|
|
|