Error Executing Database Query.
|
|
[Macromedia][SQLServer JDBC Driver][SQLServer]Incorrect syntax near ')'.
|
| |
The error occurred in C:\inetpub\wwwroot\clients\zhippo\TattooConventionsNOWHOSTED\scripts\site_artistlist.cfm: line 14
Called from C:\inetpub\wwwroot\clients\zhippo\cfscriptssql\center.cfm: line 256
Called from C:\inetpub\wwwroot\clients\zhippo\cfscriptssql\center.cfm: line 240
Called from C:\inetpub\wwwroot\clients\zhippo\cfscriptssql\center.cfm: line 1
Called from C:\inetpub\wwwroot\clients\zhippo\TattooConventionsNOWHOSTED\facemaster.cfm: line 165
Called from C:\inetpub\wwwroot\clients\zhippo\TattooConventionsNOWHOSTED\scripts\site_artistlist.cfm: line 14
Called from C:\inetpub\wwwroot\clients\zhippo\cfscriptssql\center.cfm: line 256
Called from C:\inetpub\wwwroot\clients\zhippo\cfscriptssql\center.cfm: line 240
Called from C:\inetpub\wwwroot\clients\zhippo\cfscriptssql\center.cfm: line 1
Called from C:\inetpub\wwwroot\clients\zhippo\TattooConventionsNOWHOSTED\facemaster.cfm: line 165
|
12 : select name, supertypeindex, email
13 : from supertype
14 : where supertypeindex in (#thislist#)
15 : and supertypeindex in (select supertypeindex from artistjobs where job = 1)
16 : and status = 1
|
|
| VENDORERRORCODE |
102 |
| SQLSTATE |
HY000 |
| SQL |
select name, supertypeindex, email
from supertype
where supertypeindex in ()
and supertypeindex in (select supertypeindex from artistjobs where job = 1)
and status = 1
order by name
|
| DATASOURCE |
zhippo |
|
|
Resources:
|
| Browser |
ColdFusion |
| Remote Address |
10.10.104.32 |
| Referrer |
|
| Date/Time |
15-Dec-11 11:15 AM |
|