5 Nov
2009
5 Nov
'09
8:56 p.m.
Erik Lewis wrote:
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.
You need some commas I think. CONCAT('string one','string two','string three') -- Greg Barniskis, Computer Systems Integrator South Central Library System (SCLS) Library Interchange Network (LINK) <gregb at scls.lib.wi.us>, (608) 266-6348