MySQL Lists are EOL. Please join:

List:General Discussion« Previous MessageNext Message »
From:bharani kumar Date:January 18 2010 3:13am
Subject:Re: query returning empty row
View as plain text  
thanks for reply, problem fixed,



On Mon, Jan 18, 2010 at 6:06 AM, Dan Nelson <dnelson@stripped> wrote:

> 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
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
> http://lists.mysql.com/mysql?unsub=1
>
>


-- 
Regards
B.S.Bharanikumar
http://php-mysql-jquery.blogspot.com/

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