<% qstockcode = request.form("stkcode") qstockname = request.form("stkname") qbroker = request.form("qbroker") qstart = request.form("qstart") qend = request.form("qend") if qstart<>empty and qend<>empty and qstart > qend then qstart = "" qend = "" end if if qend=empty or qend="" then qend = date() end if if qstart=empty or qstart="" then qstart = dateadd("m",-1,qend) end if set conn = GetConnection() if qstockcode<>"" then qstockcode = right("00000"&qstockcode,5) sql = "select * from NewHK_ProSuggest as sg left join NewHK_Broker as bro on sg.broker_id = bro.id_no where stk_code='"&qstockcode&"' and report_date between '"&qstart&"' and '"&qend&"' order by report_date desc" elseif qstockname<>"" then sql = "select * from NewHK_ProSuggest as sg left join NewHK_Broker as bro on sg.broker_id = bro.id_no where stock like'%"&qstockname&"%' and report_date between '"&qstart&"' and '"&qend&"' order by report_date desc" elseif qbroker<>"選擇查詢之證券行" and qbroker<>"" then sql="select * from NewHK_ProSuggest as sg left join NewHK_Broker as bro on sg.broker_id = bro.id_no where broker_id="&qbroker&" and report_date between '"&qstart&"' and '"&qend&"' order by report_date desc" elseif qstart<>"" or qend<>"" then if qend="" then qend = qstart end if if qstart="" then qstart=qend end if sql = "select * from NewHK_ProSuggest as sg left join NewHK_Broker as bro on sg.broker_id = bro.id_no where report_date between '"&qstart&"' and '"&qend&"' order by report_date desc" end if set rs = server.createobject("adodb.recordset") rs.open sql,conn,3,3 '-----分頁設定 page = trim(request.form("page")) if not isnumeric(page) then page = 1 if page <= 0 then page = 1 if not rs.eof then page = cint(page) rs.pagesize = 5 '-----每頁筆數 if page > rs.pagecount then page = rs.pagecount rs.absolutepage = page end if %> 元富企業網

<% if not rs.eof then for i = 1 to rs.pagesize %> <% rs.movenext if rs.eof then exit for next else %> <% end if %> <% if rs.pagecount > 0 then %> <%end if%>
<%=rs("STOCK")%>  (<%=rs("STK_CODE")%>)
<%=rs("SUGGEST_TYPE")%> 建議價 :   $<%=rs("SUGGEST_PRICE")%>
證券行 :   <%=rs("BROKER_NAME")%> 目標價 :   $<%=rs("TARGET_PRICE")%>
報告日期 :   <%=rs("REPORT_DATE")%> 現價 :   $<%=rs("NOW_PRICE")%>

沒有任何資料!!
 
可輸入其中一項資料查詢您要找的推介
股票編號: 
股票名稱: 
證券行:  
由   至  

<%if page = 1 then%> 第一頁 | 上一頁 | <%else%> 第一頁 | 上一頁 | <%end if%> <%if page = rs.pagecount then%> 下一頁 | 最後一頁 | <%else%> 下一頁 | 最後一頁 | <%end if%> 資料筆數 : <%=rs.recordcount%>    第 <%=page%> / <%=rs.pagecount%> 頁    跳頁:

回首頁
<% rs.close set rs = nothing conn.close set conn = nothing %>