473,772 Members | 3,786 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

How do you generate Query by implementimng keyword search!

Dear all,

I have a database with all the research capabilities of professors of a
university. I need to implement a "keyword search" feature in my
welcome page which will actually work like a query generator and search
my entire database for the keyword entered by the user and show up
table/form that has the keyword searched for.

Please let me know as soon as possible.

Thanks ,
geetha

Nov 3 '06 #1
4 1579
sorry I forgot to mention its a Microsoft Access database!

Thx,
Geetha

geetha wrote:
Dear all,

I have a database with all the research capabilities of professors of a
university. I need to implement a "keyword search" feature in my
welcome page which will actually work like a query generator and search
my entire database for the keyword entered by the user and show up
table/form that has the keyword searched for.

Please let me know as soon as possible.

Thanks ,
geetha
Nov 3 '06 #2

"geetha" <ge************ @gmail.comschre ef in bericht news:11******** **************@ f16g2000cwb.goo glegroups.com.. .
Dear all,

I have a database with all the research capabilities of professors of a
university. I need to implement a "keyword search" feature in my
welcome page which will actually work like a query generator and search
my entire database for the keyword entered by the user and show up
table/form that has the keyword searched for.

Please let me know as soon as possible.

Thanks ,
geetha
If we have a solution for you in, let's say about 2 weeks, will that be OK ??

Maybe in the meantime one of the professors can help you out??
Or in the meantime you could Google for 'keyword search' in this group ??

Arno R
Nov 3 '06 #3
Thanks so much Arno,
Yeah It would be fine if I get the solution is about 2 weeks.
Meanwhile, I will keep my eyes open for help on Google and professors
too!
Please let me know if you need any other information to help you
understand the problem and I'll give it to you immediately.

Thanks again!
geetha

Arno R wrote:
"geetha" <ge************ @gmail.comschre ef in bericht news:11******** **************@ f16g2000cwb.goo glegroups.com.. .
Dear all,

I have a database with all the research capabilities of professors of a
university. I need to implement a "keyword search" feature in my
welcome page which will actually work like a query generator and search
my entire database for the keyword entered by the user and show up
table/form that has the keyword searched for.

Please let me know as soon as possible.

Thanks ,
geetha

If we have a solution for you in, let's say about 2 weeks, will that be OK ??

Maybe in the meantime one of the professors can help you out??
Or in the meantime you could Google for 'keyword search' in this group ??

Arno R
Nov 3 '06 #4
If you have to search the entire database for a keyword, then your
design is awful. What does your table structure look like?

Nov 4 '06 #5

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

Similar topics

6
1613
by: Ondernemer | last post by:
I am building a website which stores the headers of newsgroup articles in a database so people can search through the headers using keywords. My queries use WHERE LIKE statements. CREATE TABLE `headers` ( `header_id` int(11) NOT NULL auto_increment, `header_num` int(11) NOT NULL default '0', `message_id` varchar(150) NOT NULL default '', `subject` varchar(200) NOT NULL default '',
1
1325
by: Jim Dandy | last post by:
I have a table with 3M rows that contains a varchar(2000) field with various keywords. Here is the table structure: PKColumn ImageID FullTextColumn There is an association table: ImageID ContractID
3
266
by: Aaron | last post by:
I'm writing a program that has an auto spelling correction feature. it is kind of like google and ebay's spelling suggestion features (did you mean?: correctly spelled word) I need to write a sql query that does partial match, which is the exact opposite as how you would do a wild card search. Wildcard search example ---
3
3192
by: Roland Burr | last post by:
I have a database where each row has a set of keywords separated by commas eg . ROW 1 ID,<other columns>,"green,hat,man,boat" ROW 2 ID,<other columns>,"green,boat,seaside" ROW 3 ID,<other columns>,"red,hat" I want users to be able to find similar records to the one they are looking it (this is art BTW). ie if they are looking at row 1 and click "Find Similar Works of Art" I want to do a query where I find
2
1554
by: Adnan Al-Ghourabi | last post by:
Hi, We have a need to create pages on the fly for ASP.NET applications based on some string that the Url ends with. For example: http://www.domain.com/SomePath/aabbccdd. "aabbccdd" does not exist physically on the file system, but we'd like that to be handled somehow as an ID, make a call to some other system to retrieve data (Web Service, database etc.), and then generate a response page.
23
2790
by: Bosnoval | last post by:
Access 2003 Databse ASP.NET 2 Win 2003 Server Currently I have a search page that only allows a single keyword (person) to be searched at a time. I thought upgrading that option via a multiple selection listbox would be better so that you can search for a pair or more of people at a time but the query that makes this happen is giving me a run for my money. I’m unsure as how to proceed and so I’m hoping someone can help me out. My...
1
1157
by: altesse33 | last post by:
Hi, I have put together a reference library of journal articles and other citations. There are various queries that prompt the user to enter a search term (such as a keyword) and return all article citations that contain the keyword that the user entered. We want to add a feature where the user could click on any part of the citation info returned from the query, and be taken to that same citation's record in the main form (frmCite). ...
2
2155
by: willyc | last post by:
Hello all, hopefully you will kind enough to offer some assistance.... I want to make what i believe could be quite a complex query, something beyond the 'basic' access queries. I'm not afraid of VB coding (or programming in general), alas my knowledge of VB syntax is poor so this job is a little beyond my skills at present. But I want to learn..... Anyway, the exact problem. For each record in a table (called Maindata) I want to...
12
2347
by: iahamed | last post by:
Hi Everyone, I got two parts of my advance search to work, I am running out of Logic to connect the third. My mind is in swing! Pleaseeeeeeeee Help me. I have 3 Fiels to search, the First two works, thats: 1. Category to search from the (Drop down name: ASPDBCatSearch) is working with the Input Text Box Field (name: keyword), based on Whatever selection on the Drop down value selection:
0
9620
marktang
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...
0
9454
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
10261
Oralloy
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...
0
10104
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
1
7460
isladogs
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...
0
6715
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();...
0
5354
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...
0
5482
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
3
2850
bsmnconsultancy
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...

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.