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.