Database Error

  • Thread starter Thread starter Guest
  • Start date Start date
G

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?
 
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?
|
|
 
Back
Top