Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

like query

Status
Not open for further replies.
byRamiX

byRamiX

Programmer
Nov 28, 2006
13
IL
i'm trying to execute a like query in asp script, but i get an error.
the error is
Item cannot be found in the collection corresponding to the requested name or ordinal
the fields names are right, becase i run the same query with another conditions,
i want to get the records that has the char 3. i do like '%3%' and it gives the error, if i do like '3' it's ok, but it's not what i want.
what is the exact syntax for that?

- sportcars
- Free Banners System
- Programmig issues
- free web directory
 
Sort by date Sort by votes
What's the exact SQL statement being issued and where does the error actually occur?
As far as the LIKE statement, the "%" is the wildcard character. I would suggest running the query in the Pervasive Control Center to make sure that the syntax is working correctly then make sure the error isn't in the ASP portion.

Mirtheil
Certified Pervasive Developer
Certified Pervasive Technician
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

EasyBoy2
  • Locked
  • Question
Slow pervasive query
Replies
0
Views
168
EasyBoy2
EasyBoy2
ShockValue
  • Locked
  • Question
subquery in a query using a case
Replies
2
Views
271
ShockValue
ShockValue
MzKitty
  • Locked
  • Question
Problems with a "Delete From" query.
Replies
1
Views
219
TNGPicard
TNGPicard
eldnahmurof
  • Locked
  • Question
Run PSQL query from command line or script 1
Replies
2
Views
316
eldnahmurof
eldnahmurof
johnny45
  • Locked
  • Question
SLOW QUERY 1
Replies
3
Views
155
mirtheil
mirtheil

Part and Inventory Search

Sponsor

Back
Top