html special characters and database problems, arg!

[John]

I am having problems with special characters with database calls (if I'm
referring to this in the right way). the problem is with apostrophes of all
things. If an end user puts an apostrophe in something ASP will interprete
it as a delimiter. This is aggravating because I'm trying to make this as
simple for the end user as possible and if they can't place something in a
simple text field like "Joe's Bar" (which comes out as "Joe") then I have a
problem because I don't have a solution for this. It appears that this "
´ " is not quite the same as " ' " and I don't see a special
character for apostrophes either.

This seems like a real pain in kee for something as small as this but it
confuses end users to not be able to write simple english.

 

[Steven Burn]

strMyQuery = Replace(Request.Form("txtSomeField"), "'", "")

Or

strMyQuery = Replace(Request.Form("txtSomeField"), "'", """)

--
Regards

Steven Burn
Ur I.T. Mate Group
www.it-mate.co.uk

Keeping it FREE!

 

[Blair Bonnett]

Or
strMyQuery = Replace(Request.Form("txtSomeField"), "'", "''")
will keep the apostrophe in the string...

Or, best yet, use parameterized queries through the ADODB.Command object...

http://www.4guysfromrolla.com/webtech/021799-1.shtml
http://www.4guysfromrolla.com/webtech/111798-1.shtml
http://www.allfreetech.com/ShowMain.asp?MainID=108&p=1

 

[Bob Barrows [MVP]]

I am having problems with special characters with database calls (if
I'm referring to this in the right way). the problem is with
apostrophes of all things. If an end user puts an apostrophe in
something ASP will interprete it as a delimiter. This is aggravating
because I'm trying to make this as simple for the end user as
possible and if they can't place something in a simple text field
like "Joe's Bar" (which comes out as "Joe") then I have a problem
because I don't have a solution for this. It appears that this "
´ " is not quite the same as " ' " and I don't see a
special character for apostrophes either.

This seems like a real pain in kee for something as small as this but
it confuses end users to not be able to write simple english.

Yes. Delimiters are a pain, aren't they? That's why I think it is a crime
that newbies are taught the wrong way (dynamic sql) before the right way
(stored procedures, passing parameters). You did not tell us what database
you are using so:

http://www.google.com/groups?hl=en&...&hl=en&lr=&ie=UTF-8&oe=UTF-8&start=10&sa=NBob Barrows--Microsoft MVP - ASP/ASP.NETPlease reply to the newsgroup. This email account is my spam trap so Idon't check it very often. If you must reply off-line, then remove the"NO SPAM"

 

[Steven Burn]

Bob hehe, the URL is majorly invalid <vbg>

--
Regards

Steven Burn
Ur I.T. Mate Group
www.it-mate.co.uk

Keeping it FREE!

Yes. Delimiters are a pain, aren't they? That's why I think it is a crime
that newbies are taught the wrong way (dynamic sql) before the right way
(stored procedures, passing parameters). You did not tell us what database
you are using so:

http://www.google.com/groups?hl=en&lr=&ie=UTF-8&oe=UTF-8&selm=e6lLVvOcDHA.12
04%40TK2MSFTNGP12.phx.gblhttp://www.google.com/groups?hl=en&lr=&ie=UTF-8&oe=
UTF-8&threadm=3bc06369.4904372%40news.charter.net&rnum=4&prev=/groups%3Fas_q
%3Ddelimiter%26safe%3Dimages%26ie%3DUTF-8%26oe%3DUTF-8%26as_uauthors%3DBob%2
520Barrows%26lr%3D%26hl%3Denhttp://tinyurl.com/jyy0http://www.google.com/gro
ups?hl=en&lr=&ie=UTF-8&oe=UTF-8&threadm=O31NZa%230DHA.3436%40tk2msftngp13.ph
x.gbl&rnum=11&prev=/groups%3Fq%3Ddelimiter%2Bauthor:Bob%2Bauthor:Barrows%26h
l%3Den%26lr%3D%26ie%3DUTF-8%26oe%3DUTF-8%26start%3D10%26sa%3DNBob
Barrows--Microsoft MVP - ASP/ASP.NETPlease reply to the newsgroup. This
email account is my spam trap so Idon't check it very often. If you must
reply off-line, then remove the"NO SPAM"

 

[Adrienne]

Bob hehe, the URL is majorly invalid <vbg>

But the Tiny URL is - http://tinyurl.com/jyy0

 

[Steven Burn]

<g> that'll work too .... cheers ;o)

--
Regards

Steven Burn
Ur I.T. Mate Group
www.it-mate.co.uk

Keeping it FREE!

 

[Bob Barrows [MVP]]

Yes. Delimiters are a pain, aren't they? That's why I think it is a
crime
that newbies are taught the wrong way (dynamic sql) before the right
way (stored procedures, passing parameters). You did not tell us what
database
you are using so:

http://www.google.com/groups?hl=en&...&hl=en&lr=&ie=UTF-8&oe=UTF-8&start=10&sa=NBob


I do not understand what happened to the line breaks. Let's try again:

http://www.google.com/groups?hl=en&lr=&ie=UTF-8&oe=UTF-8&[email protected]

http://www.google.com/groups?hl=en&...t&rnum=4&prev=/groups?as_q=delimiter&safe=ima
ges%26ie%3DUTF-8%26oe%3DUTF-8%26as_uauthors%3DBob%2520Barrows%26lr%3D%26hl%3
Den

http://tinyurl.com/jyy0

http://www.google.com/groups?hl=en&...ows&hl=en&lr=&ie=UTF-8&oe=UTF-8&start=10&sa=N