Return-Path: 
 <solr-user-return-34766-apmail-lucene-solr-user-archive=lucene.apache.org@lucene.apache.org>
Delivered-To: apmail-lucene-solr-user-archive@minotaur.apache.org
Received: (qmail 50752 invoked from network); 7 Apr 2010 15:35:49 -0000
Received: from unknown (HELO mail.apache.org) (140.211.11.3)
  by 140.211.11.9 with SMTP; 7 Apr 2010 15:35:49 -0000
Received: (qmail 99327 invoked by uid 500); 7 Apr 2010 15:35:47 -0000
Delivered-To: apmail-lucene-solr-user-archive@lucene.apache.org
Received: (qmail 99294 invoked by uid 500); 7 Apr 2010 15:35:47 -0000
Mailing-List: contact solr-user-help@lucene.apache.org; run by ezmlm
Precedence: bulk
List-Help: <mailto:solr-user-help@lucene.apache.org>
List-Unsubscribe: <mailto:solr-user-unsubscribe@lucene.apache.org>
List-Post: <mailto:solr-user@lucene.apache.org>
List-Id: <solr-user.lucene.apache.org>
Reply-To: solr-user@lucene.apache.org
Delivered-To: mailing list solr-user@lucene.apache.org
Received: (qmail 99286 invoked by uid 99); 7 Apr 2010 15:35:47 -0000
Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230)
    by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 07 Apr 2010 15:35:47 +0000
X-ASF-Spam-Status: No, hits=2.9 required=10.0
	tests=FREEMAIL_ENVFROM_END_DIGIT,FREEMAIL_FROM,SPF_HELO_PASS,SPF_NEUTRAL,T_FRT_INTEREST,T_TO_NO_BRKTS_FREEMAIL
X-Spam-Check-By: apache.org
Received-SPF: neutral (nike.apache.org: local policy)
Received: from [216.139.236.158] (HELO kuber.nabble.com) (216.139.236.158)
    by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 07 Apr 2010 15:35:40 +0000
Received: from ben.nabble.com ([192.168.236.152])
	by kuber.nabble.com with esmtp (Exim 4.63)
	(envelope-from <mitch91@web.de>)
	id 1NzXHk-00047A-4H
	for solr-user@lucene.apache.org; Wed, 07 Apr 2010 08:35:20 -0700
Date: Wed, 7 Apr 2010 07:35:20 -0800 (PST)
From: MitchK <mitch91@web.de>
To: solr-user@lucene.apache.org
Message-ID: <1270654520126-703245.post@n3.nabble.com>
Subject: Short Question: Fills this entity multiValued Fields (DIH)?
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
X-Virus-Checked: Checked by ClamAV on apache.org


Hello all,

I read through the wiki to find a solution on filling multiValued fields
with, you guessed it, multiple values. :)

What I have found was a short excerpt of code and I am not really sure,
whether this fills a multiValued-field with multiple values. 
The code (not everything is relevant, but maybe it is of any interrest):

<document name="products">
        <entity name="item" query="select * from item">
            <field column="ID" name="id" />
            <field column="NAME" name="name" />
            <field column="MANU" name="manu" />
            <field column="WEIGHT" name="weight" />
            <field column="PRICE" name="price" />
            <field column="POPULARITY" name="popularity" />
            <field column="INSTOCK" name="inStock" />
            <field column="INCLUDES" name="includes" />

            <entity name="feature" query="select description from feature
where item_id='${item.ID}'">
                <field name="features" column="description" />
            </entity>
            <entity name="item_category" query="select CATEGORY_ID from
item_category where item_id='${item.ID}'">
                <entity name="category" query="select description from
category where id = '${item_category.CATEGORY_ID}'">
                    <field column="description" name="cat" />
                </entity>
            </entity>
        </entity>
    </document>
----------------------------------------


Have a look at these two lines:
----------------------------------------
<entity name="feature" query="select description from feature where
item_id='${item.ID}'">
                <field name="features" column="description" />
----------------------------------------

If there is more than one description per item_ID, does the features-field
gets multiple values if it is defined as multiValued=true?

If not, how do I create multiValued fields from RDBMS?

Thank you in advance!
- Mitch
-- 
View this message in context: http://n3.nabble.com/Short-Question-Fills-this-entity-multiValued-Fields-DIH-tp703245p703245.html
Sent from the Solr - User mailing list archive at Nabble.com.