Database Results Query

[Austin]

Greetings,
afetr a week of effort I finally got the Database
Interface Pages on a web and something from the Database
Results Wizard.
The Database Results page has 4 query boxes
(Last_Name,First_Name, Loc1_State, Loc1_Country). I don't
know why but it also displays 4 records from the database
of 114 records and 110 fields. Am I wrong in in thinking
that entering a name in the query box should return the
entire record that contains the query information?
When I enter a name in the query box and submit it I get
sent to:
"The Page Cannot Be Displayed. The page you are looking
for cannot be displayed because the page address is
incorrect."
The Database Interface pages work and the Data Results
page is using, or should be using, the same database.
Thanks for any help anyone can provide.
Austin

 

[jycc]

-----Original Message-----
Greetings,
afetr a week of effort I finally got the Database
Interface Pages on a web and something from the Database
Results Wizard.
The Database Results page has 4 query boxes
(Last_Name,First_Name, Loc1_State, Loc1_Country). I don't
know why but it also displays 4 records from the database
of 114 records and 110 fields. Am I wrong in in thinking
that entering a name in the query box should return the
entire record that contains the query information?
When I enter a name in the query box and submit it I get
sent to:
"The Page Cannot Be Displayed. The page you are looking
for cannot be displayed because the page address is
incorrect."
The Database Interface pages work and the Data Results
page is using, or should be using, the same database.
Thanks for any help anyone can provide.
Austin



.

Austin,
Did you set up a query inside your database? Are you
referring to the query for your asp page information? I
do this all the time but I set up a query for the
information to pull from. Do you want the user to pull
from each of the fields you named or either?

 

[Austin]

-----Original Message-----

Austin,
Did you set up a query inside your database? Are you
referring to the query for your asp page information? I
do this all the time but I set up a query for the
information to pull from. Do you want the user to pull
from each of the fields you named or either?
.

jycc,
Thanks for your reply.
I don't have a query set up in the database. I am
referring to the query set up in step 3 of the DRW.
After "more options', "criteria", I added the 4
identifiers that I want. I would like to enter any one of
the identifiers and have the complete record returned.
That is, enter a last_name or first_name, etc. and get all
the contact information back on all matches.
This seems like it should be easy to set up but I know I'm
missing something, at least one thing maybe more.
Should I be setting up the query in the access database
first?
I'm new to FP and Access and also a slow learner, so I
really appreciate your help.
Austin.

 

[jycc]

-----Original Message-----

jycc,
Thanks for your reply.
I don't have a query set up in the database. I am
referring to the query set up in step 3 of the DRW.
After "more options', "criteria", I added the 4
identifiers that I want. I would like to enter any one of
the identifiers and have the complete record returned.
That is, enter a last_name or first_name, etc. and get all
the contact information back on all matches.
This seems like it should be easy to set up but I know I'm
missing something, at least one thing maybe more.
Should I be setting up the query in the access database
first?
I'm new to FP and Access and also a slow learner, so I
really appreciate your help.
Austin.
.

Austin, I've found the best way to do asp pages with a
database is to write a query in Access first that returns
all information you want. I just finished a project for
a client and they wanted to be able to have one search
box for multiple search items such as last name, first
name, etc. If you entered anything in those items, it
would return information for you. The way I did this was
through a query with a field called search that combined
all of the other fields like this: Search: [firstname]
& " " & [lastname] & " " & [street], etc.

I then based my results on the query, not the table. In
the criteria, I added the Search field contains Search.

This works great and my client is very happy to have only
1 search box to return multiple items.

Hope this helps.

 

[Austin]

jycc,

Thanks for the help. I won't get to try it until next week
but it sounds good.

Austin

-----Original Message-----

-----Original Message-----

jycc,
Thanks for your reply.
I don't have a query set up in the database. I am
referring to the query set up in step 3 of the DRW.
After "more options', "criteria", I added the 4
identifiers that I want. I would like to enter any one of
the identifiers and have the complete record returned.
That is, enter a last_name or first_name, etc. and get all
the contact information back on all matches.
This seems like it should be easy to set up but I know I'm
missing something, at least one thing maybe more.
Should I be setting up the query in the access database
first?
I'm new to FP and Access and also a slow learner, so I
really appreciate your help.
Austin.
.

Austin, I've found the best way to do asp pages with a
database is to write a query in Access first that returns
all information you want. I just finished a project for
a client and they wanted to be able to have one search
box for multiple search items such as last name, first
name, etc. If you entered anything in those items, it
would return information for you. The way I did this was
through a query with a field called search that combined
all of the other fields like this: Search: [firstname]
& " " & [lastname] & " " & [street], etc.

I then based my results on the query, not the table. In
the criteria, I added the Search field contains Search.

This works great and my client is very happy to have only
1 search box to return multiple items.

Hope this helps.
.