%
title="契約画家"
id=ld_checknum(request("id"),1,"ID")
set rs=server.createobject("adodb.recordset")
sql="select * from koba_painter where id="&id
rs.open sql,conn,1,1
stitle=rs("title_jp")
pic=rs("pic")
ddate=rs("ddate")
hits=rs("hits")
memo=rs("memo_jp")
painterClass=rs("painterClass")
keywords=rs("keywords")
rs.close
set rs=nothing
conn.execute("update koba_painter set hits=hits+1 where id="&id)
if keywords<>"" then
web_keyword=keywords
end if
Objrs=Conn.Execute("Select Max(id) From koba_painter Where id < "& id & " and painterClass=" & painterClass )(0)
Objrs1=Conn.Execute("Select Min(id) From koba_painter Where id > "& id & " and painterClass=" & painterClass )(0)
If Not Objrs="" Then
MaxID=Objrs
Else
MaxID=0
End If
If Not Objrs1="" Then
MinID=Objrs1
Else
MinID=0
End If
%>
<%Set rs = Server.CreateObject("ADODB.RecordSet")
sql="select * from koba_PainterPic where Painterid="&id
rs.open sql,conn,1,1
if rs.eof and rs.bof then
%>