Error Executing Database Query.
|
Invalid object name 'zhippo.zhippo.supertype'.
|
|
The error occurred in C:/home/Root/tattoonow.com/scripts/site_artistlist.cfm: line 36
Called from C:/home/Root/tattoonow.com/scripts/site_artistlist.cfm: line 4
Called from C:/home/Root/tattoonow.com/scripts/site_artistlist.cfm: line 1
Called from C:/home/Root/cfscriptssql/center.cfm: line 1236
Called from C:/home/Root/cfscriptssql/center.cfm: line 1230
Called from C:/home/Root/cfscriptssql/center.cfm: line 1
Called from C:/home/Root/tattoonow.com/facemaster.cfm: line 256
Called from C:/home/Root/tattoonow.com/scripts/site_artistlist.cfm: line 36
Called from C:/home/Root/tattoonow.com/scripts/site_artistlist.cfm: line 4
Called from C:/home/Root/tattoonow.com/scripts/site_artistlist.cfm: line 1
Called from C:/home/Root/cfscriptssql/center.cfm: line 1236
Called from C:/home/Root/cfscriptssql/center.cfm: line 1230
Called from C:/home/Root/cfscriptssql/center.cfm: line 1
Called from C:/home/Root/tattoonow.com/facemaster.cfm: line 256
|
34 : inner join zhippo.zhippo.artistjobs on artistjobs.supertypeindex = artist.supertypeindex and artistjobs.job=1
35 : where artist.status = 1<cfif #URL.searchword# neq "">
36 : and name like <cfif isdefined("url.searchletter")>'#TRIM(url.searchword)#%'<cfelse>'%#TRIM(url.searchword)#%'</cfif>
37 : </cfif>
38 : order by name
|
|
SQLSTATE |
S0002 |
DATASOURCE |
zhippo |
VENDORERRORCODE |
208 |
SQL |
select artist.name, artist.owner, artist.supertypeindex from zhippo.zhippo.supertype artist
inner join zhippo.zhippo.SupertypeSupertype on SupertypeSupertype.member = artist.supertypeindex and supertypesupertype.owner=3075
inner join zhippo.zhippo.artistjobs on artistjobs.supertypeindex = artist.supertypeindex and artistjobs.job=1
where artist.status = 1
order by name
|
|
Resources:
|
Browser |
ColdFusion |
Remote Address |
62.3.57.159 |
Referrer |
|
Date/Time |
25-Jan-24 05:16 AM |
|