Re: escape character in queries?

In article <3726D361.F0FCB9F1_at_ComArch.pl>,   rkajda <rkajda_at_ComArch.pl> wrote:
> This is a multi-part message in MIME format.
> --------------D1EC89E1F0F70313AF8450C0
> Content-Type: text/plain; charset=iso-8859-2
> Content-Transfer-Encoding: 7bit
>
> Hi
> Use ' before ' (apostrophe is escapee for itself)
> for example
> insert into tab( col ) values( 'That''s the question' ) and
> select *
> from tab
> where col like 'That''s the question'
>

this is not really the problem, I need this query:

ctx_query.contains('policy_name',
                   'NT(That's the question,1,THES_NAME)',
                   'RES_TABLE');

This query is used with the ConText server. It enables to ask a question to the thesaurus THES_NAME to search the Narrower Term (NT) of That's the question.

In Oracle developper's guide, they say that in order to escape special character like ' & , ( .... I have to use \ character. It works for many characters, but it doesn't work for '

When I put two ' ('') in the query, the ConText server doesn't accept the syntax. If I only put one, that's the PL/SQL compiler that doesn't accept the syntax.

That's my problem!

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Wed Apr 28 1999 - 07:32:26 CDT