dbStartUp="EditUpdate" Problems

[Ted Moore]

Dear Forum Folks,
Background:
Windows 2000 / Access database
Server Software: Microsoft-IIS/5.0
Server Protocol: HTTP/1.1
VBScript Engine: 5.1.5907
ASPdb Universal Version: ASPDB2001-06.20-SP3-ADO21-MTS-Std

I have two pages - the first one (dbUnit=1911) is a projects table with an edit button on each record that links via MagicCell to the second page (dbUnit=5001) which should open to EditUpdate for the record of interest.

I use the two page setup because there are several related tables to edit (on additional second pages).

From previous discussions on this issue (John's Feb 2002 post), my link is as follows:
<A HREF=&#34;&#34;admin-projects-general.asp?ProjectID=#ProjectID#&ProjectName=#Pro jectName#&ASPdbUnit=5001&#34;&#34;>

At the destination page the ID and Name are the Request variables currentProjectID and currentProject Name. I use the following to set page variables:

If Request(&#34;ProjectID&#34 = &#34;&#34; Then
currentProjectID = session(&#34;savedProjectID&#34
Else
session(&#34;alreadystartup_5001&#34=false
session(&#34;Newsession_5001&#34=true
session(&#34;Alive_5001&#34=false
End If
session(&#34;savedProjectID&#34 = currentProjectID

The ASPdb SQL looks like:
x.dbSQL = &#34;SELECT * FROM Projects WHERE ProjectID=&#34; & currentProjectID

At the top of the page I display Project Name (using regular ASP and the Request variables) and it is always correct. But, no matter what I do, I keep getting the record from the previous request displayed by the ASPdb section below. I have been working on this problem for days. I have displayed all the variables before and after each section and they appear correct.

Any ideas? Thanks, Ted

[Ted Moore]

Thanks Mark, but that wasn&#39;t it. I should have included the line before the &#34;IF&#34; which was the one you suggested:
currentProjectID = Request(&#34;ProjectID&#34

I have inserted &#34;Response Writes&#34; throughout the page and it shows the currentProjectID is the one I selected immediately before going into the ASPdb section. It show the correct one after the ASPdb section also.

Is it possible the ASPdb code is running before the other code? I also get an error the very first time I request the record:
Error # (Get_RS_GetCount - After open CountSQL) = 80040E0C(-2147217908)
Description = Command text was not set for the command object.

Still searching.



------------
Mark at 4/25/2002 10:08:09 AM

Hi Ted,
The first time in your currentProjectID never gets defined.

If Request(&#34;ProjectID&#34 = &#34;&#34; Then
currentProjectID = session(&#34;savedProjectID&#34
Else
currentProjectID = Request(&#34;ProjectID&#34 &#39; **** ADD THIS LINE
session(&#34;alreadystartup_5001&#34=false
session(&#34;Newsession_5001&#34=true
session(&#34;Alive_5001&#34=false
End If
Session(&#34;savedProjectID&#34 = currentProjectID

That should help.
Mark


------------
Ted Moore at 4/24/2002 5:26:17 PM

Dear Forum Folks,
Background:
Windows 2000 / Access database
Server Software: Microsoft-IIS/5.0
Server Protocol: HTTP/1.1
VBScript Engine: 5.1.5907
ASPdb Universal Version: ASPDB2001-06.20-SP3-ADO21-MTS-Std

I have two pages - the first one (dbUnit=1911) is a projects table with an edit button on each record that links via MagicCell to the second page (dbUnit=5001) which should open to EditUpdate for the record of interest.

I use the two page setup because there are several related tables to edit (on additional second pages).

From previous discussions on this issue (John&#39;s Feb 2002 post), my link is as follows:
<A HREF=&#34;&#34;admin-projects-general.asp?ProjectID=#ProjectID#&ProjectName=#Pro jectName#&ASPdbUnit=5001&#34;&#34;>

At the destination page the ID and Name are the Request variables currentProjectID and currentProject Name. I use the following to set page variables:

If Request(&#34;ProjectID&#34 = &#34;&#34; Then
currentProjectID = session(&#34;savedProjectID&#34
Else
session(&#34;alreadystartup_5001&#34=false
session(&#34;Newsession_5001&#34=true
session(&#34;Alive_5001&#34=false
End If
session(&#34;savedProjectID&#34 = currentProjectID

The ASPdb SQL looks like:
x.dbSQL = &#34;SELECT * FROM Projects WHERE ProjectID=&#34; & currentProjectID

At the top of the page I display Project Name (using regular ASP and the Request variables) and it is always correct. But, no matter what I do, I keep getting the record from the previous request displayed by the ASPdb section below. I have been working on this problem for days. I have displayed all the variables before and after each section and they appear correct.

Any ideas? Thanks, Ted