Home » Developer & Programmer » Forms » quotes problem
quotes problem [message #79087] Tue, 23 April 2002 06:11 Go to next message
massa
Messages: 12
Registered: April 2002
Junior Member
I am programing in asp and I am working on a program that make some querys on an oracle database.
The asp code works but not the querys and one paritcularly :
select * from people where User_Name='John';

The problem comes from the ' and it display this error :
ORA-12704: character set mismatch

I have tried the "", {}, [[]] and () but none of them worked so if someone has an idea, it could help.
Thanks
Christophe
Re: quotes problem [message #79090 is a reply to message #79087] Tue, 23 April 2002 07:51 Go to previous messageGo to next message
nik
Messages: 55
Registered: January 2002
Member
christophe,
i have experieced similar in report 2.5,
AFTER p trigger, does not like single quotes when
lexical referencing.

To get around this however I used '' to represent '
try , it might work.
e.g. where name = ''Doe'', this does not work in SQL*plus but did from within reports 2.5

nik.
Note: name = singlequotesinglequoteDOEsinglequotesinglequote [message #79091 is a reply to message #79087] Tue, 23 April 2002 07:54 Go to previous message
nik
Messages: 55
Registered: January 2002
Member
Note: name = singlequotesinglequoteDOEsinglequotesinglequote

eg ''DOE''
Previous Topic: Re: record has been updated by another user
Next Topic: SOMEONE PLEASE HELP
Goto Forum:
  


Current Time: Mon May 16 19:34:25 CDT 2022