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

Hosting from $3.99 per month!

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

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

Search Forums
 

Advanced search
Recent Posts

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

 

update database with session

 
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 database with session
Page: [1]
 
ACEDISH

 

Posts: 176
Joined: 9/30/2002
From: Manassas, Virginia
Status: offline

 
update database with session - 12/3/2004 15:36:27   
I am trying to update a database with session information and not having any luck. Using FP2003 DRW on a diet I have editied theses line to try to capture the session info but no info makes it to the database.

                
	arFormFields0(1) = "emp"
	arFormDBFields0(1) = "emp"
	arFormValues0(1) = Session("fname")









_____________________________

" Anyone who can only think of one way to spell a word obviously lacks imagination"
Spooky

 

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

 
RE: update database with session - 12/3/2004 20:43:35   
Can you remove the original "ON ERROR RESUME NEXT" ?

_____________________________

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

§þ:)


(in reply to ACEDISH)
ACEDISH

 

Posts: 176
Joined: 9/30/2002
From: Manassas, Virginia
Status: offline

 
RE: update database with session - 3/17/2005 17:38:44   
I deleted "ON ERROR RESUME NEXT" and go this error...

Microsoft VBScript runtime error '800a000d'

Type mismatch: 'FP_DumpError'

/bpltrack/efs2.asp, line 473

here is the code for that line

470 fp_rs.Update
471 FP_DumpError strErrorUrl, "Cannot update the database"
472
472 fp_rs.Close
474 fp_conn.Close
475
476 Session("FP_SavedFields")=arFormFields0
etc Session("FP_SavedValues")=arFormValues0
Session.CodePage = Session("FP_OldCodePage")
Session.LCID = Session("FP_OldLCID")
Response.Redirect "Invoice/payments.asp?ID="&arFormValues0(5)&"&status="&arFormValues0(13)



any recomendations...

_____________________________

" Anyone who can only think of one way to spell a word obviously lacks imagination"

(in reply to Spooky)
Spooky

 

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

 
RE: update database with session - 3/17/2005 20:21:07   
Try :

Call FP_DumpError (strErrorUrl&"", "Cannot update the database" )

_____________________________

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

§þ:)


(in reply to ACEDISH)
Page:   [1]
OutFront Discoveries

All Forums >> Web Development >> ASP and Database >> update database with session
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