I'm newer to database. Is there anyone who familiar with using ASP from
ThumbPlus using access database ?

is there anything wrong in my script?

<%@LANGUAGE="JAVASCRIPT"%>
<!--#include file="Connections/connthumbsaccess.asp" -->
<%
var rsTaiLong = Server.CreateObject("ADODB.Recordset");
rsTaiLong.ActiveConnection = MM_connthumbsaccess_STRING;
rsTaiLong.Source = "SELECT * FROM Thumbnail WHERE Thumbnail.annotation like
'%??%' ORDER BY Thumbnail.name";
rsTaiLong.CursorType = 0;
rsTaiLong.CursorLocation = 2;
rsTaiLong.LockType = 1;
rsTaiLong.Open();
var rsTaiLong_numRows = 0;
%>
<%
var Repeat1__numRows = 10;
var Repeat1__index = 0;
rsTaiLong_numRows += Repeat1__numRows;
%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
"http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=big5">
<title>Untitled Document</title>
</head>

<body>
<table width="95%" border="0">
<tr align="left">
<th width="27%" scope="col">Name</th>
<th width="26%" scope="col">Thumbnail</th>
<th width="32%" scope="col">Annotation</th>
<th width="13%" scope="col">Date</th>
<th width="2%" scope="col">&nbsp;</th>
</tr>
<% while ((Repeat1__numRows-- != 0) && (!rsTaiLong.EOF)) { %>
<tr>
<td><%=(rsTaiLong.Fields.Item("name").Value)%></td>
<td><%=(rsTaiLong.Fields.Item("thumbnail").Value)% ></td>
<td><%=(rsTaiLong.Fields.Item("annotation").Value) %></td>
<td><%=(rsTaiLong.Fields.Item("file_time").Value)% ></td>
<td>&nbsp;</td>
</tr>
<%
Repeat1__index++;
rsTaiLong.MoveNext();
}
%>

</table>
</body>
</html>
<%
rsTaiLong.Close();
%>

Other, how to i use the script below for ASP

To find all thumbnails without any of several keywords:

not exists (select idThumb from (keyword inner join thumbnailkeyword on
keyword.idKeyword = thumbnailkeyword.idKeyword) where keyword.keyword
in('kwd1', 'kwd2', 'kwd3') and thumbnailkeyword.idThumb = TN.idThumb)