´ç½Å¿¡°Ô·Î ¶°³ª´Â ²Þ¼Ó¿©Çà - ²Þ¼Ó³ª¶ó(http://www.inyourdream.net) ÀÔ±¹Çϱâ | ¿µÁÖ±Ç ½Åû
  • ¸öºÎ¸² °ñ¶ó°ñ¶ó
  • ¼Ò±Ù¼Ò±Ù
  • µµ¶õµµ¶õ
  • ³«¼­¸¶´ç
  • Âø°¢ÇѾÆÀÌ
  • ¼ýÀÚ¸ÂÃß±â
  • ¼Ò¿øºô±â
  • ÈçÀû³²±â±â
  • ²Þ¼Ó¿©Çà
  • Ä£±¸Áý ³î·¯°¡±â
  • ¸ðµÎµå¸²´ÔÀÇ È¨
  • î¤éÞ´ÔÀÇ È¨
  • Çö¿ì´ÔÀÇ È¨
  • º°¾ÆÇØ´ÔÀÇ È¨
  • ÇÞ»ì´ÔÀÇ È¨
  • À̳ª´Ï´ÔÀÇ È¨
  • À¯¸®¾Ë´ÔÀÇ È¨
  • ³È³ÈÀÌ´ÔÀÇ È¨
  • ²ÀÁö´ÔÀÇ È¨
  • ´ë¼º´ÔÀÇ È¨
  • 俵ÀÌ / 2000-11-25 / ¿ÀÈÄ 5:06:24 / 203.255.3.190
    Á¶È¸¼ö : 117
    [Áú¹®] ÀÌ°ÍÁ» ºÁÁÖ¼¼¿ä...¤Ð.¤Ð
    > 俵´Ô ÀúµÎ 俵´ÔÀÇ ¹æ¸í·Ï ó·³ ¸¸µé¶ó°í
    > 俵´ÔÀÇ ¼Ò½º¸¦ ¹Þ¾Æ¼­ ÃÖ´ëÇÑ °£´ÜÇÏ°Ô
    > Çؼ­ ¸¸µé¾ú´Âµ¥¿ä...
    > 俵´ÔÀº °Ô½ÃÆÇ¿¡¼­ ¼­Ä¡ÈÄ ÆäÀÌ¡ ÇÒ¶§ ÆäÀÌ¡À»
    > ÀϹÝÀûÀ¸·Î ´ÙÀ½ 10°³ ÀÌÀü 10°³·Î ¾ÈÇϱ¸ select ·ç 1/ÃÑÆäÀÌÁö, 2/ÃÑÆäÀÌÁö ÀÌ·±½ÄÀ¸·Î ´ÙÀ½ÆäÀÌÁö·Î ³ÑÁÖÀݾƿä...ÀÏ¹Ý list¿¡¼­´Â ±¦ÂúÀºµ¥¿ä..
    > searchÈÄ search ÆäÀÌÁö¸¦ º¸¿©Áִ°ǵ¥¿ä...
    > Àú´Â search_result.asp¸¦ µû·Î ¸¸µé¾ú´Âµ¥¿ä..
    > ¿¡·¯°¡ ¶³¾îÁ®¼­¿ä... ÀÌ°ÍÁ» ºÁÁֽǼö ÀÖ³ª¿ä?
    >
    > ÁÙ 15
    > ¹®ÀÚ 3
    > doucment.list.searchString.value'Àº nullÀ̰ųª °³Ã¼°¡ ¾Æ´Õ´Ï´Ù.
    > ÀÌ·±½ÄÀ¸·Î ³ª¿À°Åµç¿ä...
    >
    > Çѹø ºÁÁֽǼö ÀÖ³ª¿ä...¤Ð.¤Ð ºÎŹµå¸³´Ï´Ù.
    >
    > search_result.asp
    > <%
    > search = request("search")
    > SearchString = request("SearchString")
    > Set db = Server.CreateObject("ADODB.Connection")
    > db.open("DSN=bbs;UID=sa;PWD=dnflwlq")
    >
    > SQL = "select * from guest3 where " & search & " like '%" & SearchString
    > & "%' "
    > SQL = SQL & " order by a_idx desc "
    >
    > Set rs = Server.CreateObject("ADODB.Recordset")
    >
    > rs.open SQL,db,1
    >
    > a_idx=rs("a_idx")
    >
    > searchname = search
    > searchname = replace(searchname,"a_title","±ÛÁ¦¸ñ")
    > searchname = replace(searchname,"a_name","À̸§")
    > searchname = replace(searchname,"a_content","±Û³»¿ë")
    >
    > ScrollAction=Request("ScrollAction")
    >
    > Stop_Flag=0
    >
    > a_page = 5
    > rs.PageSize = a_page
    >
    > V_Total=rs.Recordcount
    >
    > if ScrollAction="" then
    > Page_Count=1
    > V_Index=V_Total
    > else
    > Page_Count=ScrollAction
    > V_Index=V_Total-(Page_Count*a_page)+a_page
    > end if
    >
    > if Not rs.EOF then
    > rs.AbsolutePage=Page_Count
    > end if
    >
    > V_Page=Int(V_Total/a_page)+1
    >
    > if (V_Total mod a_page)=0 then
    > V_Page=V_Page-1
    > end if
    >
    >
    > %>
    >
    >
    >
    > »ç°ú¶ì °Ë»ö°á°ú
    >
    >
    >
    >
    >

    > <% if rs.BOF or rs.EOF then %>
    >
    >


    >


    >

    > color="#FF80000">NO result!!
    >


    >

    <%=search%>¿¡¼­
    > <%=SearchString%>
    ·Î °Ë»öÀ»
    > ¼öÇàÇÏ¿´Áö¸¸


    >

    ¹ß°ß
    > µÈ

    > °Ë»ö°á°ú°¡ ¾ø½À´Ï´Ù.


    >


    >


    > <list·Î µ¹¾Æ°¡±â>


    >
    > <% else %>
    >

    > color="#008080">
    > Search List


    >
    >
    >

    >
    >

    >

    <%=searchname%
    > >
    ¿¡¼­
    > <%=SearchString%>
    ·Î °Ë»öÇÑ °á°ú<%=V_total%>°³ÀÇ µ¥ÀÌÅ͸¦
    > ã¾Ò½À´Ï´Ù.
    >


    >

    >
    >
    >
    >
    >

    > <% if V_Total>5 then%>
    >
    >
    >
    >
    >
    > <% end if %>
    >

    >

    > <%
    > RowCount=rs.PageSize
    >
    > do while not rs.EOF and Rowcount > 0 %>
    >

    >
    >
    >
    >
    >
    >
    >
    >
    >
    >
    >
    >
    >
    >
    >
    >
    >
    > src="../guest3/img2/left_up.gif"> > width="520" height="5"> > src="../guest3/img2/right_up.gif">
    > background="../guest3/img2/table_left.gif"> 
    "> > src="../guest3/img2/delete.gif" border="0">
    > <%=V_Index%>.<%=left(rs
    > ("a_date"),10)%> <%=rs("a_time")%>

    > <%if not rs("a_email")="" then%>
    > "> > src="../guest3/img2/mail.gif" border="0">
    > <% end if
    > if not rs("a_url")="http://" and not rs("a_url")="" then%>
    > " target="new"> > src="../guest3/img2/home-1.gif" border="0">
    > <%end if%>

    > <%=rs("a_name")%>´Ô²²
    > ¼­ <%=rs("a_ip")%>¿¡¼­ ³²±â½Å ¼ÒÁßÇÑ ±ÛÀÔ
    > ´Ï´Ù.

    >


    >
    > <%
    > a_contents = rs("a_contents")
    > a_contents = replace(a_contents,chr(13)&chr(10),"
    ")%>
    > <%=a_contents%>


     
    > src="../guest3/img2/left_down-1.gif"> > width="520" height="5"> > src="../guest3/img2/right_down-1.gif">

    >

    >
    > <%
    > RowCount=RowCount-1
    > V_Index=V_Index-1
    > rs.MoveNext
    > loop
    >
    > if rs.EOF then
    > Stop_Flag=1
    > end if
    >
    > end if
    > %>
    >
    >
    >

    >
    >
    >
    >
    >

    > <% if Page_Count > 1 then %>
    > > border="0" alt="´ÙÀ½¸ñ·Ï">
    > <% end if
    >
    > if Stop_Flag=0 then %>
    > > border="0" alt="ÀÌÀü¸ñ·Ï">
    > <% end if %>
    >
    > > border="0" alt="±Û¾²±â"> 
    >
    > > alt="¸®½ºÆ®">

    >

    >
    >
    >

    >
    >
    >
    >

    > ȍ
    > °ú¶ì¿¡°Ô ¸ÞÀϺ¸³»±â
    for more
    > information.

    >

    >
    >
    >
    >
    >
    > <%
    > rs.close
    > db.close
    > Set rs = Nothing
    > Set db = Nothing
    > %>
    >
    -----------------------------------------------------------

    ÅÂ±× ¶§¹®¿¡ ¼Ò½º º¸±â°¡ Èûµé±º¿ä....

    ´ÔÀº Áú¹® ÇÏ½Ã°í ¾î¶»°Ô º¸À̳ª ½Å°æÀ» ¾È ½á½Ã³ª º¸³×¿ä....

    Áú¹® ³»¿ë°ú ¿¡·¯ ³»¿ëÀ» ºÁ¼­´Â ¿ÀŸÀÏ °¡´É¼ºÀÌ ÀÖ½À´Ï´Ù.

    ÀÚ¼¼È÷ º¸¼¼¿ä... ±×·³....

    Byte * 200 Byte À̳»·Î ÀÔ·ÂÇϼ¼¿ä À̸§ : Æнº¿öµå :