<%sWhere = "" bannername = GetParam("banner") sWhere = "b_name=" & ToSQL(bannername, "Text") sOrder = "b_name" sSQL = "select * from profile where " & sWhere sSQL = sSQL & " order by " & sorder openrs rs, sSQL fldb_name = GetValue(rs, "b_name") fldm_no = GetValue(rs, "m_no") fldcontact_person = GetValue(rs, "contact_person") fldaddress = GetValue(rs, "address") fldtel_no = GetValue(rs, "tel_no") fldmobile = GetValue(rs, "mobile") fldfax = GetValue(rs, "fax") fldemail = GetValue(rs, "email") fldwebsite = GetValue(rs, "website") fldprofile = GetValue(rs, "profile") flddue_releases = GetValue(rs, "due_releases") fldunder_pro = GetValue(rs, "under_pro") fldreleased = GetValue(rs, "released") flddou = GetValue(rs, "dou") flddou = formatdatetime(flddou,1) %> <%=fldb_name%>
P R O D U C E R - P R O F I L E
 
Membership No :
 <%= ToHTML(fldm_no)%>
Company / Firm / Banner Name :
 <%= ToHTML(fldb_name) %>
Contact Person :
 <%= ToHTML(fldcontact_person) %>
Address :
 <%= ToHTML(fldaddress) %>
Telephone No :
 <%= ToHTML(fldtel_no) %>
Mobile No :
 <%= ToHTML(fldmobile) %>
Fax No :
 <%= ToHTML(fldfax) %>
E-Mail Address :
 <%= ToHTML(fldemail) %>
Web Site Adderss :
 <%= ToHTML(fldwebsite) %>
<% if not fldprofile="" then%> <% end if %> <% if not flddue_releases="" then%> <% end if %> <% if not fldunder_pro="" then%> <% end if %> <% if not fldreleased="" then%> <% end if %>
 COMPANY PROFILE:-
<%= ToHTML(fldprofile) %>
 PROJECTS DUE FOR RELEASE:-
<%= ToHTML(flddue_releases) %>
 PROJECTS UNDER PRODUCTION:-
<%= ToHTML(fldunder_pro) %>
 T.V. SERIALS / FILMS RELEASED:-
<%= ToHTML(fldreleased) %>
Modified On - <%= ToHTML(flddou) %>