Re: [Koha] more sql silliness

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@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