Frontpage2003 Database results error

[Gandy]

I upgraded to FP 2003 from 2002

I have been able to begin updating my pages with some of 2003 new stuff but a problem has occurred

On all of the .asp pages on which i display database results I get the following error

"Database Results Wizard Erro
The operation failed. If this continues, please contact your server administrator.

This error messages has occurred throughout my site although I have only worked on one or two pages with FP2003

Also, all of my database results pages were working fine yesterday before I started working with FP2003

Can anyone tell me how to get my database results pages to work again

 

[Gandy]

I have restored my pages from a previous date on which the database results pages display properly.

My question then is, are there any known issues that I should consider before upgrading to FP2003.
Also, Can I take advantage of 2003 page layout capabilities, and yet continue to use FP 2002 for my database functions. Or does saving a file in 2003 also change the database results wizard area?
----- Gandy wrote: -----

I upgraded to FP 2003 from 2002.

I have been able to begin updating my pages with some of 2003 new stuff but a problem has occurred.

On all of the .asp pages on which i display database results I get the following error:

"Database Results Wizard Error
The operation failed. If this continues, please contact your server administrator. "

This error messages has occurred throughout my site although I have only worked on one or two pages with FP2003.

Also, all of my database results pages were working fine yesterday before I started working with FP2003.

Can anyone tell me how to get my database results pages to work again?

 

[Kathleen Anderson [MVP - FP]]

Gandy:

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"

 

[John Jansen \(MSFT\)]

Hi Gandy

If Kathleen's suggestion doesn't work, try this as well:

When the custom query is done on the update page that sends the change to
the database, it doesn't seem to include the field names and attributes in
the database region of the page. On the update page, look for "<!--webbot
bot="DatabaseRegionStart" s-columnnames s-columntypes" in the code view of
the update page and add the names of the two fields referenced in the query
and the appropriate code for the type of field it is. For example:

s-columnnames="PART_NO,PRICE" s-columntypes="202,202"

I have two fields here, and both are set up as text fields in the DB (202.)
Other codes are 3 for numeric, 135 for dates, 203 for memo (I think.) So if
I decide to use a numeric field for price, it should be:

s-columnnames="PART_NO,PRICE" s-columntypes="202,3"