Wrox Home  
Search P2P Archive for: Go

  Return to Index  

asp_databases thread: Updating Access database using ASP


Message #1 by "Tin Danicker" <reverseassmosis@y...> on Wed, 20 Mar 2002 23:46:54
I am having problems updating my Access database.  
- First the user searchs for a user in the database to update.  
- A list of possible users shows up in a table with the firstname as a 
link.  By clicking on the link, it sends the users ID to the form page.  I 
open the database in that page and get their information, and display it 
in text boxes so they can make changes.  

My problem is when they click the submit button, it goes to the 
chkRegisterUser page, I strFirstName = Request.Form("txtboxstuff") from 
the previous page but when it goes to update, it says there is nothing in 
the strFirstName.  I am using a stored procedure to update.  Any ideas on 
why this isn't working?
Message #2 by "Ken Schaefer" <ken@a...> on Thu, 21 Mar 2002 16:02:26 +1100
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
From: "Tin Danicker" <reverseassmosis@y...>
Subject: [asp_databases] Updating Access database using ASP


: I am having problems updating my Access database.
: - First the user searchs for a user in the database to update.
: - A list of possible users shows up in a table with the firstname as a
: link.  By clicking on the link, it sends the users ID to the form page.  I
: open the database in that page and get their information, and display it
: in text boxes so they can make changes.
:
: My problem is when they click the submit button, it goes to the
: chkRegisterUser page, I strFirstName = Request.Form("txtboxstuff") from
: the previous page but when it goes to update, it says there is nothing in
: the strFirstName.  I am using a stored procedure to update.  Any ideas on
: why this isn't working?

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

>> The error is on line 8

> How do you know? I didn't post any code

Exactly

Cheers
Ken

Message #3 by "Tin Danicker" <reverseassmosis@y...> on Fri, 22 Mar 2002 02:39:15

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

>> The error is on line 8

> How do you know? I didn't post any code

Exactly

Cheers
Ken


Ken,  
  
I realized my error after i posted this question, but thanks for pointing 
it out..i was having two problems, i solved this one, but the bigger 
problem i posted today, which does contain my code..please tell me what 
you think.. 

thanks,
  
DFM


  Return to Index