|
 |
access_asp thread: Strip Slashes ADODB Error
Message #1 by "Sokun, Chorn" <sokunxp@g...> on Sun, 3 Feb 2002 21:46:21 +0700
|
|
This is a multi-part message in MIME format.
------=_NextPart_000_0013_01C1ACFC.3824B3B0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Dear All,
I have a problem with Database storing record
ok let me describe:
I got a form like this:
Name : [ ]
E-mail: [ ]
[Submit]
now I try to save what they type and submit.
what happen when they enter
Name : [ Sokun' ]
E-mail: [ sokunxp@g... ' ]
[Submit]
what I mean is the ` ' ` was entered by accident.
Then I got error is there a way to strip the slashes?
=A2----------------------------------------------------------------------
---=A2
Sokun, Chorn
=A2----------------------------------------------------------------------
---=A2
Message #2 by "Webmaster" <webmaster@g...> on Sun, 3 Feb 2002 22:00:53 +0100
|
|
This is a multi-part message in MIME format.
------=_NextPart_000_0002_01C1ACFE.4564D030
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Try this:
email =3D Replace(email, Chr(34),"")
Chr(34) removes the double quotes, so you have to find out the Chr for
=91
Sometimes you need to accept this char though=85.. fx. in N=92Sync
Then it=92s better to use this code:
email =3D Replace(Request.Form("email"), " ' ", " '' ")
Good luck
Bjoern
-----Original Message-----
From: Sokun, Chorn [mailto:sokunxp@g...]
Sent: 3. februar 2002 15:46
To: Access ASP
Subject: [access_asp] Strip Slashes ADODB Error
Dear All,
I have a problem with Database storing record
ok let me describe:
I got a form like this:
Name : [ ]
E-mail: [ ]
[Submit]
now I try to save what they type and submit.
what happen when they enter
Name : [ Sokun' ]
E-mail: [ sokunxp@g... ' ]
[Submit]
what I mean is the ` ' ` was entered by accident.
Then I got error is there a way to strip the slashes?
=A2----------------------------------------------------------------------
-
--=A2
Sokun, Chorn
=A2----------------------------------------------------------------------
-
--=A2
$subst('Email.Unsub').
Message #3 by "Webmaster" <webmaster@g...> on Mon, 4 Feb 2002 00:03:12 +0100
|
|
This is a multi-part message in MIME format.
------=_NextPart_000_0001_01C1AD0F.5B472B30
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Not in email though ;-)
Bjoern
-----Original Message-----
From: Webmaster [mailto:webmaster@g...]
Sent: 3. februar 2002 22:01
To: Access ASP
Subject: [access_asp] RE: Strip Slashes ADODB Error
Try this:
email =3D Replace(email, Chr(34),"")
Chr(34) removes the double quotes, so you have to find out the Chr for
=91
Sometimes you need to accept this char though=85.. fx. in N=92Sync
Then it=92s better to use this code:
email =3D Replace(Request.Form("email"), " ' ", " '' ")
Good luck
Bjoern
-----Original Message-----
From: Sokun, Chorn [mailto:sokunxp@g...]
Sent: 3. februar 2002 15:46
To: Access ASP
Subject: [access_asp] Strip Slashes ADODB Error
Dear All,
I have a problem with Database storing record
ok let me describe:
I got a form like this:
Name : [ ]
E-mail: [ ]
[Submit]
now I try to save what they type and submit.
what happen when they enter
Name : [ Sokun' ]
E-mail: [ sokunxp@g... ' ]
[Submit]
what I mean is the ` ' ` was entered by accident.
Then I got error is there a way to strip the slashes?
=A2----------------------------------------------------------------------
-
--=A2
Sokun, Chorn
=A2----------------------------------------------------------------------
-
--=A2
$subst('Email.Unsub').
$subst('Email.Unsub').
|
|
|
View Cart
