List:General Discussion« Previous MessageNext Message »
From:Dan Nelson Date:January 18 2010 12:36am
Subject:Re: query returning empty row
View as plain text  
In the last episode (Jan 17), bharani kumar said:
> SELECT updateDate,cHospital,cHospital1,cHospital2 FROM med_patient WHERE
> cCurstatus!='completed' AND cMmrcashworker = '2' AND
> (cHospital = '1234' OR cHospital1 = '1234' OR cHospital2 ='1234') AND
> updateDate between '2010-01-01' and '2010-01-28' order by id desc
> 
> I have one patient entry,and his  updateDate is 2010-01-17 ,
> 
> but my above query return empty row , Why ?
> 
> (  Note -->  my updateDate  field is varchar type)

Perhaps his hospital ID is not 1234, or cMmrcashworker is not 2, or
cCurstatus = 'complete'.  Try

 SELECT updateDate,cCurstatus,cMmrcashworker,cHospital,cHospital1,cHospital2
 FROM med_patient WHERE updateDate between '2010-01-01' and '2010-01-28'
 order by id desc

and verify that the other fields in your WHERE clause have the values you
think they do.

-- 
	Dan Nelson
	dnelson@stripped
Thread
query returning empty rowbharani kumar17 Jan
  • Re: query returning empty rowDan Nelson18 Jan
    • Re: query returning empty rowbharani kumar18 Jan
      • Regarding storing non-english chars in mysqlNingappa  Koneri18 Jan
        • RE: Regarding storing non-english chars in mysqlGavin Towey18 Jan
          • Re: Regarding storing non-english chars in mysqlfsb18 Jan
            • RE: Regarding storing non-english chars in mysqlNingappa  Koneri19 Jan
              • Re: Regarding storing non-english chars in mysqlfsb19 Jan
                • RE: Regarding storing non-english chars in mysqlJerry Schwartz19 Jan