Access Filter not working on an ASP page

[kav123]

I don't know whether this question should be asked here or in ASP, but i am giving it a try here.... I am calling an access query from my ASP page, which returns a recordset. Once i get the recordset, i am applying Filter on the recordset, in the ASP page. Basically it's a LIKE condition. It works fine for all the parameters like(a*, *a*,a%,%a). The only one where it crashes is *a condition, i.e. if i apply a filter on the query like 'Surname LIKE *a', the ASP page throws up an error.

I fail to understand why?? Any ideas??

 

[PHV]

If with ADO I suggest:
[tt]"Surname Like '%a'"[/tt]

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[kav123]

I tried that, but throws up the same error. The error says something like wrong type of arguments...

 

[kav123]

Hi guys, i think i have sorted this one, found out that Access does not support that, when "*a" is called from ASP etc. Thanks for your contributions anyways