% set fso = Server.CreateObject("Scripting.FileSystemObject") set f = fso.OpenTextFile("C:\cons7.dat") strconnect = f.Readline set Dbcon=Server.CreateObject("ADODB.Connection") Dbcon.Open strconnect sql = "SELECT TITLE_YN, PhotoTitle, PhotoCaption, newskey,ImageFileName, svc_date, ImageTFileName FROM PHOTOBOOK_IMG where photo_id =" & request("photo_id") & " order by TITLE_YN asc" set rs=Dbcon.Execute(sql) sql5 = "SELECT hit_cnt AS cnt FROM PHOTOBOOK where PHOTO_ID =" & request("photo_id") set rs5=Dbcon.Execute(sql5) hit_cnt = rs5("cnt") hit_cnt = hit_cnt + 1 sql6 = "Update PHOTOBOOK set hit_cnt = " & hit_cnt & " where PHOTO_ID = " & request("photo_id") set rs6=Dbcon.Execute(sql6) %>
À§ ¿øº» À̹ÌÁö¿¡ ´ëÇÑ ÀúÀÛ±ÇÀº ½ºÆ÷Ã÷Á¶¼± °Ô½ÃÀÚ¿¡°Ô ÀÖÀ¸¸ç, À̸¦ ¹«´ÜÀ¸·Î »ç¿ëÇÏ´Â °æ¿ì ¹Î,Çü»ç»óÀÇ ¹ýÀûÀΠåÀÓÀ» ºÎ´ãÇÒ ¼ö ÀÖ½À´Ï´Ù.