Error Executing Database Query.
|
|
Unknown column 'a_artist.apos' in 'order clause'
|
| |
The error occurred in C:\JRun4\servers\cfusion\cfusion-ear\cfusion-war\WEB-INF\cfusion\CustomTags\common\genQuery.cfm: line 77
Called from C:\www\salsamonaco\2009\artists\mods\artistList.cfm: line 4
Called from C:\www\salsamonaco\2009\artists\index.html: line 18
Called from C:\JRun4\servers\cfusion\cfusion-ear\cfusion-war\WEB-INF\cfusion\CustomTags\common\genQuery.cfm: line 77
Called from C:\www\salsamonaco\2009\artists\mods\artistList.cfm: line 4
Called from C:\www\salsamonaco\2009\artists\index.html: line 18
|
75 : </cfif>
76 : <cfif len(attributes.limit)>
77 : LIMIT #attributes.limit#
78 : </cfif>
79 : </cfquery>
|
|
| SQLSTATE |
42S22 |
| SQL |
SELECT a_artist.id_a_artist AS aid_a_artist,a_artist.name AS aname,a_artist.id_p_photo AS aid_p_photo,a_artist.content_idtg AS acontent_idtg,a_artist.id_c_category_artist AS aid_c_category_artist,a_artist.confirmation AS aconfirmation,a_artist.url AS aurl,a_artist.id_p_pays AS aid_p_pays,a_artist.pos AS apos,a_artist.year AS ayear,a_artist.day AS aday,a_artist.event_day AS aevent_day
FROM a_artist
WHERE 1=1
AND FIND_IN_SET('4',id_c_category_artist) >= 1 AND year = '2009-01-01'
ORDER BY a_artist.apos |
| VENDORERRORCODE |
1054 |
| DATASOURCE |
salsamonaco |
|
|
Resources:
|
| Browser |
CCBot/1.0 (+http://www.commoncrawl.org/bot.html) |
| Remote Address |
38.107.191.94 |
| Referrer |
|
| Date/Time |
30-Jul-10 03:08 PM |
|