General discussion

Locked

Searching a database in SQL

By bfeltus ·
I created a simple solutions table in sql. I would like my end users to do word searches to find solutions to their problem. What's the code for this or is their a commercial search engine I can use.

This conversation is currently closed to new comments.

6 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

by D-CEd In reply to Searching a database in S ...

To correctly answer this question, we need to know:
- what database engine
- what platform
- what operating system

But as a basic idea, you would need to run a query like:
SELECT <insert fields here>
FROM <insert table name here>
WHERE <field_to_search> LIKE '%<search parameter>%';

If that doesn't answer your question, I will try and supply more details once you answer the questions above.

Collapse -

by bfeltus In reply to

Poster rated this answer.

Collapse -

by bfeltus In reply to Searching a database in S ...

Sorry about that.
Workstations: windows 2000, windows 98.
Novell Shop, windows 2000 server (member server)
Microsoft SQL 7
Wide Area Network

Collapse -

by basithq In reply to Searching a database in S ...

The above answer is generally applicable. Along with this if your also developing a user interface using the Visual Basic. If you are using Visual Basic with Microsoft Access XP or any other database then it will be difficult to use the DSN For this you'll have to use a UDL(Universal Data Link). You can get it using a simple wizard.
1. open the notepad and save the empty file with the extension .udl.
2. then Right click on the file and and select open you'll see a wizard.
3. Select a Provider from provider tab.
4. then give path of the database file in the connection tab, and then test the connection, and press of.
5. open the file in notepad copy the string starting from the word "provider" till the end of the line, and use it as the connection string.


Please note that this solution is for the windows platform.

Collapse -

by bfeltus In reply to

Poster rated this answer.

Collapse -

by bfeltus In reply to Searching a database in S ...

This question was closed by the author

Back to Web Development Forum
6 total posts (Page 1 of 1)  

Related Discussions

Related Forums