What do you do - DRW???

[Art]

What do you do when you are doing a search of a SQL
database through DRW and an asp page and the error comes
back:

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


Nothing in the event viewer on either the web server or
the SQL server and nothing in the SQL logs

And the query is formated exactly as in
http://support.microsoft.com/default.aspx?scid=kb;en-
us;306430&Product=fp2002

for a numeric search form.

Where do you turn to look for answer????

 

[Jim Buyens]

For SQL server, it's normal to surround numeric, text, and
date field with apostrophes. This is different from
Access, where numeric values have no delimiters and date
have # delimiters.

If that doesn't provide the answer, make sure all your
numeric fields have defaults.

If that doesn't do it, rerun the Database Results Wizard
on the "live" server, and on page 2 click Custom Query,
Edit, and Verify Query. That may get you a better error
message.

If that still doesn't do it, copy the contents of the SQL
Statement box and paste them to a message in this thread.

Jim Buyens
Microsoft FrontPage MVP
http://www.interlacken.com
Author of:
*----------------------------------------------------
|\---------------------------------------------------
|| Microsoft Office FrontPage 2003 Inside Out
||---------------------------------------------------
|| Web Database Development Step by Step .NET Edition
|| Microsoft FrontPage Version 2002 Inside Out
|| Faster Smarter Beginning Programming
|| (All from Microsoft Press)
|/---------------------------------------------------
*----------------------------------------------------

 

[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

 

[Art]

Kathleen, if I knew where to send flowers I would

Thanks

It still doesnt work but at least we know what the error
is - it is a Precision error in SQL

Thanks Again