Solved

WildCard question on ASP and access

Posted on 1998-12-18
1
146 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
Comment Utility
replace the wildcard with %

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

* only works from within Access.
0

Featured Post

Top 6 Sources for Identifying Threat Actor TTPs

Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

Join & Write a Comment

Deprecated and Headed for the Dustbin By now, you have probably heard that some PHP features, while convenient, can also cause PHP security problems.  This article discusses one of those, called register_globals.  It is a thing you do not want.  …
Envision that you are chipping away at another e-business site with a team of pundit developers and designers. Everything seems, by all accounts, to be going easily.
Explain concepts important to validation of email addresses with regular expressions. Applies to most languages/tools that uses regular expressions. Consider email address RFCs: Look at HTML5 form input element (with type=email) regex pattern: T…
This tutorial demonstrates how to identify and create boundary or building outlines in Google Maps. In this example, I outline the boundaries of an enclosed skatepark within a community park.  Login to your Google Account, then  Google for "Google M…

772 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

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now