Lookout Mountain Club Logo
Lookout Mountain Club Logo

LMC Shop

Product Catalog

Cabernet Sauvignon Chardonnay Italian
Merlot Pinot Grigio/Gris Pinot Noir
Red Blend Red Zinfandel Riesling
Rose Sauvignon Blanc Sparking Wine/Champagne
White Blend

Keyword Search:

Hahn Estates SLH Pinot Noir
$23.00

Fresh-crushed savory herbal notes flank the ripe dark fruit and spice flavors, which turn a touch cloying on the finish.

About the Producer:

It was our founder Nicky Hahn who suggested that the Santa Lucia Highlands be deemed a unique winegrowing district. In 1991, three years after he and fellow vintners made their appeal, the federal government approved the Highlands as an official American Viticultural Area (AVA).
Today, we produce our Hahn SLH Pinot Noir and Chardonnay entirely from our estate, in this breathtakingly beautiful region of Monterey County. The fruit grows in our family-owned vineyards and the wine is barrel-aged in the winery’s cellar.

When it’s time to blend the wine and get it in the bottle, our winemaker Paul Clifton chooses the barrels that he feels epitomize the aromas, flavors and structure of Pinot Noir from the Santa Lucia Highland. We deem only a very limited number of barrels worthy to carry the SLH label.

Error Occurred While Processing Request The web site you are accessing has experienced an unexpected error.
Please contact the website administrator.


The following information is meant for the website developer for debugging purposes.
Error Occurred While Processing Request

Error Executing Database Query.

[Macromedia][SQLServer JDBC Driver][SQLServer]Invalid column name 'ColNum'.
 
The error occurred in C:/Web/MasterFiles_v6_sql_dev/spectypes/include_shop_product.cfm: line 265
Called from C:/Web/MasterFiles_v6_sql_dev/spectypes/shop_cart.cfm: line 236
Called from C:/Web/MasterFiles_v6_sql_dev/spectypes/shop_cart.cfm: line 228
Called from C:/Web/MasterFiles_v6_sql_dev/spectypes/shop_cart.cfm: line 1
Called from C:/Web/MasterFiles_v6_sql_dev/include_page_components.cfm: line 103
Called from C:/Web/MasterFiles_v6_sql_dev/master.cfm: line 262
Called from C:/Web/MasterFiles_v6_sql_dev/master.cfm: line 226
Called from C:/Web/MasterFiles_v6_sql_dev/master.cfm: line 222
Called from c:/web/fairyland/index.cfm: line 1
Called from C:/Web/MasterFiles_v6_sql_dev/spectypes/include_shop_product.cfm: line 265
Called from C:/Web/MasterFiles_v6_sql_dev/spectypes/shop_cart.cfm: line 236
Called from C:/Web/MasterFiles_v6_sql_dev/spectypes/shop_cart.cfm: line 228
Called from C:/Web/MasterFiles_v6_sql_dev/spectypes/shop_cart.cfm: line 1
Called from C:/Web/MasterFiles_v6_sql_dev/include_page_components.cfm: line 103
Called from C:/Web/MasterFiles_v6_sql_dev/master.cfm: line 262
Called from C:/Web/MasterFiles_v6_sql_dev/master.cfm: line 226
Called from C:/Web/MasterFiles_v6_sql_dev/master.cfm: line 222
Called from c:/web/fairyland/index.cfm: line 1
263 : 		SELECT     P.IDp, P.PName, P.PPrice1
264 : 		FROM         ShopProducts AS P RIGHT OUTER JOIN ShopCatProdMap AS Pm ON P.IDp = Pm.ProdNum
265 : 		WHERE     (Pm.ColNum = <cfqueryparam value="#PC#" cfsqltype="CF_SQL_INTEGER">) AND (P.PShow = 'Yes' OR P.PShow IS NULL)
266 : 		ORDER BY P.PName, P.PNumber
267 : 		</cfquery>

SQLSTATE   42S22
EXCEPTIONS   <small><i>not set</i></small>
DATASOURCE   fairylandsite
VENDORERRORCODE   207
SQL   SELECT P.IDp, P.PName, P.PPrice1 FROM ShopProducts AS P RIGHT OUTER JOIN ShopCatProdMap AS Pm ON P.IDp = Pm.ProdNum WHERE (Pm.ColNum = (param 1) ) AND (P.PShow = 'Yes' OR P.PShow IS NULL) ORDER BY P.PName, P.PNumber
Resources:

Browser   CCBot/2.0 (https://commoncrawl.org/faq/)
Remote Address   52.23.219.12
Referrer  
Date/Time   30-Nov-21 07:42 PM
Stack Trace
at cfinclude_shop_product2ecfm2035641145.runPage(C:/Web/MasterFiles_v6_sql_dev/spectypes/include_shop_product.cfm:265) at cfshop_cart2ecfm1727948438._factor0(C:/Web/MasterFiles_v6_sql_dev/spectypes/shop_cart.cfm:236) at cfshop_cart2ecfm1727948438._factor11(C:/Web/MasterFiles_v6_sql_dev/spectypes/shop_cart.cfm:228) at cfshop_cart2ecfm1727948438.runPage(C:/Web/MasterFiles_v6_sql_dev/spectypes/shop_cart.cfm:1) at cfinclude_page_components2ecfm95375941.runPage(C:/Web/MasterFiles_v6_sql_dev/include_page_components.cfm:103) at cfmaster2ecfm1338536015._factor8(C:/Web/MasterFiles_v6_sql_dev/master.cfm:262) at cfmaster2ecfm1338536015._factor9(C:/Web/MasterFiles_v6_sql_dev/master.cfm:226) at cfmaster2ecfm1338536015.runPage(C:/Web/MasterFiles_v6_sql_dev/master.cfm:222) at cfindex2ecfm78947604.runPage(c:/web/fairyland/index.cfm:1) at cfinclude_shop_product2ecfm2035641145.runPage(C:/Web/MasterFiles_v6_sql_dev/spectypes/include_shop_product.cfm:265) at cfshop_cart2ecfm1727948438._factor0(C:/Web/MasterFiles_v6_sql_dev/spectypes/shop_cart.cfm:236) at cfshop_cart2ecfm1727948438._factor11(C:/Web/MasterFiles_v6_sql_dev/spectypes/shop_cart.cfm:228) at cfshop_cart2ecfm1727948438.runPage(C:/Web/MasterFiles_v6_sql_dev/spectypes/shop_cart.cfm:1) at cfinclude_page_components2ecfm95375941.runPage(C:/Web/MasterFiles_v6_sql_dev/include_page_components.cfm:103) at cfmaster2ecfm1338536015._factor8(C:/Web/MasterFiles_v6_sql_dev/master.cfm:262) at cfmaster2ecfm1338536015._factor9(C:/Web/MasterFiles_v6_sql_dev/master.cfm:226) at cfmaster2ecfm1338536015.runPage(C:/Web/MasterFiles_v6_sql_dev/master.cfm:222) at cfindex2ecfm78947604.runPage(c:/web/fairyland/index.cfm:1)

java.sql.SQLSyntaxErrorException: [Macromedia][SQLServer JDBC Driver][SQLServer]Invalid column name 'ColNum'.
	at macromedia.jdbc.sqlserverbase.BaseExceptions.b(BaseExceptions.java:1085)
	at macromedia.jdbc.sqlserverbase.BaseExceptions.a(BaseExceptions.java:977)
	at macromedia.jdbc.sqlserverbase.BaseExceptions.a(BaseExceptions.java:1124)
	at macromedia.jdbc.sqlserverbase.BaseExceptions.a(BaseExceptions.java:193)
	at macromedia.jdbc.sqlserver.tds.s.ct(TDSRequest.java:1153)
	at macromedia.jdbc.sqlserver.tds.s.a(TDSRequest.java:4124)
	at macromedia.jdbc.sqlserver.tds.r.a(TDSRPCRequest.java:1063)
	at macromedia.jdbc.sqlserver.tds.s.c(TDSRequest.java:4273)
	at macromedia.jdbc.sqlserver.bi.getNextResultType(SQLServerImplStatement.java:1895)
	at macromedia.jdbc.sqlserverbase.go.bY(BaseStatement.java:632)
	at macromedia.jdbc.sqlserverbase.go.B(BaseStatement.java:2661)
	at macromedia.jdbc.sqlserverbase.fe.B(BasePreparedStatement.java:530)
	at macromedia.jdbc.sqlserverbase.go.kx(BaseStatement.java:2470)
	at macromedia.jdbc.sqlserverbase.go.kq(BaseStatement.java:1322)
	at macromedia.jdbc.sqlserverbase.fe.$fr$execute(BasePreparedStatement.java:2656)
	at macromedia.jdbc.sqlserverbase.fe.execute(BasePreparedStatement.java)
	at macromedia.jdbc.sqlserverbase.fg.$fr$execute(BasePreparedStatementPoolable.java:525)
	at macromedia.jdbc.sqlserverbase.fg.execute(BasePreparedStatementPoolable.java)
	at coldfusion.server.j2ee.sql.JRunPreparedStatement.execute(JRunPreparedStatement.java:101)
	at coldfusion.sql.Executive.executeQuery(Executive.java:1601)
	at coldfusion.sql.Executive.executeQuery(Executive.java:1327)
	at coldfusion.sql.Executive.executeQuery(Executive.java:1257)
	at coldfusion.sql.SqlImpl.execute(SqlImpl.java:425)
	at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:1247)
	at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:876)
	at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:821)
	at cfinclude_shop_product2ecfm2035641145.runPage(C:\Web\MasterFiles_v6_sql_dev\spectypes\include_shop_product.cfm:265)
	at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:257)
	at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:749)
	at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:578)
	at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:5195)
	at cfshop_cart2ecfm1727948438._factor0(C:\Web\MasterFiles_v6_sql_dev\spectypes\shop_cart.cfm:236)
	at cfshop_cart2ecfm1727948438._factor11(C:\Web\MasterFiles_v6_sql_dev\spectypes\shop_cart.cfm:228)
	at cfshop_cart2ecfm1727948438.runPage(C:\Web\MasterFiles_v6_sql_dev\spectypes\shop_cart.cfm:1)
	at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:257)
	at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:749)
	at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:578)
	at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:5195)
	at cfinclude_page_components2ecfm95375941.runPage(C:\Web\MasterFiles_v6_sql_dev\include_page_components.cfm:103)
	at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:257)
	at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:749)
	at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:578)
	at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:5195)
	at cfmaster2ecfm1338536015._factor8(C:\Web\MasterFiles_v6_sql_dev\master.cfm:262)
	at cfmaster2ecfm1338536015._factor9(C:\Web\MasterFiles_v6_sql_dev\master.cfm:226)
	at cfmaster2ecfm1338536015.runPage(C:\Web\MasterFiles_v6_sql_dev\master.cfm:222)
	at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:257)
	at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:749)
	at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:578)
	at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:5195)
	at cfindex2ecfm78947604.runPage(c:\web\fairyland\index.cfm:1)
	at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:257)
	at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:749)
	at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:578)
	at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65)
	at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:612)
	at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:43)
	at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40)
	at coldfusion.filter.PathFilter.invoke(PathFilter.java:162)
	at coldfusion.filter.IpFilter.invoke(IpFilter.java:45)
	at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:97)
	at coldfusion.filter.BrowserDebugFilter.invoke(BrowserDebugFilter.java:81)
	at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28)
	at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38)
	at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:60)
	at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38)
	at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22)
	at coldfusion.filter.CachingFilter.invoke(CachingFilter.java:62)
	at coldfusion.CfmServlet.service(CfmServlet.java:231)
	at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:311)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
	at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:46)
	at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:47)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
	at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
	at jdk.internal.reflect.GeneratedMethodAccessor113.invoke(Unknown Source)
	at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.base/java.lang.reflect.Method.invoke(Method.java:566)
	at com.intergral.fusionreactor.j2ee.filterchain.WrappedFilterChain.doFilter(WrappedFilterChain.java:134)
	at com.intergral.fusionreactor.j2ee.filter.FusionReactorRequestHandler.doNext(FusionReactorRequestHandler.java:772)
	at com.intergral.fusionreactor.j2ee.filter.FusionReactorRequestHandler.doHttpServletRequest(FusionReactorRequestHandler.java:344)
	at com.intergral.fusionreactor.j2ee.filter.FusionReactorRequestHandler.doFusionRequest(FusionReactorRequestHandler.java:207)
	at com.intergral.fusionreactor.j2ee.filter.FusionReactorRequestHandler.handle(FusionReactorRequestHandler.java:809)
	at com.intergral.fusionreactor.j2ee.filter.FusionReactorCoreFilter.doFilter(FusionReactorCoreFilter.java:36)
	at jdk.internal.reflect.GeneratedMethodAccessor92.invoke(Unknown Source)
	at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.base/java.lang.reflect.Method.invoke(Method.java:566)
	at com.intergral.fusionreactor.j2ee.filterchain.WrappedFilterChain.doFilter(WrappedFilterChain.java:71)
	at jdk.internal.reflect.GeneratedMethodAccessor80.invoke(Unknown Source)
	at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.base/java.lang.reflect.Method.invoke(Method.java:566)
	at com.intergral.fusionreactor.agent.filter.FusionReactorStaticFilter.doFilter(FusionReactorStaticFilter.java:54)
	at com.intergral.fusionreactor.agent.pointcuts.NewFilterChainPointCut$1.invoke(NewFilterChainPointCut.java:42)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:202)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:97)
	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:542)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:143)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:78)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:359)
	at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:459)
	at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65)
	at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:888)
	at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1597)
	at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
	at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128)
	at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628)
	at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
	at java.base/java.lang.Thread.run(Thread.java:834)