really not a clue why this is doing this, i add my recordset to a dynamic table using dreamweavers dynamic table and it displays the results correctly.
data assist just ignores the WHERE clause and i get all the results.
as soon as i add the search to this recordset from data assist it ignores the WHERE clause.
any ideas why this is doing this? This is a VIEW i have created in database as i was told it can search VIEWS as i can produce a recordset from it.