 |
<%
set Conn=server.createobject("adodb.connection")
Conn.ConnectionTimeout = 90
'Conn.connectionstring="Provider=SQLOLEDB.1;Data Source=localhost;User ID=sa;password=;Initial Catalog=dspml_db"
Conn.connectionstring= "Provider=SQLOLEDB.1;Data Source=202.144.75.84;User ID=dspmlmf;password=Aj8$Fja8A;Initial Catalog=dspml_db"
Conn.Open
set rsNav = server.CreateObject("Adodb.recordset")
rsNav.Open("select a.* from scheme_navs a, scheme_master b where a.schemeid=b.schemeid and a.schemeid in (12,13,14,7,8) and a.navdate in (Select TOP 1 NavDate from Scheme_NAVs order by NavDate desc) order by b.schemeshortname"),Conn,1,1
%>
| Nav as on <%=day(rsNav("NavDate")) & " " & monthname(month(rsNav("NavDate")),true) & " " & year(rsNav("NavDate"))%> |
| Fund |
NAV (in Rs.) |
<%
While not rsNav.EOF
If rsNav("SchemeId") = "12" Then%>
| DSPML BOND FUND - RETAIL PLAN (G) |
<%=formatnumber(rsNav("NavValue"),4)%> |
<%End IF
If rsNav("SchemeId") = "13" Then%>
| DSPML BOND FUND - RETAIL PLAN (D) |
<%=formatnumber(rsNav("NavValue"),4)%> |
<%End IF
If rsNav("SchemeId") = "14" Then%>
| DSPML EQUITY FUND |
<%=formatnumber(rsNav("NavValue"),4)%> |
<%End IF
If rsNav("SchemeId") = "7" Then%>
| DSPML LIQUIDITY FUND (G) |
<%=formatnumber(rsNav("NavValue"),4)%> |
<%End IF
If rsNav("SchemeId") = "8" Then%>
| DSPML LIQUIDITY FUND (D) |
<%=formatnumber(rsNav("NavValue"),4)%> |
<%End IF
rsNav.MoveNext
Wend
rsNav.Close
set rsNav = nothing
Conn.close
set Conn = nothing
' set fso=Server.CreateObject("scripting.filesystemobject")
' set file=fso.GetFile(server.MapPath("admin/infos.txt"))
' set tso=file.openastextstream(1)
' cnt=0
' do while not tso.AtEndOfStream
' col=split(tso.Readline,":")
' if cnt<5 then
' cnt=cnt+1
' Response.Write ""
' Response.Write "| " & "" & col(0) & " | " & "" & col(1) & " | "
' Response.Write " "
' end if
' loop
%>
|
More NAV's...
Mumbai - Corporate Office
DSP Merrill Lynch Ltd.
Mafatlal Centre, 10th Floor
Nariman Point
Mumbai 400 021. India
Tel: (91 22) 5632 8000 / 2280 4100
Fax: (91 22) 2282 1827
|
|
|
| Award - The Asset magazine voted DSP Merrill Lynch as "The best Domestic Equity House in India" |
|
|
|
| Independent Recognition - Asiamoney names DSPML Best Domestic Securities House. Best Investment Bank for 3rd time in a row says The Asset |
|
|
|
| News Release - Cholamandalam Investment and Finance Company Limited raises Rs. 1 billion. DSP Merrill Lynch and Standard Chartered Bank were the Joint Book Running Lead Arrangers to the transaction. |
|
|
|
| Philanthropy - View DSPML's bi-annual philanthropy newsletter. |
|
|
