Solved

WildCard question on ASP and access

Posted on 1998-12-18
1
149 Views
Last Modified: 2013-12-25
hi,
I stuck in the problem of using wildcard with ASP and Access.
I used the statment in ASP page. It doesn't return any record for me. I printed out the same statement and pasted in Access. It returns me the right recordset.

In the statement, I used "select * from table1 where table1.field1 like '*" & Request("whatever") & "*'"


Could anyone know why?

I appreciate you answer.

mklee
0
Comment
Question by:mklee
1 Comment
 
LVL 6

Accepted Solution

by:
PBall earned 50 total points
ID: 1857406
replace the wildcard with %

"SELECT * FROM Table1 WHERE Table1.Field1 LIKE '%" & .... & "%"

* only works from within Access.
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Does your audience prefer people in photos or no people? How can you best highlight what you’re selling? What are your competitors doing, and what can you do that is different and unique from them?  Continue reading to learn how to make your images …
When crafting your “Why Us” page, there are a plethora of pitfalls to avoid. Follow these five tips, and you’ll be well on your way to creating an effective page.
Viewers will get an overview of the benefits and risks of using Bitcoin to accept payments. What Bitcoin is: Legality: Risks: Benefits: Which businesses are best suited?: Other things you should know: How to get started:
The viewer will learn how to create and use a small PHP class to apply a watermark to an image. This video shows the viewer the setup for the PHP watermark as well as important coding language. Continue to Part 2 to learn the core code used in creat…

820 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question