1 Reply Latest reply: Dec 29, 2012 10:37 AM by Srini VEERAVALLI RSS

    error getting drill down

    908588
      Error getting drill information: SELECT SUBSTRING(cast(etxnmistopbr.month_year as char) FROM 1 FOR 11) saw_0, etxnmistopbr.tot_txns saw_1, cast(etxnmistopbr.month_year as date) saw_2 FROM "Dly Channel" WHERE cast(etxnmistopbr.month_year as date) between ('2012-03-31','2012-10-31')
      Error Details
      Error Codes: YQCO4T56:OPR4ONWY:U9IM8TAC:OI2DL65P
      Odbc driver returned an error (SQLExecDirectW).
      State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. [nQSError: 27002] Near <,>: Syntax error [nQSError: 26012] . (HY000)

      Please help me y the above error occurs
      month_year is stored as datetime in sybase database
        • 1. Re: error getting drill down
          Srini VEERAVALLI
          Your logical query is wrong; when you use between operator you need to use AND

          SELECT SUBSTRING(cast(etxnmistopbr.month_year as char) FROM 1 FOR 11) saw_0, etxnmistopbr.tot_txns saw_1, cast(etxnmistopbr.month_year as date) saw_2 FROM "Dly Channel" WHERE cast(etxnmistopbr.month_year as date) between ('2012-03-31','2012-10-31')

          Or else use IN operator instead of Between

          Appreciate if you mark as correct

          Edited by: Srini VEERAVALLI on Dec 29, 2012 10:37 AM