madam if u are using ORACLE then i hope u have gone MAD thats all as i tried
in oracle its working fine and u are telling its not !
create table blood (
id varchar2(3)
)
insert into blood values('A+')
insert into blood values('A-')
select * from blood where id = 'A+'
select * from blood where id = 'A-'
----- Original Message -----
From: "Vaishali S. Pandya" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, August 12, 2002 5:06 PM
Subject: "+" sign in query not working
> hi friends
> i have a trouble in my query
>
> Select * from EM
> Where blood_grp = "O-"
>
> it gives me proper output all rows having blood group "O-"
>
> but blood_grp="O+"
> is not working.
> same for "A-", "B-" and "AB-" is working fine
> and "A+", "B+" and "AB+" is not working at all and returns zero number of
> rows
> why it is there?
> + sign have any meaning in qry?
> here this query is working fine backend side if i fier it directly on
> database.
>
> Thanks in advance
> Vaishali
>
>
===========================================================================
> To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff
JSP-INTEREST".
> For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST
DIGEST".
> Some relevant FAQs on JSP/Servlets can be found at:
>
> http://archives.java.sun.com/jsp-interest.html
> http://java.sun.com/products/jsp/faq.html
> http://www.esperanto.org.nz/jsp/jspfaq.jsp
> http://www.jguru.com/faq/index.jsp
> http://www.jspinsider.com
**************************Disclaimer************************************
Information contained in this E-MAIL being proprietary to Wipro Limited is
'privileged' and 'confidential' and intended for use only by the individual
or entity to which it is addressed. You are notified that any use, copying
or dissemination of the information contained in the E-MAIL in any manner
whatsoever is strictly prohibited.
***************************************************************************
