try
deltaImportQuery="select [bunch of stuff]
WHERE m.moment_id = '${dataimporter.delta.moment_id}'"
The key has to be same and in the same case
On Tue, Feb 2, 2010 at 1:45 AM, Jon Drukman <jdruk...@gmail.com> wrote:
> First, let me just say that DataImportHandler is fantastic. It got my old
> mysql-php-xml index rebuild process down from 30 hours to 6 minutes.
>
> I'm trying to use the delta-import functionality now but failing miserably.
>
> Here's my entity tag: (some SELECT statements reduced to increase
> readability)
>
> <entity name="moment"
> query="select ..."
>
> deltaQuery="select moment_id from moments where date_modified >
> '${dataimporter.last_index_time}'"
>
> deltaImportQuery="select [bunch of stuff]
> WHERE m.moment_id = '${dataimporter.delta.MOMENTID}'"
>
> pk="MOMENTID"
>
> transformer="TemplateTransformer">
>
> When I look at the MySQL query log I see the date modified query running
> fine and returning 3 rows. The deltaImportQuery, however, does not have the
> proper primary key in the where clause. It's just blank. I also tried
> changing it to ${moment.MOMENTID}.
>
> I don't really get the relation between the pk field and the
> ${dataimport.delta.whatever} stuff.
>
> Help please!
> -jsd-
>
>
>
--
-----------------------------------------------------
Noble Paul | Systems Architect| AOL | http://aol.com
