RE: DataImportHandler can't understand query

2010-02-08 Thread Shah, Nirmal
Did you try < > Nirmal Shah Remedy Consultant|Column Technologies|Cell: (630) 244-1648 -Original Message- From: javaxmlsoapdev [mailto:vika...@yahoo.com] Sent: Monday, February 08, 2010 5:42 PM To: solr-user@lucene.apache.org Subject: Re: DataImportHandler can't understand q

Re: DataImportHandler can't understand query

2010-02-08 Thread javaxmlsoapdev
Note I already tried to escape < character with \< but still it throws same error. Any idea? Thanks, javaxmlsoapdev wrote: > > I have a complex query (runs fine in database), which I am trying to > include in DataImportHandler query. Query has case statements with < > in > it > > e.g. >

DataImportHandler can't understand query

2010-02-08 Thread javaxmlsoapdev
I have a complex query (runs fine in database), which I am trying to include in DataImportHandler query. Query has case statements with < > in it e.g. case when (ASSIGNED_TO < > '' and TRANSLATE(ASSIGNED_TO, '', '0123456789')='') DataImportHandler failes to understand query with follow