[02/03] ASP.NET and SQL Query

Hi All,

I have written a SQL query that will join two tables together and select the required record.

When the query is executed via the webpage, the error message "Row handle is invalid" is returned. I have tested the query in Access 20007 Query designer and it returns the required record. I have pinpointed the problem at the "WHERE" clause.

Code:

SELECT TOP 1 [Audit.group], [Audit.position] FROM [Audit] INNER JOIN [Groups] ON (Audit.Group) = (Groups.GroupID) WHERE [Audit.ID] = " & fldID.Text & " ORDER BY [Audit.ChangeNo] DESC