S
Shawn Stapleton
Hello and thanks for the anticipated help,
I'm trying to make a table with sortable columns. I have been using the
following
tutorial, however
when I test this table on the internet it keeps coming back with,
"Database Results Error
The operation failed. If this continues, please contact your server
administrator."
This tutorial uses Frontpage's Database Results Wizard. I have no problem
using this wizard otherwise, except when I try making the sortable columns.
Im using Frontpage 2002, and my site is hosted on IIS on a computer running
windows xp pro.
Any help would be greatly appreciated,
Thanks,
Shawn Stapleton
Here is the tutorial:
..To create a sort-by-column query
1.. Create a new page, and then save it as Sort.asp.
The page is saved as an Active Server Page (ASP) because FrontPage
generates ASP script that needs to reside in an ASP document.
2.. On the Insert menu in Page view, click Database, and then point to
Results to insert a database results region.
This opens the Database Results Wizard, which is one of the database
interfaces in FrontPage.
3.. In Step 1 of the wizard, click Use a sample database connection or Use
an existing database connection, and then click Next.
4.. In Step 2 of the wizard, in the Record source list, choose a source,
and then click Next.
5.. In Step 3 of the wizard, click More Options, and then click Ordering.
6.. Select a field in the Available fields list, click Add to add it to
the Sort Order list, and then click OK.
The results of the query will be sorted according to the values in this
column.
7.. Click OK to exit the More Options dialog box, and then click Back to
return to Step 2 of the wizard.
You may be wondering why you've gone back to Step 2 of the wizard after
specifying some options. When you specify options, FrontPage writes the SQL
that the database uses to retrieve results. For example, in step 6 of the
procedure you specified a sort order. FrontPage created a SQL query that
tells the database how to sort the results. Going back to Step 2 of the
wizard allows you to use the SQL FrontPage creates instead of having to
write it yourself.
The rest of the steps in the procedure show you how to make minor changes
to the SQL so that a site visitor can easily sort the results by clicking a
column heading.
8.. Click Custom Query, and then click Edit.
The SQL required to implement your query is in the SQL field.
9.. Select the name of the field you chose (the name follows the words
ORDER BY), and then click Insert Parameter.
10.. In Form field name, enter SortColumn, and then click OK.
You don't have to use the name SortColumn; however, it is a good
description of the action that will occur. The name that is used in this
field will be used when creating the hyperlinks for each column name.
11.. Click OK to return to Step 2 of the wizard, and then click Next.
12.. In Step 3 of the wizard, click More Options, and then click Defaults.
13.. Click Edit, add the name of the first column in your table, and then
click OK until you close all dialog boxes.
14.. In Step 4 of the wizard, select Table-one record per row, and then
click Next.
15.. In Step 5 of the wizard, click Display all Records Together, and
clear the Add search form check box.
16.. Click Finish.
After the database region has been generated and displayed on the page, you
need to create hyperlinks for all the column headings. Follow the procedure
below for each column heading.
Create hyperlinks for column headings
1.. Select the column heading, and then click Hyperlink.
2.. Select sort.asp from the Name field. Sort.asp is added to the URL
field.
3.. Click Parameters.
4.. Click Add.
5.. In Name, enter the form field name you chose.
"SortColumn" was the suggested name in the procedure above.
6.. In Value, enter the name of the column for which you want the
hyperlink, and then click OK.
7.. Click OK until you close all dialog boxes.
8.. Repeat steps 1 through 6 for all column names.
I'm trying to make a table with sortable columns. I have been using the
following
tutorial, however
when I test this table on the internet it keeps coming back with,
"Database Results Error
The operation failed. If this continues, please contact your server
administrator."
This tutorial uses Frontpage's Database Results Wizard. I have no problem
using this wizard otherwise, except when I try making the sortable columns.
Im using Frontpage 2002, and my site is hosted on IIS on a computer running
windows xp pro.
Any help would be greatly appreciated,
Thanks,
Shawn Stapleton
Here is the tutorial:
..To create a sort-by-column query
1.. Create a new page, and then save it as Sort.asp.
The page is saved as an Active Server Page (ASP) because FrontPage
generates ASP script that needs to reside in an ASP document.
2.. On the Insert menu in Page view, click Database, and then point to
Results to insert a database results region.
This opens the Database Results Wizard, which is one of the database
interfaces in FrontPage.
3.. In Step 1 of the wizard, click Use a sample database connection or Use
an existing database connection, and then click Next.
4.. In Step 2 of the wizard, in the Record source list, choose a source,
and then click Next.
5.. In Step 3 of the wizard, click More Options, and then click Ordering.
6.. Select a field in the Available fields list, click Add to add it to
the Sort Order list, and then click OK.
The results of the query will be sorted according to the values in this
column.
7.. Click OK to exit the More Options dialog box, and then click Back to
return to Step 2 of the wizard.
You may be wondering why you've gone back to Step 2 of the wizard after
specifying some options. When you specify options, FrontPage writes the SQL
that the database uses to retrieve results. For example, in step 6 of the
procedure you specified a sort order. FrontPage created a SQL query that
tells the database how to sort the results. Going back to Step 2 of the
wizard allows you to use the SQL FrontPage creates instead of having to
write it yourself.
The rest of the steps in the procedure show you how to make minor changes
to the SQL so that a site visitor can easily sort the results by clicking a
column heading.
8.. Click Custom Query, and then click Edit.
The SQL required to implement your query is in the SQL field.
9.. Select the name of the field you chose (the name follows the words
ORDER BY), and then click Insert Parameter.
10.. In Form field name, enter SortColumn, and then click OK.
You don't have to use the name SortColumn; however, it is a good
description of the action that will occur. The name that is used in this
field will be used when creating the hyperlinks for each column name.
11.. Click OK to return to Step 2 of the wizard, and then click Next.
12.. In Step 3 of the wizard, click More Options, and then click Defaults.
13.. Click Edit, add the name of the first column in your table, and then
click OK until you close all dialog boxes.
14.. In Step 4 of the wizard, select Table-one record per row, and then
click Next.
15.. In Step 5 of the wizard, click Display all Records Together, and
clear the Add search form check box.
16.. Click Finish.
After the database region has been generated and displayed on the page, you
need to create hyperlinks for all the column headings. Follow the procedure
below for each column heading.
Create hyperlinks for column headings
1.. Select the column heading, and then click Hyperlink.
2.. Select sort.asp from the Name field. Sort.asp is added to the URL
field.
3.. Click Parameters.
4.. Click Add.
5.. In Name, enter the form field name you chose.
"SortColumn" was the suggested name in the procedure above.
6.. In Value, enter the name of the column for which you want the
hyperlink, and then click OK.
7.. Click OK until you close all dialog boxes.
8.. Repeat steps 1 through 6 for all column names.