[Koha] more sql silliness

Erik Lewis elewis at ngrl.org
Fri Nov 6 08:59:04 NZDT 2009


Actually tried it with the commas, same effect.


On Nov 5, 2009, at 2:57 PM, Magnus Enger wrote:

>
>
> 2009/11/5 Erik Lewis <elewis at ngrl.org>
> Been playing with this for awhile
>
> SELECT CONCAT('http://images.amazon.com/images/P/'isbn'.01.TZZZZZZZ.jpg') 
>  FROM isbn_experiment LIMIT 10;
>
> I think you may need som commas in the parentheses:
>
> SELECT CONCAT('http://images.amazon.com/images/P/', isbn, '. 
> 01.TZZZZZZZ.jpg') FROM isbn_experiment LIMIT 10;
>
> http://dev.mysql.com/doc/refman/5.0/en/string-functions.html#function_concat 
>  ;-)
>
> Regards,
> Magnus Enger
> libriotech.no

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.katipo.co.nz/pipermail/koha/attachments/20091105/9dbed8c7/attachment.htm 


More information about the Koha mailing list