to optimize the code-urgent
Could anyone give me the optimized solution for my query
I have table called Appl_tbl with 4 columns
ENo eName ecopies category
I need to display the data from tha above mentioned table.
depends upon the category I need to display static Heading
category are mgr,acc,clr,trn and are fixed
if mgr means "The List holds the details of mgr and their ......"
here i wrote the code like
strSql="Selec..... from tbl"
'pass the recordset
rs.filter = " category= mgr"
if not rs.eof then
'display the static message
while not rs.eof
response.write rs(0) & "-" rs(1)
like the above sub i wrote 3 sub for categories and filter the category and displayed
is that code optimized or wat else i should do for performance and readability