|
|
|
|
|
| | |
| |
Active Server Pages asp source code database MS SQL MS Access .mdb adovbs.inc cookies calendar codes sql commands scripts asp programming tutorials iis web server components CJWSoft ASPProtect ASPBanner ASPClassifieds
(Advanced)
(Components)
(Database)
(General)
(Vbscript)
|
|
|
|
Subject: |
How to remove single quote ? |
|
From: |
lisa |
|
Date: |
4/8/1999 6:05:37 PM |
|
IP: |
209.111.130.2 |
I have a input form. Everytime I input some words with single quote. I got error message. I knew I have to add some scripts to remove single quote. I copied other people's scripts, but it still doesn't work on my page.
Anyone can help me?
<%
dim newInput, name, email
newInput=request.form("new")
if newInput = "yes" then
name = request.form("name")
email = request.form("email")
set conn = server.createObject("ADODB.Connection")
conn.open "data"
conn.execute "INSERT INTO datafile" _
& "( name, email)"_
& "VALUES (" _
& "'" & name & "', " _
& "'" & email & "')"
conn.close
end if
%>
Thanks
|
Follow Up - Re: How to remove single quote ? - Paul Simpson 4/9/1999 3:14:01 AM
Follow Up - Re: How to remove single quote ? - Rick Dale 4/11/1999 11:52:22 PM
Follow Up - Re: How to remove single quote ? - Fredrik Vestin 4/22/1999 3:22:41 PM
Follow Up - Re: How to remove single quote ? - Bill Stride 5/21/1999 11:30:38 AM
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
