<%
Set db = Server.CreateObject("adodb.connection" )
db.Open = "driver={mysql odbc 3.51 driver}; server=localhost; UID=username; pwd=userpass; db=dbismi;"
%><%
db.Execute "SET NAMES 'latin5'"
db.Execute "SET CHARACTER SET latin5"
db.Execute "SET COLLATION_CONNECTION = 'utf8_turkish_ci'"
%>

'verdiğin kodu şöyle uyguluyorum;

<%
id = request.querystring("katid")
set veri= db.execute("select * from film where katID="&id&"")
db.Open veri,Sur,1,3
if db.eof then
end if
%>

<h1
class="componentheading">film isim - <%= rs("filmadi" )%> </h1>

<%
Set db = Server.CreateObject("adodb.connection" )
db.Open = "driver={mysql odbc 3.51 driver}; server=localhost; UID=username; pwd=userpass; db=dbismi;"
%><%
db.Execute "SET NAMES 'latin5'"
db.Execute "SET CHARACTER SET latin5"
db.Execute "SET COLLATION_CONNECTION = 'utf8_turkish_ci'"
%>

'verdiğin kodu şöyle uyguluyorum;

<%
id = request.querystring("katid")
set veri= db.execute("select * from film where katID="&id&"")
if veri.eof then
veri yok
%>
<%
else
%>
<h1
class="componentheading">film isim - <%= veri("filmadi" )%> </h1>