what is ${db.tableA.id} ?
I think there is something extra in that
can you paste the whole data-config.xml?
can you paste
On Sun, Jun 7, 2009 at 1:09 AM, gateway0<reiterwo...@yahoo.de> wrote:
>
> Hi,
>
> I tried to do the following:
>
> "
> <field column="id" name="db_id"/>
>
> <entity name="comment" dataSource="db" query="select com_text from comment
> where ftype=1 and fid='${db.tableA.id}' ">
> <field column="com_text" name="comment"/>
> </entity>
> "
>
> So I use the SQL Table Field "id" twice once for "db_id" in my index and for
> the sql query as "fid=id".
>
> That doesn´t work!
>
> But when I change the query from "fid=id" to like "fid=otherkey" it does
> work!
> Like:
> "
> <field column="id" name="db_id"/>
>
> <entity name="comment" dataSource="db" query="select com_text from comment
> where ftype=1 and fid='${db.tableA.otherkey}' ">
> <field column="com_text" name="comment"/>
> </entity>
> "
>
> Is there any other kind of a workaround so I can use the SQL Field "id"
> twice as I wanted to? Thanks
>
> kind regards, Sebastian
> --
> View this message in context:
> http://www.nabble.com/Use-the-same-SQL-Field-in-Dataimporthandler-twice--tp23904968p23904968.html
> Sent from the Solr - User mailing list archive at Nabble.com.
>
>
--
-----------------------------------------------------
Noble Paul | Principal Engineer| AOL | http://aol.com
