quotes problem [message #19998] |
Tue, 23 April 2002 07:06 |
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 #20012 is a reply to message #19998] |
Wed, 24 April 2002 06:17 |
motiram
Messages: 21 Registered: January 2001
|
Junior Member |
|
|
Probably you should check if your query is enclosed in another single quote. Can you put the complete part of code where you are getting problem. If query is executed in Sqlplus it should be executed in ASP, JSP or anything.
Cheers.
|
|
|