navigation
a webmaster learning community
     Home    Register     Search      Help      Login    
FrontPage Alternative
Sponsors

Shopping Cart Software
Ecommerce software integrated into Frontpage, Dreamweaver and Golive templates. No monthly fees and available in ASP and PHP versions.

Website Templates
We also have a wide selection of Dreamweaver, Expression Web and Frontpage templates as well as webmaster tools and CSS layouts.

Frontpage website templates
Creative Website Templates for FrontPage, Dreamweaver, Flash, SwishMax

Free FrontPage Templates

Search Forums
 

Advanced search
Recent Posts

 Todays Posts
 Most Active posts
 Posts since last visit
 My Recent Posts
 Mark posts read

 

***solved***Session variable not available when page 1st displayed

 
View related threads: (in this forum | in all forums)

Logged in as: Guest
Users viewing this topic: none
Printable Version 

All Forums >> Web Development >> ASP and Database >> ***solved***Session variable not available when page 1st displayed
Page: [1]
 
mylu

 

Posts: 128
Joined: 9/11/2006
Status: offline

 
***solved***Session variable not available when page 1s... - 3/8/2007 15:47:19   
I'm using the post / action method to display data on a second page.

<form method="POST" action="rpts/rptopencalls.asp">
<input type="submit" value="Open SO's" name="B1"><input type="hidden" name="<%response.write "accountid" %>" size="20" value="<%=Session(appName&"x_spare")%>">
</form>

This code works fine but only after you you hit the page rptopencalls.asp the first time.
The first time you submit the data the DRW returns no records as if the session is not loaded.

If you click on the back button then submit again all is well and all the submit buttons work and pull data from the different reports.

Any idea?

Thanks

< Message edited by mylu -- 3/9/2007 16:56:45 >
Spooky

 

Posts: 26606
Joined: 11/11/1998
From: Middle Earth
Status: offline

 
RE: Session variable not available when page 1st displayed - 3/8/2007 17:25:32   
If you view the html source of the first page, does it show the correct values?

_____________________________

If you arent part of the solution, then there is good money to be made prolonging the problem

§þ:)


(in reply to mylu)
mylu

 

Posts: 128
Joined: 9/11/2006
Status: offline

 
RE: Session variable not available when page 1st displayed - 3/9/2007 12:46:34   
Source View

<form method="POST" action="rpts/rptopencalls.asp">
<input type="submit" value="Open SO's" name="B1" style="font-family: Tahoma; font-size: 8pt"><input type="hidden" name="accountid" size="20" value="DSS"></form>

value="DSS"

Yes it does.



(in reply to Spooky)
BeTheBall

 

Posts: 6381
Joined: 6/21/2002
From: West Point Utah USA
Status: offline

 
RE: Session variable not available when page 1st displayed - 3/9/2007 12:50:42   
What is the SQL you are using for the DRW?

_____________________________

Duane

Some people are like Slinkies . . . Not really good for anything . . . . . But they still bring a smile to your face when you push them down a flight of stairs.

(in reply to mylu)
mylu

 

Posts: 128
Joined: 9/11/2006
Status: offline

 
RE: Session variable not available when page 1st displayed - 3/9/2007 15:49:56   
fp_sQry="SELECT * FROM OpenServiceOrderstech WHERE (AccountID = '::AccountID::' AND Status <> 'closed' AND Status <> 'void') ORDER BY SONumber DESC"

No diet here. It's the only statement on the page.

(in reply to BeTheBall)
BeTheBall

 

Posts: 6381
Joined: 6/21/2002
From: West Point Utah USA
Status: offline

 
RE: Session variable not available when page 1st displayed - 3/9/2007 15:52:27   
Do you have a link we can look at?

_____________________________

Duane

Some people are like Slinkies . . . Not really good for anything . . . . . But they still bring a smile to your face when you push them down a flight of stairs.

(in reply to mylu)
mylu

 

Posts: 128
Joined: 9/11/2006
Status: offline

 
RE: Session variable not available when page 1st displayed - 3/9/2007 16:56:21   
Resolved. Went on a diet....
Thanks again

(in reply to BeTheBall)
Page:   [1]

All Forums >> Web Development >> ASP and Database >> ***solved***Session variable not available when page 1st displayed
Page: [1]
Jump to: 1





New Messages No New Messages
Hot Topic w/ New Messages Hot Topic w/o New Messages
Locked w/ New Messages Locked w/o New Messages
 Post New Thread
 Reply to Message
 Post New Poll
 Submit Vote
 Delete My Own Post
 Delete My Own Thread
 Rate Posts