Well, first of all I'd suggest installing Velocity, and using that as your test querying interface...
But try ?fq=feature:Cafe -----Original Message----- From: PeterKerk [mailto:vettepa...@hotmail.com] Sent: Tuesday, August 03, 2010 1:38 PM To: solr-user@lucene.apache.org Subject: RE: Indexing data on MSSQL failed: Caused by: org.apache.solr.common.SolrException: Error loading class 'com.micros oft.sqlserver.jdbc.SQLServerDriver' Awesome! You did it! Turned out, I had to change the casing of this line: <entity name="location_feature" query="select featureid from location_features where locationid='${location.ID}'"> to: <entity name="location_feature" query="select featureid from location_features where locationid='${location.id}'"> Now the resultset is like this: <response> − <lst name="responseHeader"> <int name="status">0</int> <int name="QTime">16</int> − <lst name="params"> <str name="indent">on</str> <str name="start">0</str> <str name="q">*:*</str> <str name="version">2.2</str> <str name="rows">10</str> </lst> </lst> − <result name="response" numFound="3" start="0"> − <doc> − <arr name="cat"> <str>Gemeentehuis</str> </arr> − <arr name="features"> <str>Tuin</str> <str>Cafe</str> </arr> <str name="id">1</str> <date name="timestamp">2010-08-03T17:31:21.562Z</date> <str name="title">Gemeentehuis Nijmegen</str> </doc> − <doc> − <arr name="cat"> <str>Gemeentehuis</str> </arr> − <arr name="features"> <str>Tuin</str> <str>Cafe</str> <str>Danszaal</str> </arr> <str name="id">2</str> <date name="timestamp">2010-08-03T17:31:21.593Z</date> <str name="title">Gemeentehuis Utrecht</str> </doc> − <doc> − <arr name="cat"> <str>Strand & Zee</str> </arr> − <arr name="features"> <str>Strand</str> <str>Cafe</str> <str>Danszaal</str> </arr> <str name="id">3</str> <date name="timestamp">2010-08-03T17:31:21.609Z</date> <str name="title">Beachclub Vroeger</str> </doc> </result> </response> And now the FINAL question I have: as you can see above "features" is a facet. What should I type in the solr admin page on http://localhost:8983/solr/db/admin/ to filter all records on the "features" facet? e.g. to show all records that have a feature "Cafe"? Thanks! -- View this message in context: http://lucene.472066.n3.nabble.com/Indexing-data-on-MSSQL-failed-Caused-by-org-apache-solr-common-SolrException-Error-loading-class-com-tp1015137p1020051.html Sent from the Solr - User mailing list archive at Nabble.com.
