I am doing a site, orginally on Win2k, SQl Server. The client is hosting on Linux,
MySql. Ok I converted the data for the database and that appears to be fine however I
have a javascript that runs a scroller along the bottom of the web page it self,
supposed to have an LED effect. On Windows this works fine on this othe box it does
not. Thcoller is images of company names. There are several standardard greeting
images at the begining and they show fine, but I have to dynamically grab the image
maes from the database to show which ones I want to show given a particular page. Well
the images appear as dead images, ya know with the little red x. The images are there
so when I right click the image to see the image name to check, instead of a name I
see 0.0. Heres is the link to the site (www.autocomm-inc.com/dev/index.cfm) and I
will post the code below
but it just dawned on me how does MySql handle concatenation
here is my sql script
SELECT 'images/signboard/'+''+timage as thesign
FROM testimonials
WHERE trank =1
AND displayscroller = 'yes';
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF
community.
http://www.houseoffusion.com/banners/view.cfm?bannerid=35
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:182314
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
