Error Executing Database Query.
|
|
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'and ratetype = 'E'' at line 4
|
| |
The error occurred in D:\websites\new2.wagerweb.com\includes\rate_this_article.cfm: line 30
Called from D:\websites\new2.wagerweb.com\sportsbook\expert-columns.cfm: line 380
Called from D:\websites\new2.wagerweb.com\sportsbook\expert-columns.cfm: line 1
Called from D:\websites\new2.wagerweb.com\includes\rate_this_article.cfm: line 30
Called from D:\websites\new2.wagerweb.com\sportsbook\expert-columns.cfm: line 380
Called from D:\websites\new2.wagerweb.com\sportsbook\expert-columns.cfm: line 1
|
28 : select avg(ratevalue) as rateval
29 : from articles_rating
30 : where ratearticleid = #artid#
31 : and ratetype = 'E'
32 : </cfquery>
|
|
| SQLSTATE |
42000 |
| SQL |
select avg(ratevalue) as rateval
from articles_rating
where ratearticleid =
and ratetype = 'E'
|
| VENDORERRORCODE |
1064 |
| DATASOURCE |
sitesmanager2 |
|
|
Resources:
|
| Browser |
CCBot/1.0 (+http://www.commoncrawl.org/bot.html) |
| Remote Address |
38.103.63.17 |
| Referrer |
|
| Date/Time |
09-May-08 11:57 AM |
|