Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

WildCard question on ASP and access

Posted on 1998-12-18
1
Medium Priority
?
160 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 200 total points
ID: 1857406
replace the wildcard with %

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

* only works from within Access.
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

When the s#!t hits the fan, you don’t have time to look up who’s on call, draft emails, call collaborators, or send text messages. An instant chat window is definitely the way to go, especially one like HipChat. HipChat is a true business app. An…
Without even knowing it, most of us are using web applications on a daily basis.  In fact, Gmail and Yahoo email, Twitter, Facebook, and eBay are used by most of us daily—and they are web applications. We generally confuse these web applications to…
The viewer will learn how to count occurrences of each item in an array.
The is a quite short video tutorial. In this video, I'm going to show you how to create self-host WordPress blog with free hosting service.
Suggested Courses
Course of the Month14 days, 5 hours left to enroll

581 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