if then

Results 1 to 3 of 3

Thread: if then

  1. #1
    Join Date
    Dec 1969
    Posts
    94

    Default if then

    is this legal? I can&#039t update the table for some reason.<BR>===<BR>&#060;%<BR>response.buffer = true<BR>email = Request.form("email")<BR><BR>if (InStr(1, email, "@", 1) = 0) then<BR>response.redirect "home.asp?id=1"<BR>end if<BR><BR>if email = "" then <BR>response.redirect "home.asp?id=1"<BR>else<BR><BR> Set rs = Server.CreateObject("ADODB.recordset")<BR> connectme="DSN=db1"<BR> sqlstmt = "UPDATE email SET email= &#039" & email & "&#039"<BR> rs.open sqlstmt, connectme<BR><BR>response.redirect "home.asp?id=2"<BR>end if<BR>%&#062;

  2. #2
    Join Date
    Dec 1969
    Posts
    2,849

    Default RE: if then

    Do you get an error, or does everything happen peachy keen and the table just isn&#039t updated?

  3. #3
    Join Date
    Dec 1969
    Posts
    94

    Default RE: if then

    Everything flows OK, but the db does not update.

Posting Permissions

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