Wednesday, March 28, 2012

Query Problem

Ok,

I know that this is supposed to be simple, but I cannot remember how to get around it. How does one get around the following problem?


update sources
Set Reference = 'Coaching Women's Soccer'
where Refsymbol = 'w'

How does one get around extra quotation mark (the apostrophe in Women's).When you insert into database, you replace a single quatation mark with 2 single quotation marks:


' -> ''

When you want to show the record on a web page, you reverse the procedure:

'' -> '

You should write a function to handle this and other characters like e.g. < and > throughout your application.

Hth.|||Thanks :)

No comments:

Post a Comment