database search form - NO RESULTS

[montiy]

I am trying to add a databse search form to my web site. I've got it hooked
up to the database, and have followed the step-by-step instructions in the
Database Results Wizard process.

HOWEVER...whenever I upload and attempt to use the results wizard (using a
search form), I always get the reply "No Results Found". I can't get the
search form to actually FIND any of my results in my database. What could be
the problem? Please help!

 

[Kathleen Anderson [MVP - FrontPage]]

Can you post your SQL statement?

--

~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
web: http://www.spiderwebwoman.com/resources/

 

[montiy]

SELECT * FROM Results WHERE (State LIKE '%::State::%' AND City LIKE
'%::City::%' AND Last_Name LIKE '%::Last_Name::%' AND First_Name LIKE
'%::First_Name::%' AND Possible_Speaking_Topics LIKE
'%:ossible_Speaking_Topics::%')

Actually...I've worked for a while, and THIS is now working.

However, I have another question that you might be able to answer. I would
like to be able to have the user perform this search...and THEN have them be
able to click on the column headings of the returned table, in order to sort
the table by that column. I read a previous post where you gave some insight
on this, but I haven't been able to make that work. For some reason, when I
use the "SortColumn" string, that throws everything off -- and I get an error
message, something about database connectivity. Can you give me some insight
on how to do this?

Also...I'm wondering if I'm even going to be ABLE to accomplish this with
the table showing the results of the search...or if I'd only be able to sort
the ENTIRE table with all records from the database? Your thoughts?

-- Nate

 

[David Berry]

See if this article helps
http://www.spiderwebwoman.com/thingumajig/drwsort.htm

There are other tips at
http://www.spiderwebwoman.com/resources/dbrwtipsandtricks.asp

 

[montiy]

I'm not very proficient in HTML or programming, so I was hoping there was a
way to accomplish this by using the FrontPage database results wizard (DRW).
I'm trying to do the following:

1) Return results from a database query (already working)

2) Then...be able to SORT the results of that query by clicking on a column
heading in that table.

Can anyone help? Thanks!


-- Nate

 

[David Berry]

The site I mentioned http://www.spiderwebwoman.com/thingumajig/drwsort.htm
gives you the step by step (with cut and paste code) on how to do sorting
with the DRW. This is what you'll need to do to make it work. Just switch
to Code View and follow the instructions on that site.

 

[Andrew Murray]

In the DB results wizard screens, there is the option to sort
ascending/descending. In the "Criteria" screen or similar.

 

[Kathleen Anderson [MVP - FrontPage]]

Hi Andrew:
He wants the user to be able to sort the query results;
http://www.spiderwebwoman.com/thingumajig/drwsort.htm will let them do that.

--

~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
web: http://www.spiderwebwoman.com/resources/