|
|
|
|
俵ÀÌ / 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
>
>
> |
|
|
|