dynamically sorted table

SK · May 11, 2004

I followed the links to create a dynamically sorted table:
http://www.frontpages-web-hosting.net/frontpage.Support/frontpage.hta_7.htm
and
http://www.frontpagemagic.com/DRW/Format/DynamicSorting/Index.asp

I followed the directions to the letter and I get the following error:

Unable to find operator in query string. Query string currently is SELECT
CustomerId, CompanyName, ContactName, ContactTitle FROM Customers ORDER BY
::SortColumn:: ASC

even though I am supplying a valid column name. This is probably related to
the mysterious 817029 error that I have requested help with to no avail.

My earlier post on that problem is here:
http://www.google.com/groups?hl=en&...4EctnmIEHA.2688%40tk2msftngp13.phx.gbl&rnum=3

I think there is an installation problem with Frontpage 2003, since these
examples work for some people and not others.

Just needed to vent. I shouldn't bother with the time-saving DRW, but I
just can't believe that the DRW can't be used for these simple pages.

Sue

jonathan · May 11, 2004

I totally agree Sue!!!!!

I have used the DRW to build an asp section to an intranet site as awell as
wanting to update records - and it just f***s everything!

All I get is error after error! FP 2003 needs a re-think Bill! We buy it
and it doesn't work (dreamweaver does!!!!!!!)

Jonathan

Kathleen Anderson [MVP - FP] · May 12, 2004

You may want to read this thread:
http://www.frontpagewebmaster.com/m-175524/tm.htm

Bill Schroyer · May 12, 2004

Hey, don't kick the car if you put water in the gas tank!

I have use this method on many client sites and many
differnt computers...it works, when all else fails try
again or learn ASP...
http://www.w3schools.com/asp/default.asp

Bill Schroyer
(e-mail address removed)
http://www.frontpagewiz.com

SK · May 12, 2004

Thanks to everyone who replied. Unfortunately none of the suggestions
helps.

I thought I would post the code here to see if anyone else can run it. If
they can, it points to a FP 2003 installation issue as I suspect. Either
that or it is because I am using a ODBC System DSN to a SQL 2000 database.
Perhaps because I am using FP 2003 on a Windows 2003 Server?

I know ASP, SQL, I just would rather use the product to do its job. Stuff I
know others have used successfully as the product is intended to be used.

I am posting the code. Will try an reinstall FP 2003 this morning, though I
don't think this will fix it.

Thanks for all the suggestions.

Sue
----------------------------------------------------------------------------
-------------------------------------------
<html>

<head>
<% ' FP_ASP -- ASP Automatically generated by a Frontpage Component. Do not
Edit.
FP_CharSet = "windows-1252"
FP_CodePage = 1252 %>
<meta http-equiv="Content-Type" content="text/html; charset=windows-1252">
<title>New Page 1</title>
<meta name="GENERATOR" content="Microsoft FrontPage 6.0">
<meta name="ProgId" content="FrontPage.Editor.Document">
</head>

<body>

<table width="100%" border="1">
<thead>
<tr>
<th ALIGN="LEFT"><b>CompanyName</b></th>
<th ALIGN="LEFT"><b>ContactName</b></th>
<th ALIGN="LEFT"><b>ContactTitle</b></th>
</tr>
</thead>
<tbody>

<% if 0 then %>
<SCRIPT Language="JavaScript">
document.write("<div style='background: yellow; color: black;'>The Database
Results component on this page is unable to display database content. The
page must have a filename ending in '.asp', and the web must be hosted on a
server that supports Active Server Pages.</div>");
</SCRIPT>
<% end if %>
<%
fp_sQry="SELECT CompanyName, ContactName, ContactTitle FROM Customers ORDER
BY ::SortColumn:: ASC"
fp_sDefault="SortColumn=CompanyName"
fp_sNoRecords="<tr><td colspan=3 align=""LEFT"" width=""100%"">No records
returned.</td></tr>"
fp_sDataConn="Database1"
fp_iMaxRecords=256
fp_iCommandType=1
fp_iPageSize=0
fp_fTableFormat=True
fp_fMenuFormat=False
fp_sMenuChoice=""
fp_sMenuValue=""
fp_sColTypes="&CompanyName=202&ContactName=202&ContactTitle=202&"
fp_iDisplayCols=3
fp_fCustomQuery=True
BOTID=0
fp_iRegion=BOTID
%>

<tr>
<td>
<%=FP_FieldVal(fp_rs,"CompanyName")%></td>
<td>
<%=FP_FieldVal(fp_rs,"ContactName")%></td>
<td>
<%=FP_FieldVal(fp_rs,"ContactTitle")%></td>
</tr>

</tbody>
</table>

</body>

</html>

Outlook Security Settings	0	Apr 23, 2004
Office 2003: The subject is not trusted for the specified action (Richtx32.ocx)	3	Nov 12, 2003
Outlook 2003 - Subject View (a repeated question)	0	Apr 15, 2004
=ROW-1 modified coding in filters not working in Excel 2002.	2	Sep 9, 2004
Can't Connect to FP webs through VPN	1	Jul 30, 2003
Multihomed Server Configuration comes full circle.	0	Jul 1, 2004
excel focus problems with custom RTD server (real time data)	3	Apr 7, 2004
Disabling Ctrl+D When Composing Messages	3	Jun 11, 2004

dynamically sorted table

SK

jonathan

Kathleen Anderson [MVP - FP]

Bill Schroyer

SK

Ask a Question

Similar Threads