Wrox Home  
Search P2P Archive for: Go

  Return to Index  

asp_databases thread: Database question


Message #1 by "Nick Pitzer" <n_pitzer@h...> on Tue, 31 Jul 2001 12:50:15 -0400

Is there a way in ASP I can pass Data to an access database and pass the 

parameters to another page at the same time?



Thanks in Advance



Message #2 by "J House" <jesse@s...> on Tue, 31 Jul 2001 20:11:21
Sort of,

load your form input into variables

insert them into the database

redirect to another page and send the variables in the querystring or

display the variables on the same page or whatever you want.



ie

strName = Request.Form("Name")



strSql = "INSERT INTO Employee SET Name = '" & strName & "'"

objConn.open(connectionstring)

objConn.Execute(strSql)



Response.redirect "thanks.asp?name=" & strName



> Is there a way in ASP I can pass Data to an access database and pass the 



> parameters to another page at the same time?

> 

> Thanks in Advance

> 


  Return to Index