[SqlException (0x80131904): Incorrect syntax near 'S'.
Unclosed quotation mark after the character string ' AS Value) Genders ON I.gender = Genders.Value
WHERE
I.gender IS NOT NULL
ORDER BY
Genders.DisplayText
SELECT DISTINCT
I.MaterialTypeFull as DisplayText,
I.MaterialTypeFull as Value
FROM
#FilteredFrames F INNER JOIN dbo.inventory I ON F.sku = I.sku
WHERE
I.MaterialTypeFull IS NOT NULL
ORDER BY
I.MaterialTypeFull
SELECT DISTINCT
I.FrameShape AS DisplayText,
I.FrameShape AS Value
FROM
#FilteredFrames F INNER JOIN dbo.inventory I ON F.sku = I.sku
WHERE
I.FrameShape IS NOT NULL
ORDER BY
I.FrameShape
SELECT DISTINCT
I.ColorGroup AS DisplayText,
I.ColorGroup AS Value
FROM
#FilteredFrames F INNER JOIN dbo.inventory I ON F.sku = I.sku
WHERE
I.ColorGroup IS NOT NULL
ORDER BY
I.ColorGroup
SELECT DISTINCT
C.Collection_Code AS DisplayText,
I.coll_group AS Value
FROM
#FilteredFrames F INNER JOIN dbo.inventory I ON F.sku = I.sku
INNER JOIN dbo.Collection C ON C.coll_group = I.coll_group
WHERE
C.[Enabled] = 1
ORDER BY
C.Collection_Code
SELECT
COALESCE(MIN(EyeMeasurements_Eye), 0)
FROM
#FilteredFrames F INNER JOIN dbo.inventory I ON F.sku = I.sku
WHERE
EyeMeasurements_Eye IS NOT...]
System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) +277
System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) +765
System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) +4616
System.Data.SqlClient.SqlDataReader.TryConsumeMetaData() +88
System.Data.SqlClient.SqlDataReader.get_MetaData() +103
System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted) +621
System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest) +3382
System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) +707
System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) +83
System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) +302
Dapper.SqlMapper.ExecuteReaderWithFlagsFallback(IDbCommand cmd, Boolean wasClosed, CommandBehavior behavior) +63
Dapper.SqlMapper.QueryMultipleImpl(IDbConnection cnn, CommandDefinition& command) +739
Dapper.SqlMapper.QueryMultiple(IDbConnection cnn, String sql, Object param, IDbTransaction transaction, Nullable`1 commandTimeout, Nullable`1 commandType) +123
Kenmark_Consumer.Models.Collections.GetSearchFilterOptions(List`1 brands, List`1 colors, List`1 genders, List`1 materials, List`1 shapes, String collectionName, String collectionAttribute) in C:\BuildAgent\work\80365974eab54db3\Kenmark-Consumer\Models\Collections.cs:637
Kenmark_Consumer.Controllers.CollectionController.ViewCollection(List`1 brands, List`1 colors, List`1 genders, List`1 materials, List`1 shapes, String brandName, String collectionName, String collectionGroup, String collectionAttribute, Int32 eyeSizeMin, Int32 eyeSizeMax, Int32 page, Int32 sort, Filters filter, Boolean isViewAll) in C:\BuildAgent\work\80365974eab54db3\Kenmark-Consumer\Controllers\CollectionController.cs:87
lambda_method(Closure , ControllerBase , Object[] ) +1349
System.Web.Mvc.ControllerActionInvoker.InvokeActionMethod(ControllerContext controllerContext, ActionDescriptor actionDescriptor, IDictionary`2 parameters) +35
System.Web.Mvc.Async.<>c.<BeginInvokeSynchronousActionMethod>b__9_0(IAsyncResult asyncResult, ActionInvocation innerInvokeState) +39
System.Web.Mvc.Async.WrappedAsyncResult`2.CallEndDelegate(IAsyncResult asyncResult) +77
System.Web.Mvc.Async.AsyncControllerActionInvoker.EndInvokeActionMethod(IAsyncResult asyncResult) +42
System.Web.Mvc.Async.<>c__DisplayClass11_0.<InvokeActionMethodFilterAsynchronouslyRecursive>b__0() +80
System.Web.Mvc.Async.<>c__DisplayClass11_2.<InvokeActionMethodFilterAsynchronouslyRecursive>b__2() +396
System.Web.Mvc.Async.AsyncControllerActionInvoker.EndInvokeActionMethodWithFilters(IAsyncResult asyncResult) +42
System.Web.Mvc.Async.<>c__DisplayClass3_6.<BeginInvokeAction>b__4() +42
System.Web.Mvc.Async.<>c__DisplayClass3_1.<BeginInvokeAction>b__1(IAsyncResult asyncResult) +188
System.Web.Mvc.Async.AsyncControllerActionInvoker.EndInvokeAction(IAsyncResult asyncResult) +38
System.Web.Mvc.<>c.<BeginExecuteCore>b__152_1(IAsyncResult asyncResult, ExecuteCoreState innerState) +29
System.Web.Mvc.Async.WrappedAsyncVoid`1.CallEndDelegate(IAsyncResult asyncResult) +73
System.Web.Mvc.Controller.EndExecuteCore(IAsyncResult asyncResult) +52
System.Web.Mvc.Async.WrappedAsyncVoid`1.CallEndDelegate(IAsyncResult asyncResult) +39
System.Web.Mvc.Controller.EndExecute(IAsyncResult asyncResult) +38
System.Web.Mvc.<>c.<BeginProcessRequest>b__20_1(IAsyncResult asyncResult, ProcessRequestState innerState) +43
System.Web.Mvc.Async.WrappedAsyncVoid`1.CallEndDelegate(IAsyncResult asyncResult) +73
System.Web.Mvc.MvcHandler.EndProcessRequest(IAsyncResult asyncResult) +38
System.Web.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() +651
System.Web.HttpApplication.ExecuteStepImpl(IExecutionStep step) +220
System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +134
|