SQL insert statement

Results 1 to 3 of 3

Thread: SQL insert statement

  1. #1
    Join Date
    Dec 1969

    Default SQL insert statement

    I want to take information from a form and using an insert sql statement write it to an access database. Every field writes to the database except the password field. The following is the sql statement:<BR>sSQL = "INSERT INTO tblSecurity(name,email,userID,password,userlevel)V ALUES(&#039" &strUserName&"&#039,&#039"&strEmail&"&#039,&#039"& strUserID&"&#039,&#039"&strPassword&"&#039,1)"<BR> can anyone see why this will not work<BR> Dconn.Execute sSQL<BR> Dconn.Close<BR> Set Dconn = Nothing<BR><BR>

  2. #2
    InstrRev Guest

    Default RE: SQL insert statement

    Put a space before VALUES

  3. #3
    Join Date
    Dec 1969

    Default RE: SQL insert statement

    If that doesn&#039t work try a Response.Write of the password variable. Who knows? Maybe it is empty.<BR><BR>Response.Write "&ltBR&gtPassword entered:" & strPassword

Posting Permissions

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