Customizing search results to match queried fields 
Author Message
 Customizing search results to match queried fields

Hi all,

I am building a database of students of Business Administration that
will be graduating this year. I am using FileMaker Pro 4.
The database has several fields: student name, student number, address,
phone, GPA (Gross Points Average), language knowledge, computer
knowledge, and some more fields.

I used the Web Companion module of FileMaker and then Claris HomePage
3.0 to create the corresponding web pages (default.htm, search.htm,
search_results.htm, search_error.htm, record_detail.htm)

The Search page (search.htm) displays all the fields of the database,
so the user can choose which fields to fill in to do the search.

Now, it is natural that the user (companies that want to employ
students) only fills some fields. For example, maybe the company only
wants to restrict the search for people that speak French, and so, the
only field the user fills in is "Language Knowledge" with the
keyword "French"

And I arrive to my problem:

I want to customize the Search Results page (search_results.htm) in
order that the table of results has the following columns:
1) Student number
2) Student name
3) PLUS *only* the field (or fields) that the user filled in the search
page. In my example, the search_results.htm page should only shows the
columns for student number, student name and the column for language
knowledge.

Was that clear?

Could anyone please help me?

Thanks in advance.

Best wishes,
______________________________________
Ricardo Marques - Texet no IRC (PTNet)
Pgina de ajuda IRC/PTNet
http://www.***.com/

Sent via Deja.com http://www.***.com/
Share what you know. Learn what you don't.



Sun, 24 Feb 2002 03:00:00 GMT
 Customizing search results to match queried fields

Hallo Paul,

First of all, thank you very much for your quick answer. I really appreciate
it.

Quote:

> I do believe I understand what you are trying to do.
> I have done something  similar on one of my web
> "search_results.htm" pages.

Could you please give me the URL for your database so I could take a look
 at it?

Quote:
> All you should have to do in this page is only display the fields that you
> want your users to see after a successful search.

The problem is that: 1) While I want to return student numbers and student
names in every search result table (This is Easy) 2) I *also* want to return
the results for the field or fields that were filled in the search, while
*hiding* the other fields in the search results table. (That is the Hard
part)

Confusing? Let me give you an example:

Company A is looking for people who speak french. So they go to search
page, fill in the "Language Knowledge" field with "French" and press the
Search button.

The search results should look like this:

Student Number   Student Name   Language knowledge
101                      Arthur Boston   English, French, German
113                      Frank Loot       French
146                      John Silver       Italian, French

Company B, on the other hand, doesn't care about language knowledge.
Instead, they are only interested in checking people who have knowledge
 of Java programming language. So they go to the search page and leave
all fields blank, *except* for the Computer Knowledge field which they fill in
with the keyword "Java" and press search.

The search results should look like this:
Student Number   Student Name   Computer Knowledge
104                     John White        Pascal, C++, Java
108                     Anthony Bean    Java
145                     Marc Lander      Word, Java, Excel

See? In the second search, Language Knowledge shouldn't appear (nor
any other field that is in the database like address, mobile phone, e-mail,
previous work experience, etc). The only fields that should appear in the
results table are the fields that were filled in the search.

So, I guess that what I want is some kind of script that checks the fields
that were filled in the search page and only returns those fields in the
search results page (plus student number and student name)

Was that clear now? Can you Paul (or any other kind soul) please give me
some hint on how I could work this out?

Thanks again.

Best wishes
______________________________________
Ricardo Marques - Texet no IRC (PTNet)
Pgina de ajuda IRC/PTNet
http://www.ricmarques.com

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't.



Mon, 25 Feb 2002 03:00:00 GMT
 Customizing search results to match queried fields
Here's a way to do it with a calculated field and a global.

create a global field "gSearchFieldName," set up with a value list of the field
names you want to search.

create a global field, "gSearchForThis"

Create a calc field, "SearchMe"
  case(
SearchFieldName = "Computer Language", ComputerLanguge,
SearchFieldName = "Spoken Language", SpokenLanguge
   )

create a script

enter find mode (no pause, no restore)
set field (SearchMe, gSearchForThis)
perform find (do not restore find)

If you want to do something more complicated, I've created some interesting
universal query builder  which use applescrpt. They will work with ANY open
database, no scripts or special fields in the target DB.

Bruce Robertson



Wed, 27 Feb 2002 03:00:00 GMT
 
 [ 3 post ] 

 Relevant Pages 

1. search results ordered by matches !

2. customize result-tab caption in Query Analyzer?

3. Customizing the window for query results

4. results: Filtering no-match record/field (SELECT-SQL)

5. Search / Match hundreds of boolean fields

6. Matching results from query

7. Best-Match Keyword Search Query

8. Oracle Gateway - result set issues - results not matching data in DB2

9. Search full field in view but return only part of field length in query

10. matching fields tables query ?

11. Oracle query - matching fields

12. Querying for match on date field


 
Powered by phpBB® Forum Software