[Koha] more sql silliness

Erik Lewis elewis at ngrl.org
Fri Nov 6 08:37:00 NZDT 2009


Been playing with this for awhile

SELECT CONCAT('http://images.amazon.com/images/P/'isbn'.01.TZZZZZZZ.jpg') 
  FROM isbn_experiment LIMIT 10;

Seems straightforward prepend and append the amazon url's for cover  
art to an isbn.  Yet I only get the first part not isbn nor the end.   
Done several permutations but I ain't getting anywhere.


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


More information about the Koha mailing list