Our host recently upgraded to MySQL5 and it has messed up the displaying of our database query results in the browser. The pages use .ASP to connect to the DB and then to display the page. I'm not very fluent in .ASP and looking at the code doesn't show me much. Here's a snippet: sSQL = "select t.banner_id, b.company_id, sum(t.clicks) as Clickstotal, sum(t.impressions) as ImpTotal, b.banner_name, c.company from BANNER_TRAFFIC t, BANNERS b, COMPANY c, PW_BANNERS pwb where b.banner_id = t.banner_id and c.company_id = b.company_id and b.banner_id=pwb.banner_id and pwb.PW_ID=" & PW_ID & " group by t.banner_id" set trafficdetails = db.execute(sSQL) <td><%= trafficdetails("banner_name") %></td><td><a href="company.asp?company_id=<%= trafficdetails("company_id") %>"><%= trafficdetails("company") %></a></td><td><%= trafficdetails("Clickstotal") %></td><td><%= trafficdetails("ImpTotal") It only displays ImpTotal and Clickstotal, not banner_name or company. Our host says it is due to the MySQL upgrade. Anyone have any idea of where I should look for a solution to this? I'm not sur ewhat changes in MySQL would have affected it. Thanks for your help!
Try this: sSQL = "select t.banner_id, b.company_id, sum(t.clicks) as Clickstotal, sum(t.impressions) as ImpTotal, b.banner_name as banner_name, c.company as company from BANNER_TRAFFIC t, BANNERS b, COMPANY c, PW_BANNERS pwb where b.banner_id = t.banner_id and c.company_id = b.company_id and b.banner_id=pwb.banner_id and pwb.PW_ID=" & PW_ID & " group by t.banner_id" J
No luck. I thought it would work, but nothing. Displays the page exactly as it did before. If I view source it just shows <td></td> for those areas. I'm at a complete loss as it just doesn't make any sense to me.