Summer Fun Huge offer ~------support the logical search/Word search/Phrase search + support Or/and keywords! (1)

Source: Internet
Author: User
Tags copy ming
Key word//ROOT1. Hey!!! //

Objective:
For example, you are writing a search interface, so that users can have more search options.
The code is directly on my homepage copy down. And the page is combined so
More ugly understand. Hehe:
Here I use Access.


Mine is like this, I have more than 10 tables, are stored in various classes of students published
Article. So I set up a federated query in Access. The query article is just in the Union
Query for the title and content, or by the author query//I do not know how to say ...


Processing the query ASP file is too lazy to write out, wait a little later on copy come up:

First of all talk about function:

Word search [For example: Xiaoming]

Phrase Search
Every word in a phrase will be retrieved
For example: Xiao Qiang 1 nickname 1 small powerful small cockroach

Logical Search
Supports the and and OR operators.
For example: Xiaoming and Xiao Qiang

Compound Condition:
For example: (Small Ming or Xiao Ming) and (Xiao Qiang or Xiao Qiang)
For example: (Small Ming Or nickname) and Xiao Qiang
For example: ROOT1 and (Cantonese Or Peking people)

The next part puts a VBS file that dynamically generates SQL statements based on the user's search criteria.



Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.