473,325 Members | 2,872 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,325 software developers and data experts.

wildcard '%' acting like wildcard '_' in .net aspx page More options

short description:

i've got a .net web site set up using a tableadapter attached to a
sql
server table - returning results only, no update of data. i've got a
query (qry code below) set up to search and return based on
description. i've got a textbox on an aspx page for input of the
search term (@DESC). when i put in T% into the textbox on the aspx
page i get 0 results - if i put in T% for @DESC in the query builder
and preview the info i get 775 results (all items starting with 'T').
here's what i consider to be the REALLY strange part.... if i put T%%
%
in the web page textbox i get 4 results - 3 with descriptions that =
'TOOL' and 1 that has a description = 'TENT'. i get the exact same
results if i put in T___ (T + 3 underscores). if i keep putting on
more %'s, the qry treats them like _'s and i get more and more
results
with each % i put on the query.
unless i'm confused - which i often am - the '_' is a 1 char wildcard
and the '%' is a multiple char wildcard - this is the case in the
query builder's preview but not when the info is passed from the aspx
page.....
in the tableadapter query configuration wizard, i've got the
following
query:
SELECT StoreBranchNo, SKU, Active, CategoryCode,
PublicDescription, Mfg, Model, Type, SerialNo, NewItem, UniqueItem,
Price, SalePrice, Cost, QtyOnHand,
QtyAvailable, QtyOnLayaway, QtyReOrderPoint,
QtySuggestedToOrder, TotQtySold, StatusDate, CreationDate, ItemSize,
Weight, WeightUnits, Color,
Karat, Carat, Finish, Caliber, ItemAction,
BarrelCount, OriginalEmployee, RockBottom, Notes, Picture,
UpdateTimeStamp
FROM tbl_LARS_Inventory
WHERE (PublicDescription LIKE @DESC) OR
(PublicDescription = @DESC)
the 'PublicDescription = @DESC' is in there to include exact matches
also. i've tried this without the '= @DESC' and i get the same
results.
i'm so frustrated by this behavior, i'm really hoping someone can
stroll by this board and say "oh, yea, you idiot, THIS is what is
wrong." and have it be an easy fix. if anyone needs more information
in order to help, please let me know. i didn't want to post too much
info but i'm afraid i'm probably posting too little.
thanks in advance
gordon

Mar 28 '07 #1
0 1499

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

3
by: Adam | last post by:
Its my understanding that in asp.net 2.0 you can write an httpmodule that will acts as a wildcard handler and pass requests on to the proper engine, for instance, asp or perl for example, In the...
2
by: Ken Yee | last post by:
First a little background: I've written an httphandler to handle wildcard extensions (i.e., I want to handle all URLs that come in rather than just URLs w/ a specific file extension so I can give...
7
by: SlimFlem | last post by:
I have searched hard for 2 days on this and keep hitting a wall. I have a custom IHttpHandler setup to do Url mappings to prop up some old Urls for our site. I have also created a wildcard...
8
by: p3t3r | last post by:
I am using .NET2 and have a number of aspx pages. On each page is a LinkButton that performs a server.transfer() to another page. If we use page names A,B,C,D,E as an example. I start on page A...
2
by: Jan Kucera | last post by:
Hi, I have virtual MyFolder/* and MyFolder/MySubFolder/* mapped to an httphandler in the web.config file and all works perfectly on the asp.net development server. However on the IIS6/Win2003 I'm...
2
by: guoqi zheng | last post by:
Dear Sir, I would like all files on my application to pass asp.net, so I added aspnet_isapi.dll to the Wildcard application maps. After that, many things changed. I used to be able to visit my...
0
by: Thomas | last post by:
in .net 1.1 we successfully use a HttpModule to catch 404 / 403.1 html errors. after migrating to .net 2.0, this modules is broken in a very, very strange way. we have defined a wildcard...
6
by: Jan Kucera | last post by:
Hi, does anybody know about wildcard mapping ASP.NET 2 in IIS6? Any tutorial? Thanks, Jan
2
by: Arch Stanton | last post by:
I have an aspx page with a text box. My user enters text to search for and presses a button; the text is passed via a QueryString to another aspx page and used in a SQL search. The wildcard...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.