query in Access with a where block of: Model Like "*470*"

[classic.certs]

I set up a query in Access with a where block of: Model Like "*470*". It runs successfully. I embedded the same code in a web page and it does not pull any data. It works if the asterisks are removed and the full model number is typed. Does anyone know of any quirks using the asterisk with Access when embedding it on a web page?

[kgun]

1. Import the table to MySQL.
2. Using embedded SQL in Visual Basic for Applications (VBA). If you can not do it in SQL, you should be able to program it in VBA?
3. Have you looked at your SQL code? Diificult to give an answer without seeing that code.

[Dubbya]

The Asterisk is also used to signify multiplication, so that could be a likely explanation for the trouble you're having.

Without the asterisks it should work.

If the string you're looking for actually contains the asterisk, you can try to convert the characters in the string and search that way.

1) Model LIKE "470" (without asterisks)
2) Model LIKE " & cStr("*470*") & " (whatever the rest of your search string consists of)

[John Redfield]

Are you passing the query using ASP?

If so the wild card is %

Can you share your code?

John

[MursPlace]

Originally Posted by John Redfield

Are you passing the query using ASP?

If so the wild card is %

Can you share your code?

John

Like John Said the wild card symbol is the percent % sign.

We have to guess you are using an IIS server with your access db.

3 basic search setup lines using LIKE statements.

1. Searching for a part number knowing first few characters.
" WHERE [table.name] LIKE '"& KeyWord &"%' "
The above says to check the letters entered and anything else that might be missing. Part Number 92 will return all parts starting with 92.

2. Searching for a part number knowing ending number or characters.
" WHERE Table.PartNumber LIKE '%"& PartNumber &"' "

3. Searching for word or words within text or numbers within text.
" WHERE [table.name] LIKE '%"& KeyWord &"%' "

That should do it for your LIKE search setup.

BUT:

does not pull any data

You need to post your connection string as well (no username or passwords please)
Because from what you wrote your page might not even know it has data to work with!

It's always best to post what you coded so we can quickly fix it for you. Just change table names because you don't want to share your table structure with the world.
Good Luck