Hi Elaine, I think you have a syntax error in your query. I'd recommend you
to first try the query using a SQL client, until you get it right.
This part seems strange to me:
and pl.deleted='' having count(*)=0
*Juan*
On Wed, Jul 13, 2011 at 5:09 PM, Elaine Li wrote:
> Hi Folks,
>
> I am try
I tried putting single quote like following, it does not work.
deletedPkQuery="select p.pId as id from products p join products_large
pl on p.pId=pl.pId where p.pId= '${dataimporter.delta.id}' and
pl.deleted='' having count(*)=0"
I don't have quotes in where p.pId =${dataimporter.delta.id} for my
On Thu, Jul 14, 2011 at 1:39 AM, Elaine Li wrote:
> Hi Folks,
>
> I am trying to use the deletedPkQuery to enable deltaImport to remove
> the inactive products from solr.
> I am keeping getting the syntax error saying the query syntax is not
> right. I have tried many alternatives to the followin
