I am creating an Advanced Search form. The user can select whether their
phrase will search the "Title", "Descriptio n" or "All" fields.
Obviously the WHERE clause will change, depending on the options they
select.
Any suggestions on how to implement this? Is the FilterExpressio n on the
DataSource powerful enough to do this? How have you done similar things?
I am using a 3 tiered architecture.
Thanks! 2 2339
First of all, are you using stored procedures or not? One good way to do
this is to use the SQL keyword LIKE. If you do not want to search the field,
use the value '%' as in the following:
WHERE Title LIKE '%' AND Description LIKE '%' AND All LIKE 'my search
phrase'
If you are using stored procedures, you can use the SQL IF. We may be able
to help you better if we could see your code, including the *.aspx file so
we know how the user will be searching. Good Luck!
--
Nathan Sokalski nj********@hotm ail.com http://www.nathansokalski.com/
"Bobby Edward" <bo***@nobody.c omwrote in message
news:uu******** ******@TK2MSFTN GP06.phx.gbl...
>I am creating an Advanced Search form. The user can select whether their phrase will search the "Title", "Descriptio n" or "All" fields.
Obviously the WHERE clause will change, depending on the options they
select.
Any suggestions on how to implement this? Is the FilterExpressio n on the
DataSource powerful enough to do this? How have you done similar things?
I am using a 3 tiered architecture.
Thanks!
"Nathan Sokalski" <nj********@hot mail.comwrote in message
news:%2******** *******@TK2MSFT NGP03.phx.gbl.. .
First of all, are you using stored procedures or not? One good way to do
this is to use the SQL keyword LIKE. If you do not want to search the
field, use the value '%' as in the following:
No. I'm using a BLL class which calls methods in the XSD dataset.
>
WHERE Title LIKE '%' AND Description LIKE '%' AND All LIKE 'my search
phrase'
Would you use the FilterExpressio n for this?
Thanks! This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: nortelsale |
last post by:
I know nothing about programming but I am building a website (written
with php) that allow people post some info.
Is there a site I can get some templates or php scripts for an advanced
search function?
The Advanced Search function shall able to search any posted info by a
postal code/zip code within certain kms and be able to search by map by
clicking to US/Canada map to get to state, then to cities than to
towns....
|
by: Jack |
last post by:
Hello,
I am looking for some canned scripts to implement an advanced search feature
on a product catalog. Here are the details :
1. product has attributes. Depending on the product family, a product may
have different attributes.
2. would like to dynamically build the advanced search page only showing the
valid product attributes.
3. once i know the attributes, I would fill in a dropdown list box with
those attributes.
|
by: kj |
last post by:
Is it possible to create a form on the fly, by creating the form
and its elements, and adding them to the document somehow?
Thanks!
kj
--
NOTE: In my address everything before the first period is backwards;
and the last period, and everything after it, should be discarded.
|
by: Ross Hamilton |
last post by:
I have a Report that creates a Catalogue of Products we sell under various
Headings eg:
Books, Recordings, Health Food, Diet Foods, etc
There are 82 Headings and a total of 6000+ products which makes a big
Catalogue.
A Printed version of the Catalogue is done every 2 Months and we manually
create an Index which takes HOURS, the problem is the Catalogue page numbers
change depending on New or Deleted product ranges.
|
by: javawzl |
last post by:
I am looking for a 3rd party advanced (SQL) search control that I can
basically plug and play into my ASP.Net and supplement with additional fields
(like a country drop down). That is, I don't want to deal with all the phrase
searching, boolean, all words, some words, not with words, etc.. Ideally the
search will work off a SQL Index and handle all noise words.
www.BeanSoftware.com comes closest - but its not quite robust enough yet for...
| |
by: gderosa |
last post by:
I have searched for hours regarding this but I am trying to make an advanced search page for my application that has drop downs for 'Greater Than', 'Equals', 'Less Than'. For example the search page needs to be like this:
ENDDATE:
How can I manipulate the SQL search string to change the value when the user selects a search criteria in the dropdown?
At the moment it is SELECT * FROM Table WHERE EndDate LIKE TextBox1%
I would like...
|
by: dlesandrini |
last post by:
Has anyone noticed that the Google Groups Advanced Search no longer
works correctly? Is it something I'm doing or have others noticed the
change?
Used to be, if I put *access* in the Groups filter, I got groups with the
word
"access" in the name. No longer. Used to be, if I selected "English" as
the
language, I didn't get non-english posts. No longer. What's up with that?
Anyone else notice this?
|
by: BobLewiston |
last post by:
I installed SQL Server 2008 Express, basic edition (SQLEXPR32_x86_ENU_Bootstrapper.exe, version 9.0.30729.1) without any problem.
Then I attempted to install AdventureWorks Sample Databases for SQL Server 2008 (SQL2008.AdventureWorks_All_Databases.x86.msi). This attempt failed because SQL Server 2008 Express, basic edition doesn’t support Full-text Search, which AdventureWorks requires.
So I uninstalled SQL Server 2008 Express, basic...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
| |
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 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 a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |