´ç½Å¿¡°Ô·Î ¶°³ª´Â ²Þ¼Ó¿©Çà - ²Þ¼Ó³ª¶ó(http://www.inyourdream.net)
ID¿Í Password¸¦ ÀÔ·ÂÇϼ¼¿ä.
ÀÔ±¹Çϱâ
|
¿µÁÖ±Ç ½Åû
¸öºÎ¸² °ñ¶ó°ñ¶ó
¼Ò±Ù¼Ò±Ù
µµ¶õµµ¶õ
³«¼¸¶´ç
Âø°¢ÇѾÆÀÌ
¼ýÀÚ¸ÂÃß±â
¼Ò¿øºô±â
ÈçÀû³²±â±â
²Þ¼Ó¿©Çà
Ä£±¸Áý ³î·¯°¡±â
¸ðµÎµå¸²´ÔÀÇ È¨
î¤éÞ´ÔÀÇ È¨
Çö¿ì´ÔÀÇ È¨
º°¾ÆÇØ´ÔÀÇ È¨
ÇÞ»ì´ÔÀÇ È¨
À̳ª´Ï´ÔÀÇ È¨
À¯¸®¾Ë´ÔÀÇ È¨
³È³ÈÀÌ´ÔÀÇ È¨
²ÀÁö´ÔÀÇ È¨
´ë¼º´ÔÀÇ È¨
µî·ÏÇϽǶ§´Â ÇʼöÇ׸ñÀ» ¸ðµÎ ÀÔ·ÂÇÏ¼Å¾ß ÇÕ´Ï´Ù.
À̸§
*
HTML »ç¿ë
Á¦¸ñ
*
¼±ÅÃ
ÀÚÀÛ
»ç¶û
À¯¸Ó
ÀÚÀ¯
̵̧
¾Ë¸²
Áú¹®
±âŸ
³»¿ë
*
> »õÇØ ÜØ ¸¹ÀÌ ¹ÞÀ¸¼¼¿ä. > ´Ù¸§ÀÌ ¾Æ´Ï¶ó À̹ÌÁö ÆÄÀÏ ¾÷·Îµå Çϱ¸ > À̹ÌÁö ºñÀ²¿¡ °üÇÑ Áú¹®À» µå¸±±î ÇÕ´Ï´Ù. > À̹ÌÁö¸¦ Ãâ·ÂÇϴµ¥ >
> ÀÌ·¸°Ô width¿Í height¸¦ ÁöÁ¤ÇÏ¿© Ãâ·ÂÇϴµ¥¿ä. > À̹ÌÁö ÆÄÀÏ ¾÷·Îµå½Ã > ºñÀ²ÀÌ ¾È ¸Â´Ù°í ¸ÂÃß¾î ´Þ¶ó°í Çϳ׿ä. > Á¶±Ý Å« »çÁøÀÌ width°ª°ú height°ª¿¡ ÀâÇô¼ Àüü > À̹ÌÁö°¡ ¾È º¸Àδٸ鼿ä. > ¾î¶»°Ô Çϸé ÀßÇß´Ù°í ¼Ò¹®ÀÌ ³¯·±Áö.. > > [Àüü¼Ò½º] > <% > sCode = Request("sCode") > > Set Conn = Server.CreateObject("ADODB.Connection") 'DB¿¡ ¿¬°á > Conn.Open "***********" > > Set Rs = Server.CreateObject("ADODB.RecordSet") > SQL = "SELECT b.LocalName, a.SiteName, a.StDate, a.EnDate, a.InDate, a.Picture, a.Name, a.Prologue, a.Summary, a.Address, a.Telephone, a.PosPic FROM SiteInFo a, Local b WHERE (a.SiteCode = '" & sCode & "')" > Rs.Open SQL, Conn, 1 > > If Rs.Eof then > %> > > <% > Response.end > End If > > %> > > >
>
>
º®»ê °Ç¼³ °øÁö »çÇ×
> > > > > >
>
>
>
>
>
>
>
<%=Rs("SiteName")%>
>
>
>
>
>
>
>
>
>
>
> >
>
>
>
ÇöÀå ¼ÒÀå
>
<%=Rs("Name")%>
>
>
>
> <% > > If isNull(Rs("picture")) = TRUE then > Response.Write "»çÁø ¾ø½¿" > Else > %> >
" width="102"> > <% End If %> >
>
<%=Replace(Rs("Prologue"),chr(10),"
")%>
>
>
>
>
> >
>
> >
ÁÖ ¼Ò
> >
<%=Rs("LocalName")%> <%=Rs("Address")%>
>
>
>
ÀüÈ ¹øÈ£
>
<%=Rs("Telephone")%>
>
>
>
°ø»ç ±â°£
>
<%=Rs("StDate")%> - <%=Rs("EnDate")%>
>
>
>
°ø»ç °³¿ä
>
<%=Replace(Rs("Summary"),chr(10),"
")%>
>
>
> >
ÀÔÁÖ ¿¹Á¤ÀÏ
> >
<%=Rs("InDate")%>
>
>
>
>
>
> ¡¡ >
>
>
>
>
>
>
>
>
> <% > Set PRs = Server.CreateObject("ADODB.RecordSet") > SQL = "SELECT NewDate, ForePic FROM SitePic WHERE (SiteCode = '" & sCode & "') AND (ForePic IS NOT NULL) ORDER BY NewDate" > PRs.Open SQL, Conn, 3 > > If PRs.EOF Then > %> >
>
ÇöÀå¿ùº°
>
> <% Else > forePic="sitepic\" & PRs("forepic") %> >
>
ÇöÀå¿ùº°
> <% For nFor = 1 To PRs.RecordCount %> >
"><%=trim(Mid(PRs("NewDate"), 8, 5))%>
> <% > PRs.MoveNext > Next > End If > > %> >
>
>
>
>
>
> <% > Set SRs = Server.CreateObject("ADODB.RecordSet") > SQL = "SELECT Descript, RoomPic FROM SitePic WHERE (SiteCode = '" & sCode & "') AND (Descript IS NOT NULL)" > SRs.Open SQL, Conn, 3 > > If SRs.EOF Then > %> >
>
ÇöÀå ¼¼ºÎ »çÁø
>
> <% Else > Unit = "sitepic\" & SRs("RoomPic") %> >
>
ÇöÀå ¼¼ºÎ »çÁø
> <% For nFor = 1 To SRs.RecordCount %> >
"><%=SRs("Descript")%>
> <% > SRs.MoveNext > Next > End If > %> >
>
>
>
>
> <% > If forepic<>"" Then > %> >
> ÀÌ ºÎºÐÀÌ À̹ÌÁö¸¦ Ãâ·ÂÇÕ´Ï´Ù > width°ª°ú height°ªÀ» Á¦°ÅÇÏ¸é ´ç¿¬È÷ À¯µ¿ÀûÀ¸·Î > À̹ÌÁö°¡ Ãâ·ÂµÇ±¸¿ä... > > > > > <% > End If > %> >
>
> <% > > If Unit <> "" Then > %> >
> <% End If %> >
>
>
> <% > SRs.Close > PRs.Close > %> >
>
>
>
>
','','width=370,height=250');">
>
>
>
>
>
>
>
>
>
>
>
>
>
>
> <% > Set Crs = Server.CreateObject("ADODB.Recordset") > SQL = "SELECT b_board_idx, b_name, b_subject, convert(char(8), b_writeday) as b_writeday, b_re_level, b_ref FROM MBoard where b_sitecode='" & sCode & "' ORDER BY b_ref DESC, b_re_step asc" > > Crs.PageSize = 5 > Crs.Open SQL, Conn, 1 > %> >
>
>
¹øÈ£
>
Á¦ ¸ñ
>
ÀÛ¼ºÀÚ
>
ÀÛ¼ºÀÏ
>
> <% > If Not Crs.Eof Then > i = 1 > Do until Crs.EOF Or i > Crs.PageSize > if Crs("b_re_level") > 0 then > wid = 5 * Crs("b_re_level") > %> >
>
<%=i%>
>
&sitecode=<%=sCode%>"><%=Crs("b_subject")%>
>
<%=Crs("b_name")%>
>
<%=Crs("b_writeday")%>
>
> <% else %> >
>
<%=i%>
>
&sitecode=<%=sCode%>"><%=Crs("b_subject")%>
>
<%=Crs("b_name")%>
>
<%=Crs("b_writeday")%>
>
> <% end if > > Crs.MoveNext > i = i + 1 > loop > %> >
>
> <% > j=1 > > Do Until j > 10 or blockPage > int(Crs.pagecount) > If int(blockPage)=int(c_page) Then > %> >
[<%=blockPage%>]
> <% > > > else > %> >
[<%=blockPage%>]
> <% > End If > > blockPage = blockPage + 1 > j = j + 1 > Loop > Crs.close > %> >
>
>
>
> <% Else %> >
>
[
1
]
>
>
>
> <% End If %> >
>
>
>
> > <% > rs.Close > conn.Close > Set rs = Nothing > Set conn = Nothing > %> >
> > > > > -----------------------------------------------------------
Ãß°¡ÇÒ À̹ÌÁö¸¦ ÀÔ·ÂÇϼ¼¿ä.
À̹ÌÁö 1
À̹ÌÁö¼³¸í 1
Ãß°¡ÇÒ ÀڷḦ ÀÔ·ÂÇϼ¼¿ä.
ÀÚ·á 1
ÀÚ·á¼³¸í 1
Ãß°¡ÇÒ ½ÎÀÌÆ®¸¦ ÀÔ·ÂÇϼ¼¿ä.
°ü·Ã½ÎÀÌÆ® 1
½ÎÀÌÆ®¼³¸í 1
Password
*