Error in HOW TO: query

[Stephen Green]

I created a FrontPage Database Results Page following the instructions at
http://support.microsoft.com/default.aspx?scid=kb;EN-US;310509 - HOW TO:
Query Two Tables in the Same Database in FrontPage 2000. I'm using FP 2002.

When I actually run the query, typing 3 in the search box (on search.asp)
and hitting Submit, I get the table (on results.asp) with an error in the
CategoryID field:

ADODB.Recordset error '800a0cc1'
Item cannot be found in the collection corresponding to the requested name
or ordinal.

/anmt/_fpclass/fpdblib.inc, line 48

anmt is the name of my web site...

I checked my actions several times. I can't find any error on my part (that
doesn't mean there isn't one). Any idea what's wrong? Is there an error in
the instructions? Can I not do the same query with FP 2002?

Can someone try it and see if it works?

Thanks.

Stephen

 

[Jim Buyens]

One of the field names in your query is probably
misspelled -- that is, the field name you specified isn't
a file name in the database.

This can also happen if one of the field names is a
reserved word, such as date or timestamp. In that case,
you need to surround the field name with square brackets,
as in [date].

Jim Buyens
Microsoft FrontPage MVP
http://www.interlacken.com
Author of:
*----------------------------------------------------
|\---------------------------------------------------
|| Microsoft Office FrontPage 2003 Inside Out
||---------------------------------------------------
|| Web Database Development Step by Step .NET Edition
|| Microsoft FrontPage Version 2002 Inside Out
|| Faster Smarter Beginning Programming
|| (All from Microsoft Press)
|/---------------------------------------------------
*----------------------------------------------------