I'd go with moving this logic to the DB in a stored procedure... Ephraim Ofir | Reporting and Host Development team | ICQ P: +972 3 7665510 | M: + 972 52 4888510 | F: +972 3 7665566 | ICQ#: 18981 | E: ephra...@icq.com
-----Original Message----- From: David Yang [mailto:dy...@nextjump.com] Sent: Thursday, September 16, 2010 9:07 PM To: solr-user@lucene.apache.org Subject: DataImportHandler with multiline SQL Hi I am using the DIH to retrieve data, and as part of the process, I wanted to create a temporary table and then import data from that. I have played around a little with DIH and it seems like for a query like: "select x; select y;" you can have select y to return no results and do random stuff, but the first select x needs to return results. Does anybody know exactly how DIH handles multiple sql statements in the query? Cheers, David
