| struct |
|---|
| DataSource |
gaisyoku |
| Detail |
[Macromedia][SQLServer JDBC Driver][SQLServer]サブクエリは複数の値を返しました。サブクエリが = 、!= 、<、<= 、>、>= のあとに続く場合や、サブクエリが 1 つの式として使われる場合に複数の値は許可されません。 |
| ErrorCode |
21000 |
| Message |
データベースクエリーを実行する際のエラーです。 |
| NativeErrorCode |
512 |
| RootCause |
| struct |
|---|
| ErrorCode |
512 |
| Message |
[Macromedia][SQLServer JDBC Driver][SQLServer]サブクエリは複数の値を返しました。サブクエリが = 、!= 、<、<= 、>、>= のあとに続く場合や、サブクエリが 1 つの式として使われる場合に複数の値は許可されません。 |
| SQLState |
21000 |
| StackTrace |
java.sql.SQLException: [Macromedia][SQLServer JDBC Driver][SQLServer]サブクエリは複数の値を返しました。サブクエリが = 、!= 、<、<= 、>、>= のあとに続く場合や、サブクエリが 1 つの式として使われる場合に複数の値は許可されません。
at macromedia.jdbc.base.BaseExceptions.createException(Unknown Source)
at macromedia.jdbc.base.BaseExceptions.getException(Unknown Source)
at macromedia.jdbc.sqlserver.tds.TDSRequest.processErrorToken(Unknown Source)
at macromedia.jdbc.sqlserver.tds.TDSRequest.processReplyToken(Unknown Source)
at macromedia.jdbc.sqlserver.tds.TDSRequest.processReply(Unknown Source)
at macromedia.jdbc.sqlserver.tds.TDSRequest.getRow(Unknown Source)
at macromedia.jdbc.sqlserver.SQLServerImplResultSet.fetchAtPosition(Unknown Source)
at macromedia.jdbc.base.BaseImplResultSet.next(Unknown Source)
at macromedia.jdbc.base.BaseResultSet.next(Unknown Source)
at coldfusion.sql.QueryTable.populate(QueryTable.java:287)
at coldfusion.sql.QueryTable.populate(QueryTable.java:216)
at coldfusion.sql.Executive.getRowSet(Executive.java:310)
at coldfusion.sql.Executive.executeQuery(Executive.java:719)
at coldfusion.sql.Executive.executeQuery(Executive.java:652)
at coldfusion.sql.Executive.executeQuery(Executive.java:613)
at coldfusion.sql.SqlImpl.execute(SqlImpl.java:236)
at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:499)
at cfblog_list2ecfm837267351.runPage(E:\USER\gaisyoku\root\www\htdocs\pages\blog\blog_list.cfm:46)
at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:152)
at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:349)
at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65)
at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:210)
at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:51)
at coldfusion.filter.PathFilter.invoke(PathFilter.java:86)
at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:69)
at coldfusion.filter.BrowserDebugFilter.invoke(BrowserDebugFilter.java:52)
at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28)
at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38)
at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38)
at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22)
at coldfusion.filter.RequestThrottleFilter.invoke(RequestThrottleFilter.java:115)
at coldfusion.CfmServlet.service(CfmServlet.java:107)
at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:78)
at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:91)
at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42)
at jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:257)
at jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:541)
at jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.java:204)
at jrunx.scheduler.ThreadPool$DownstreamMetrics.invokeRunnable(ThreadPool.java:318)
at jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:426)
at jrunx.scheduler.ThreadPool$UpstreamMetrics.invokeRunnable(ThreadPool.java:264)
at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66)
|
| TagContext |
| array
|
|---|
| 1 |
| struct |
|---|
| COLUMN |
0 |
| ID |
CFQUERY |
| LINE |
46 |
| RAW_TRACE |
at cfblog_list2ecfm837267351.runPage(E:\USER\gaisyoku\root\www\htdocs\pages\blog\blog_list.cfm:46) |
| TEMPLATE |
E:\USER\gaisyoku\root\www\htdocs\pages\blog\blog_list.cfm |
| TYPE |
CFML |
|
|
| Type |
java.sql.SQLException |
|
| SQLState |
21000 |
| Sql |
SELECT *,
(
SELECT BLC_TIT_T
FROM BLC
WHERE
BLC_ID = (SELECT BLG_UID FROM BLG WHERE BLG_ID = BLR.BLG_ID)
) AS BLC_TIT_T,
(
SELECT BLC_ID
FROM BLC
WHERE
BLC_ID = (SELECT BLG_UID FROM BLG WHERE BLG_ID = BLR.BLG_ID)
) AS BLC_ID
FROM BLR
WHERE
BLR_DEL = 0 AND
BLG_ID IN
(SELECT BLG_ID FROM BLG WHERE BLG_UID IN
(SELECT BLC_ID FROM BLC WHERE BLC_DEL = 0))
AND BLG_ID !=
(SELECT BLG_ID FROM BLG WHERE BLG_UID = 30)
ORDER BY BLR_DATE DESC, BLR_ID DESC;
|
| StackTrace |
coldfusion.tagext.sql.QueryTag$DatabaseQueryException: データベースクエリーを実行する際のエラーです。
at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:579)
at cfblog_list2ecfm837267351.runPage(E:\USER\gaisyoku\root\www\htdocs\pages\blog\blog_list.cfm:46)
at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:152)
at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:349)
at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65)
at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:210)
at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:51)
at coldfusion.filter.PathFilter.invoke(PathFilter.java:86)
at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:69)
at coldfusion.filter.BrowserDebugFilter.invoke(BrowserDebugFilter.java:52)
at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28)
at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38)
at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38)
at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22)
at coldfusion.filter.RequestThrottleFilter.invoke(RequestThrottleFilter.java:115)
at coldfusion.CfmServlet.service(CfmServlet.java:107)
at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:78)
at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:91)
at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42)
at jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:257)
at jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:541)
at jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.java:204)
at jrunx.scheduler.ThreadPool$DownstreamMetrics.invokeRunnable(ThreadPool.java:318)
at jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:426)
at jrunx.scheduler.ThreadPool$UpstreamMetrics.invokeRunnable(ThreadPool.java:264)
at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66)
|
| TagContext |
| array
|
|---|
| 1 |
| struct |
|---|
| COLUMN |
0 |
| ID |
CFQUERY |
| LINE |
46 |
| RAW_TRACE |
at cfblog_list2ecfm837267351.runPage(E:\USER\gaisyoku\root\www\htdocs\pages\blog\blog_list.cfm:46) |
| TEMPLATE |
E:\USER\gaisyoku\root\www\htdocs\pages\blog\blog_list.cfm |
| TYPE |
CFML |
|
|
| Type |
Database |
| queryError |
[Macromedia][SQLServer JDBC Driver][SQLServer]サブクエリは複数の値を返しました。サブクエリが = 、!= 、<、<= 、>、>= のあとに続く場合や、サブクエリが 1 つの式として使われる場合に複数の値は許可されません。 |
| where |
[empty string] |