FrontPage 2003 Database Results Query problem

[Jeff McClellan]

I have just upgraded from FP 2002 to FP 2003. Since the upgrade I can't get
the Database results to return any data from a query. I am new at ASP and
database results so I could be over looking something simple.

I created a simple page with only the database results on it. Set up the
connection to the database and a TABLE and it works fine. I rerun the
database results wizard and change it to connect to a QUERY in the same
database connection and I get no results. I had this working a day or two
ago in FP 2002 but can't make it work now in FP 2003.


Error returned when accessing a query:
Database Results Wizard Error
The operation failed. If this continues, please contact your server
administrator.

Database: Access 2002


Any help will be greatly appreciated.

Jeff

 

[Kathleen Anderson [MVP - FP]]

Jeff:
Please try this procedure and let us know if it works - thanks!

To work around this problem, modify the ASP script in the asp page of your
Web site. To do this, follow these steps:
1. Open the asp in FrontPage 2003 and switch to Code View
2. On the "Edit" menu, click "Find".
3. In the "Find what" box, type "fp_sColTypes" (without the quotation
marks), and then click "Find Next".
4. Type a trailing ampersand (&) inside the closing quotation marks. For
example, the fp_sColTypes line should now look exactly like the following
example: <fp_sColTypes="&name=value&name=value&name=value&">
5. On the "File" menu, click "Save"

 

[Jeff McClellan]

Thanks.
I checked and those fields already had the trailing &.
I have stumbled on the answer (or A answer) however. I had spaces in my
query name. Once I renamed my Query to a name without spaces it started
working. Not sure why FP 2002 let this slide and 2003 does not. Anyway
problem solved. Thanks for your reply.

Jeff