ASP & Access

[Reza]

hi there,

I am pretty new to ASP and I am in the middle of building a sample application
using ASP and Access.

I am using the ADO Connection an RecordSet for my queries.

I have been playing around with various simple queries, but have had problems
retrieving data with the following:

select * from table where table.column like "*such*"...

I have had problems with "like"...if I put an equal sign and the whole word,
the query returns properly.

I realize that I am pretty fresh in this area, but was wondering if there
is anyone who could possibly direct down the right path!

[Mike]

Try using % instead of *. It worked for me when using Oracle. It could be
worth a try.

"Reza" <rkhalili@hotmail.com> wrote:
>
>hi there,
>
>I am pretty new to ASP and I am in the middle of building a sample application
>using ASP and Access.
>
>I am using the ADO Connection an RecordSet for my queries.
>
>I have been playing around with various simple queries, but have had problems
>retrieving data with the following:
>
>select * from table where table.column like "*such*"...
>
>I have had problems with "like"...if I put an equal sign and the whole word,
>the query returns properly.
>
>I realize that I am pretty fresh in this area, but was wondering if there
>is anyone who could possibly direct down the right path!

[Brendan]

For Access you might try

"SELECT * FROM TableName WHERE FieldName = '*SUCH*' "

Single and double quotes are important.

"Mike" <michael.viglianco@bankofamerica.com> wrote:
>
>Try using % instead of *. It worked for me when using Oracle. It could be
>worth a try.
>
>"Reza" <rkhalili@hotmail.com> wrote:
>>
>>hi there,
>>
>>I am pretty new to ASP and I am in the middle of building a sample application
>>using ASP and Access.
>>
>>I am using the ADO Connection an RecordSet for my queries.
>>
>>I have been playing around with various simple queries, but have had problems
>>retrieving data with the following:
>>
>>select * from table where table.column like "*such*"...
>>
>>I have had problems with "like"...if I put an equal sign and the whole
word,
>>the query returns properly.
>>
>>I realize that I am pretty fresh in this area, but was wondering if there
>>is anyone who could possibly direct down the right path!
>