Database Error

[Guest]

I have a database that I am querying. I created a custom query with the
following code:

SELECT * FROM SpecialtyID a, Members b WHERE (a.SpecialtyID=::SpecialtyID::
AND a.MemberID=b.MemberID AND b.FindDietitian='Yes') ORDER BY b.LastName ASC

The URL is http://www.njdhcf.com/find_a_dietitan-search_by_specialty.asp
When you click the submit button, this error message comes up:"Database
Results Wizard Error. The operation failed. If this continues, please
contact your server administrator."

Any suggestions?

 

[Bob Lehmann]

Any suggestions?
Yes. Please contact your server administrator.

Bob Lehmann

 

[Stefan B Rusynko]

First turn on detailed errors in the DBRW to see what the error is
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


--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
To find the best Newsgroup for FrontPage support see:
http://www.frontpagemvps.com/FrontPageNewsGroups/tabid/53/Default.aspx
_____________________________________________


|I have a database that I am querying. I created a custom query with the
| following code:
|
| SELECT * FROM SpecialtyID a, Members b WHERE (a.SpecialtyID=::SpecialtyID::
| AND a.MemberID=b.MemberID AND b.FindDietitian='Yes') ORDER BY b.LastName ASC
|
| The URL is http://www.njdhcf.com/find_a_dietitan-search_by_specialty.asp
| When you click the submit button, this error message comes up:"Database
| Results Wizard Error. The operation failed. If this continues, please
| contact your server administrator."
|
| Any suggestions?
|
|