ASP Page(s) - Database Results Error - When adding drop down box

[chutcheson]

I have several ASP pages on my website that do not work. Im running IIS6.0 on WIN2K3 w/sharepoint2.0

Active Server Pages are enabled
Sharepoint is set to ignore ASP
Sharepoint allows ASP

Most of the ASP pages work, it's only the ones that pass parameters that don't work. If I'm just returning data, everything works fine. If I choose a data type to return I get the error= Database Results Error Contact Administrator.

Any ideas?
Thanks

 

[FesterSXS]

How are you passing these parameters on the pages that do not work?

Tony

http://www.SpiraxSarco.com

 

[chutcheson]

Im using Frontpage 2002, to create the database results fields. Then adding a drop down to select the criteria that I want to query against. If I just bring back the data it works, but when I add the drop down I get the error.

 

[FesterSXS]

might be worth asking this in the Frontpage forum - Forum256

Tony

http://www.SpiraxSarco.com

 

[chutcheson]

10-4, I put it there to.

 

[chutcheson]

seems to be working with everything except dates?!?!?!?

 

[onpnt]

if the DB is Access are you encapsulating the dates in # # when querying them

___________________________________________________________________
[sub]

http://www.onpnt.com

The answer to your ??'s may be closer then you think.
Check out Tek-Tips knowledge bank by clicking the FAQ link at the top of the page faq333-3811[/sub]

 

[chutcheson]

The data is coming from a SQL server. If I substitute the hardcoded dates into the query it runs and displays the page w/data. If I insert a parameter for the user to type in the date from a text box it gives me an error.

 

[Chopstik]

Could you perhaps post the relevant code and we could review from there?

------------------------------------------------------------------------------------------------------------------------
"The major difference between a thing that might go wrong and a thing that cannot possibly go wrong is that when a thing that cannot possibly go wrong goes wrong it usually turns out to be impossible to get at or repair."
--Dou

 

[chutcheson]

Better late than never, I didn't post back when I figured the problem out, but "fpdbrgn1.inc" was giving me grief when it was replaced whenever I would use the DRW in Frontpage. I replaced this file with a backup and everything started working fine!