www.webdeveloper.com
Results 1 to 2 of 2

Thread: Inserting password column into the Table

  1. #1
    Join Date
    Feb 2003
    Posts
    30

    Inserting password column into the Table

    I'm trying to INSERT the customer information record into Access table after the customer registers, i can add all the fileds to database table except password column. password is encrypted in my form. Can someone help me how to decrypt the password and insert into text field of the database. BTW i'm using ASP to execute SQL statement.
    Thanks

  2. #2
    Join Date
    Dec 2002
    Location
    Pensacola
    Posts
    263
    I think I remember hearing that the word "password" is a reserved word in Access, so you have to enclose the word "password" in braces in your SQL statement:

    For Example:
    strSQL = "INSERT INTO tblUSER Username,[Password] VALUES('" & Request.Form("txtuser") & "','" & Request.Form("txtpassword") & "')


    Hope this solves your problem.. I once made this mistake and it cost me a day of work.
    Cheers!
    Rob

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center



Recent Articles