ADO returns EOF

[Tausif Alam]

Dear All,

I need your help again....

I have to run followin query from ASP page via ADO. This query returns me 10
results from Access Query but via ADO (asp page) its shoping me EOF=TRUE
means no record found. The other criteria is working fine but this one is
not working.. could you please let me know where I am doing mistake


SELECT transactions.Priority, transactions.ID, transactions.[Problem No] as
TicketNo, transactions.Company, transactions.Media, transactions.[Date
Request] as DateRequest, transactions.[Support area] as SupportArea,
transactions.ProblemDesc, transactions.Consultant1,
transactions.Consultant2, transactions.Consultant3, transactions.[Assigned
to] as assignedto, transactions.CompleteDate, transactions.Status,
transactions.billable FROM transactions WHERE transactions.ProblemDesc like
'*motshare*';

 

[John Viescas]

When you use ADO from Access, it usually "fixes" wildcards for you. When
you use it outside Access, you must use ANSI syntax:

WHERE transactions.ProblemDesc like '%motshare%';


--
John Viescas, author
"Microsoft Office Access 2003 Inside Out"
"Running Microsoft Access 2000"
"SQL Queries for Mere Mortals"
http://www.viescas.com/
(Microsoft Access MVP since 1993)