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

 

UPDATE DATABSE THEN REFRESH

 
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 >> UPDATE DATABSE THEN REFRESH
Page: [1]
 
Guest


 
UPDATE DATABSE THEN REFRESH - 5/14/2001 13:13:00   
Is it possible to use a form to update a database then have the code to update on the same page and then after the record has been updated show the new record all on the same page.

Regards

William

rdouglass

 

Posts: 9280
From: Biddeford, ME USA
Status: offline

 
RE: UPDATE DATABSE THEN REFRESH - 5/14/2001 14:46:00   
I don't know about specifically refreshing that page, but I do accomplish something similar using 2 pages.

1. The first page has the form to enter the updates / changes.

2. The first page posts to a second page that contains the custom queries to update.

3. Once the DRW code runs, I have a meta-refresh tag to return to the first page and lookup the updated info and fill in the page. My meta code is just:

<%
Response.Redirect "mypage.asp?myField=" & FP_FieldVal(fp_rs,"myField")
%>

It runs quick enough so that I don't even see the second page....


(in reply to Guest)
Spooky

 

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

 
RE: UPDATE DATABSE THEN REFRESH - 5/14/2001 16:49:00   
Check your page caching options too.
I always use :

<%
Response.ExpiresAbsolute = Now() - 1
Response.AddHeader "Cache-Control", "must-revalidate"
Response.AddHeader "Cache-Control", "no-cache"
%>


(in reply to Guest)
Guest


 
RE: UPDATE DATABSE THEN REFRESH - 5/14/2001 17:17:00   
I must be doing something wrong I am getting this error message

Response object error 'ASP 0156 : 80004005'

Header Error

/frisque/ADMINENG/updatehome.asp, line 68

The HTTP headers are already written to the client browser. Any HTTP header modifications must be made before writing page content.


(in reply to Guest)
Spooky

 

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

 
RE: UPDATE DATABSE THEN REFRESH - 5/14/2001 17:22:00   
Add a

Response.buffer = True

in there as well


(in reply to Guest)
Page:   [1]

All Forums >> Web Development >> ASP and Database >> UPDATE DATABSE THEN REFRESH
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