Recordset fails

[bolin]

I am working with MS Access and Dreamweaver MX 2004. All code in my pages
(this time for sure!) is generated by DW. No hand coding at all.

My search results pages just will not work. I posted a few days back. I had
been leaning toward some sort of "rights" problem, but now I don't know about
that either.

- I CAN see every record in the database in a web page (using navigation -
multiple results thru repeat region, multiple pages using the
Insert\Application Objects graphic navigation bar).
- I CAN add a record to the database using the add.asp web page I created.
- I CAN retrieve a single record correctly from the database using the Test
button on the recordset while in Dreamweaver.
- I CAN retrieve a group of records correctly from the database using the TEST
button on the recordset while in Dreamweaver.

- While testing in the browser from inside of Dreamweaver, I get back the
result from the last search in Test inside of Dreamweaver..

- When I move to local host to test the system outside of Dreamweaver, no
matter what I enter into the search, I get back the result from the last search
in Test or the last search in the browser accessed from inside of Dreamweaver
(which was itself the result from the last search in Test).

- While in test mode, consecutive searches return the correct results time
after time. When I go to the Run command to use local host, the result of the
last search in Test is what shows on the results page.

- The site is set up in Dreamweaver with a folder on my desktop as local, and
the test server and the remote server both set up in a folder at
c:\inetpub\wwwroot\thatFolder\. There is only one copy of the database. It is
in the remote site (in "thatFolder").

Any suggestions would be appreciated!

[Bren]

Hi bolin

Check the spelling in your request statement i.e. Request.Form("Fieldname")
matches the form item you are submitting. As it sounds as if DW is using the
default value setting from within your recordset creation dialogue.

Regards
Bren

[bolin]

The add record to database page works.

[bolin]

Thanks, Bren.
I don't code much these days, but I think this is what you are referring to in
the javascript on one of the pages.

<%
var rsResultsN__MMColParam = "126.2b3b";
if (String(Request.QueryString("Field1")) != "undefined" &&
String(Request.QueryString("Field1")) != "") {
rsResultsN__MMColParam = String(Request.QueryString("Field1"));
}
%>

The "126.2b3b" is what I put in as a default on the advanced tab. If I read
that correctly, it should be replaced with the value held in "Field1". I have
double-checked. There are no times in 624 records where Field1 (or Field2) is
empty.

I don't see how anything I try can work in DW off the Test button, yet the
same values fail when I access for testing. Also it is true that Live View
works - correctly. It was the testing of that which led me to change the
default value from "1".

Nothing should be mistyped, because all the code is DW generated.

Thanks for the reply. At least it gave me more places to look for the answer.