[Koha] more sql silliness

Magnus Enger magnus at enger.priv.no
Fri Nov 6 08:57:07 NZDT 2009


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')<http://images.amazon.com/images/P/%27isbn%27.01.TZZZZZZZ.jpg%27%29>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')<http://images.amazon.com/images/P/%27isbn%27.01.TZZZZZZZ.jpg%27%29>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/4445cd5e/attachment.htm 


More information about the Koha mailing list