| Personal Strategies |
<%count = 0
set rs = conn.Execute("SELECT * FROM Article WHERE status = 'Active' AND Service = 'Personal Strategies' ORDER BY Title")
If rs.BOF and rs.EOF Then%>
| No results found |
<%Else
Do While Not rs.EOF AND count = 0
%>
<%Response.Write(rs("Title").value)%>
<%Response.Write(rs("Description").value)%>
" target="_blank" class="admin">view the article |
<%rs.MoveNext
count = count + 1
Loop
End If
rs.close%>
| Display All |
|
|
|
| Business Strategies |
<%count = 0
set rs = conn.Execute("SELECT * FROM Article WHERE status = 'Active' AND Service = 'Business Strategies' ORDER BY Title")
If rs.BOF and rs.EOF Then%>
| No results found |
<%Else
Do While Not rs.EOF AND count = 0
%>
<%Response.Write(rs("Title").value)%>
<%Response.Write(rs("Description").value)%>
" target="_blank" class="admin">view the article |
<%rs.MoveNext
count = count + 1
Loop
End If
rs.close%>
| Display All |
|
|
|
| Estate & Wealth Transfer Strategies |
<%count = 0
set rs = conn.Execute("SELECT * FROM Article WHERE status = 'Active' AND Service = 'Estate & Wealth Transfer Strategies' ORDER BY Title")
If rs.BOF and rs.EOF Then%>
| No results found |
<%Else
Do While Not rs.EOF AND count = 0
%>
<%Response.Write(rs("Title").value)%>
<%Response.Write(rs("Description").value)%>
" target="_blank" class="admin">view the article |
<%rs.MoveNext
count = count + 1
Loop
End If
rs.close%>
| Display All |
|
|
|
| Employee & Executive Benefits |
<%count = 0
set rs = conn.Execute("SELECT * FROM Article WHERE status = 'Active' AND Service = 'Employee & Executive Benefits' ORDER BY Title")
If rs.BOF and rs.EOF Then%>
| No results found |
<%Else
Do While Not rs.EOF AND count = 0
%>
<%Response.Write(rs("Title").value)%>
<%Response.Write(rs("Description").value)%>
" target="_blank" class="admin">view the article |
<%rs.MoveNext
count = count + 1
Loop
End If
rs.close%>
| Display All |
|
|
|
| Asset & Income Protection |
<%count = 0
set rs = conn.Execute("SELECT * FROM Article WHERE status = 'Active' AND Service = 'Asset & Income Protection' ORDER BY Title")
If rs.BOF and rs.EOF Then%>
| No results found |
<%Else
Do While Not rs.EOF AND count = 0
%>
<%Response.Write(rs("Title").value)%>
<%Response.Write(rs("Description").value)%>
" target="_blank" class="admin">view the article |
<%rs.MoveNext
count = count + 1
Loop
End If
rs.close%>
| Display All |
|
|
|