• Login (enter your user name) and Password
    Please Login. You are NOT Logged in.

    Quick Search:

  • To see new sales and other StampAuctionNetwork® news in your Facebook newsfeed then Like us on Facebook!

Login to Use StampAuctionNetwork®.
New Member? Click "Register".

StampAuctionNetwork® Extended Features

Back to Auckland City Stamps Sale: 245
WORLD STAMPS & COVERS
   AUSTRALIA (49) Lots 100-99
   AUSTRALIAN ANTARCTIC TERRITORY (1) Lots 111-111
   AUSTRIA (4) Lots 114-117
   BAHRAIN (1) Lots 119-119
   BARBADOS (1) Lots 120-120
   BASUTOLAND (1) Lots 122-122
   BECHUANALAND (1) Lots 124-124
   BELGIUM (3) Lots 125-127
   BHUTAN (1) Lots 132-132
   BRITISH ANTARCTIC TERRITORY (1) Lots 135-135
   BRITISH COLUMBIA (2) Lots 136-139
   BRITISH INDIAN OCEAN TERRITORY (1) Lots 141-141
   BRITISH SOLOMON ISLANDS (3) Lots 143-146
   CANAL ZONE (1) Lots 152-152
   CAYMAN ISLANDS (1) Lots 160-160
   CEYLON (1) Lots 161-161
   CHINA (70) Lots 170-279
   CHRISTMAS ISLAND (5) Lots 283-287
   CINDERELLA (2) Lots 289-290
   COCOS (KEELING) ISLAND (5) Lots 291-295
   COMORO ISLAND (1) Lots 300-300
   COOK ISLANDS (2) Lots 301-302
   EGYPT (1) Lots 308-308
   FIJI (1) Lots 316-316
   FRANCE (2) Lots 317-318
   FRENCH ANTARCTIC TERRITORY (1) Lots 326-326
   GAMBIA (1) Lots 332-332
   GERMAN SOUTH WEST AFRICA (6) Lots 334-339
   GERMANY (3) Lots 341-344
   GIBRALTAR (61) Lots 347-525
   GILBERT & ELLICE ISLANDS (4) Lots 527-535
   GOLD COAST (1) Lots 538-538
   GREAT BRITAIN (103) Lots 539-788
   GREECE (1) Lots 790-790
   GREENLAND (12) Lots 791-817
   GUERNSEY (8) Lots 823-830
   HONG KONG (2) Lots 831-832
   HUNGARY (2) Lots 835-841
   ITALY (1) Lots 848-848
   IVORY COAST (1) Lots 849-849
   JAPAN (1) Lots 853-853
   JERSEY (1) Lots 857-857
   LIECHTENSTEIN (9) Lots 865-922
   MALAYA (1) Lots 936-936
   MARIANA ISLANDS (1) Lots 951-951
   MAURITIUS (2) Lots 952-954
   MONGOLIA (12) Lots 1016-999
   MOROCCO AGENCIES (1) Lots 1022-1022
   NATAL (2) Lots 1023-1025
   NAURU (1) Lots 1026-1026
   NEVIS (1) Lots 1032-1032
   NEW BRUNSWICK (2) Lots 1034-1035
   NEW GUINEA (5) Lots 1049-1053
   NEWFOUNDLAND (31) Lots 1063-1127
   NIUE (1) Lots 1132-1132
   NORFOLK ISLAND (9) Lots 1140-1158
   NOVA SCOTIA (1) Lots 1168-1168
   OCEANIC SETTLEMENTS (1) Lots 1170-1170
   OMAN (2) Lots 1171-1172
   PAPUA (2) Lots 1174-1175
   PAPUA & NEW GUINEA (1) Lots 1178-1178
   PENRHYN ISLAND (15) Lots 1182-1199
   PITCAIRN ISLAND (15) Lots 1200-1231
   PORTUGAL (1) Lots 1237-1237
   PRINCE EDWARD ISLAND (3) Lots 1239-1248
   QUEENSLAND (1) Lots 1252-1252
   RUSSIA (20) Lots 1255-1304
   SAMOA (1) Lots 1308-1308
   SINGAPORE (1) Lots 1314-1314
   SOUTH AFRICA (2) Lots 1316-1317
   SOUTH AUSTRALIA (1) Lots 1318-1318
   SOUTH WEST AFRICA (2) Lots 1320-1321
   ST HELENA (1) Lots 1328-1328
   SWITZERLAND (2) Lots 1333-1334
   SYRIA (1) Lots 1336-1336
   TOGO (2) Lots 1340-1341
   TONGA (2) Lots 1342-1344
   TRISTAN DA CUNHA (1) Lots 1345-1345
   UNITED STATES OF AMERICA (4) Lots 1349-1362
   WESTERN AUSTRALIA (1) Lots 1366-1366

(To See All Prices Realized in Column Mode)

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

Element CURR_SALE is undefined in SESSION.

 
The error occurred in E:/InetPub/wwwroot/auctionnet/ccatalog2.cfm: line 183
181 : 		FROM (select Firm_id,Sale_No, Lot_No, htmlfile, currency, Realized as PRICE, INLINEIMG,LINKEDIMG,htmltext,row_number() over (order by dbo.Catalog_sort(Wlots.Lot_No)) as SANRowNo
182 : 		from WLOTS 
183 : 		where WLOTS.SALE_NO = '#session.CURR_SALE#' and WLOTS.FIRM_ID = '#session.FIRM_ID#' and MAJGROUP LIKE '#MAJGROUP#' ) a ORDER BY a.SANRowNo 
184 : <!---		WHERE a.SanRowNo between #session.nextrecordtoshow# and #session.lastrecordtoshow# ORDER BY a.SANRowNo 	--->
185 : 		

Resources:

Browser   Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
Remote Address   216.73.216.0
Referrer  
Date/Time   23-Dec-25 04:46 AM
Stack Trace
at cfccatalog22ecfm732045122.runPage(E:/InetPub/wwwroot/auctionnet/ccatalog2.cfm:183)

coldfusion.runtime.UndefinedElementException: Element CURR_SALE is undefined in SESSION.
	at coldfusion.runtime.CfJspPage.resolveCanonicalName(CfJspPage.java:2855)
	at coldfusion.runtime.CfJspPage._resolve(CfJspPage.java:2778)
	at coldfusion.runtime.CfJspPage._resolveAndAutoscalarize(CfJspPage.java:3054)
	at coldfusion.runtime.CfJspPage._resolveAndAutoscalarize(CfJspPage.java:3005)
	at cfccatalog22ecfm732045122.runPage(E:\InetPub\wwwroot\auctionnet\ccatalog2.cfm:183)
	at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:251)
	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:613)
	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.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:199)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:144)
	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:168)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:144)
	at jdk.internal.reflect.GeneratedMethodAccessor104.invoke(Unknown Source)
	at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.base/java.lang.reflect.Method.invoke(Method.java:568)
	at com.intergral.fusionreactor.j2ee.filterchain.WrappedFilterChain.doFilter(WrappedFilterChain.java:134)
	at com.intergral.fusionreactor.j2ee.filter.FusionReactorRequestHandler.doNext(FusionReactorRequestHandler.java:698)
	at com.intergral.fusionreactor.j2ee.filter.FusionReactorRequestHandler.doHttpServletRequest(FusionReactorRequestHandler.java:256)
	at com.intergral.fusionreactor.j2ee.filter.FusionReactorRequestHandler.doFusionRequest(FusionReactorRequestHandler.java:119)
	at com.intergral.fusionreactor.j2ee.filter.FusionReactorRequestHandler.handle(FusionReactorRequestHandler.java:736)
	at com.intergral.fusionreactor.j2ee.filter.FusionReactorCoreFilter.doFilter(FusionReactorCoreFilter.java:36)
	at jdk.internal.reflect.GeneratedMethodAccessor114.invoke(Unknown Source)
	at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.base/java.lang.reflect.Method.invoke(Method.java:568)
	at com.intergral.fusionreactor.j2ee.filterchain.WrappedFilterChain.doFilter(WrappedFilterChain.java:71)
	at jdk.internal.reflect.GeneratedMethodAccessor101.invoke(Unknown Source)
	at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.base/java.lang.reflect.Method.invoke(Method.java:568)
	at com.intergral.fusionreactor.agent.filter.FusionReactorStaticFilter.doFilter(FusionReactorStaticFilter.java:54)
	at com.intergral.fusionreactor.agent.pointcuts.NewFilterChainPointCut$1.invoke(NewFilterChainPointCut.java:50)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:168)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:90)
	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:482)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:130)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:93)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:357)
	at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:448)
	at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:63)
	at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:936)
	at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1791)
	at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:52)
	at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1190)
	at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659)
	at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:63)
	at java.base/java.lang.Thread.run(Thread.java:842)