Thanks for your answer.
"${db.tableA.id}" that specifies the sql query that the Dataimporthandler
should Use the sql field "id" in table "tableA" located in Database "db".
like in the example from the Solr Wiki:
"
<entity name="item_category" query="select CATEGORY_ID from item_category
where item_id='${item.ID}'">
"
It´s strange I know but when I use something other than "id" as the foreign
key for the query everything works!
like:
"${db.tableA.anotherid}"
Noble Paul നോബിള് नोब्ळ्-2 wrote:
>
> 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
>
>
--
View this message in context:
http://www.nabble.com/Use-the-same-SQL-Field-in-Dataimporthandler-twice--tp23904968p23930286.html
Sent from the Solr - User mailing list archive at Nabble.com.
