Mark Hensler — Thu, 25 Oct 2001 07:22:58 +0000

I've been very bad about sleep the last week or so... never getting to bed before 1AM. (2/3 a few times)
I get up at 8AM, so I usually consider it a must to be in bed by midnight, but prefer something like 10PM.
I like my sanity sleep!

dcdomain — Thu, 25 Oct 2001 07:10:59 +0000

Thanks Mark! Worked like a charm!

Don't you ever sleep? =D

Mark Hensler — Thu, 25 Oct 2001 06:12:38 +0000

You need to escape the single quote. To do this, you just double the character. So, ' becomes '' (2 single quotes, not 1 double quote).

<% 
V_fname = "" 
v_fname = request.form("fname") 
v_lname = request.form("lname") 
v_email = request.form("email") 
v_school = request.form("school") 
v_relation = request.form("relation") 
v_mysite = request.form("mysite") 
v_comments = request.form("comments") 
beenthrough = request.form("beenthrough") 

' escape single quotes
v_fname = Replace(v_fname, "'", "''")
v_lname = Replace(v_lname, "'", "''")
v_email = Replace(v_email, "'", "''")
v_school = Replace(v_school, "'", "''")
v_relation = Replace(v_relation, "'", "''")
v_mysite = Replace(v_mysite, "'", "''")
v_comments = Replace(v_comments, "'", "''")

success = 0 
if beenthrough = 1 then 
    if (v_fname <> "" OR v_lname <> "" OR v_email <> "" OR v_school <> "" OR v_relation <> "" OR v_mysite <> "" OR v_comment <> "") then 
        set conn = server.createobject("adodb.connection") 
        conn.open("DBQ=" & server.mappath("dcdomain.mdb") & ";DRIVER={Microsoft Access Driver (*.mdb)};") 
        conn.execute("INSERT INTO guestbook (FName, LName, EMail, School, Relation, Mysite, Comments)" & _
        " VALUES ('" & v_fname & "', '" & v_lname & "', '" & v_email & "', '" & v_school & "', '" & v_relation & "', '" & v_mysite & "', '" & v_comments & "')") 
        conn.close 
        success=1 
    else 
%> 
error: please fill in all the fields 
<% 
    end if 

    if success = 1 then 
        response.redirect("thankyou.htm") 
    end if 
end if 
%> 