Hi my site has been running great for 2 years and now my host has upgraded something lots of my pages are no longer working. i dont know what they did and they are not helping me fix it??one example when i asked them to help was the got me to change my string which got the page working, but why did i need to do this please. trying to understand and solve all the other errors it has caused on my site.strSQL = "SELECT `Artist`, LCASE(ROUND((SUM(`Testimonials`.`Rating`) / (COUNT(`Testimonials`.`Rating`)*5) * 100), 0)) AS Rating FROM `Testimonials` GROUP BY `Artist`"To this:strSQL = "SELECT `Artist`, cast(LCASE(ROUND((SUM(`Testimonials`.`Rating`) / (COUNT(`Testimonials`.`Rating`)*5) * 100), 0)) as char) AS Rating FROM `Testimonials` GROUP BY `Artist`"
Urgent issue with coding after server upgrade
Posted - 2014-02-06 : 23:57:33
