lucene-solr-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Noble Paul നോബിള്‍ नोब्ळ् <noble.p...@corp.aol.com>
Subject Re: Use the same SQL Field in Dataimporthandler twice?
Date Mon, 08 Jun 2009 03:53:37 GMT
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<reiterworld@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

Mime
View raw message