Like query is not populating a recordset in ASP

P

Peter

Following is the code I am trying to run. When the SQL
statement is copied from this page right into a query in
Access it comes up with several records. However when
running this ASP code the RS recordset returns EOF as if
it were empty.

Please help to figure this out

Thanks

The ASP Code:

<%@ Language=VBScript %>

<%
sql="select distinct a.transid, a.dateopened,
a.dateclosed, c.firstname as cfirstname, c.lastname as
clastname, e.name, f.comment from transaction a,
employeetransaction b, customer c, employee d, company e,
transactioncomments f where a.transid=b.transid and
a.custid=c.custid and b.empid=d.empid and
c.compid=e.compid and f.comment like '*Test*' and
a.transid=f.transid;"

set conn=server.CreateObject("ADODB.Connection")
conn.Open application("DSNstring")

set rs=server.CreateObject("ADODB.recordset")

rs.Open sql,conn,adOpenDynamic

do while not rs.EOF
Response.Write(rs.Fields.item("comment") & "<br")
rs.MoveNext
loop
%>
 
Top