On Tue, Jun 9, 2009 at 12:41 AM, gateway0<reiterwo...@yahoo.de> wrote:
>
> 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".
The naming convention does not work like that.
if the entity name is 'tableA' then the field 'id' is addressed as 'tableA.id'
As I said earlier, if you could privide mw with the entire
data-config.xml it would be more helpful
>
> 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.
>
>
--
-----------------------------------------------------
Noble Paul | Principal Engineer| AOL | http://aol.com
