custom query problem

[workinghard]

In a custom query using a mysql connection or a MS access connection, every timei try to specify field names to present in on the results page I get the following error:

"DATABASE RESULTS ERROR, this operation failed. If this continues please contact your server administrator." Can anyone tell my why I get

If I use a querie such as: Select * from products everything will display fine. but if i specify a query such as: SELECT price from products I get the error.

I know that the field names are correct but everytime i try to specify and that my connections are valid. Its just that FP 2003 will no longer allow me to specify the field names. I have created several page where I specified the field names and those pages all worked fine until yesterday. Then all of thepages where I have specified the field names nowgive the error.

Why all of thesudden would these pages no longer function.

As long as I use the (*) to specify field names, the results pages will work, But if I try to specify the field names the pages giveme the error.

Can anyone help me with this problem?

 

[Kathleen Anderson [MVP - FP]]

To see the true error, open the hidden folder /_fpclass/ and edit the
fpdbrgn1.inc file

At about line 19, change :

fp_DEBUG = False

to :

fp_DEBUG = True


--
~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
http://www.spiderwebwoman.com/resources/
Connect to the Newsgroups with Outlook Express
http://www.tushar-mehta.com/misc_tutorials/oe_ng/index.html

 

[Workinghard]

Thank you,
The true error directed me to article 817029. This solution provides a possible workaround but I have over 60 pages of formatted results that Im trying to avoid having to rebuild. These .asp pages all worked fine until yesterday when I saved a page with database results as I normally do. I then checked to see that the page was working, and discovered the error. Not only on this page but on all of my .asp pages. It is a very tedious process to rebuild all of these pages. Is there some kind of setting or permissions that somehow got changed that now wont allow my .asp pages to function? Why did this happen all of the sudden. Please Help

 

[Kathleen Anderson [MVP - FP]]

Check out this thread in the OutFront forums:
http://www.frontpagewebmaster.com/m-175524/tm.htm

--
~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
http://www.spiderwebwoman.com/resources/
Connect to the Newsgroups with Outlook Express
http://www.tushar-mehta.com/misc_tutorials/oe_ng/index.html