In general it is easier to use the DIH with a database view, rather
than embedding the query in the DIH configuration file.
On Sat, Oct 3, 2009 at 2:08 AM, Ade B wrote:
>
> Perfect, thank you.
>
> Ade
>
>
>
> --
> View this message in context:
> http://www.nabble.com/Garbled-data-in-response---r
Perfect, thank you.
Ade
--
View this message in context:
http://www.nabble.com/Garbled-data-in-response---reading-from-mySQL-database-tp25726655p25726976.html
Sent from the Solr - User mailing list archive at Nabble.com.
Change concat(i.name,'|',ih.name,'|',i.id) to *cast(*concat(i.name,'|',
ih.name,'|',i.id)* as char)*
Cheers
Avlesh
On Sat, Oct 3, 2009 at 1:51 PM, Ade B wrote:
>
> Hi
>
> I am using the DIH to import data from a mySQL database. Everything was
> fine
> in that I could index the data, and search t