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
and name like 'j%'
order by name
|
|
|
Resources:
|
| Browser |
ColdFusion |
| Remote Address |
62.3.57.159 |
| Referrer |
|
| Date/Time |
25-Jan-24 05:15 AM |
|