Terms & Conditions

Please read our terms & conditions carefully before placing an absentee bid or attending in person.

Our absentee/telephone bid form is available here

Looking to Sell?

We offer online appraisal services. Click here to submit your item for appraisal by Smith's experts.

Get Auction Updates

W.A. Smith, Inc.

1064 Route 12A
Plainfield, NH 03781
(603) 675-2549
info@wsmithauction.com

Upcoming Events at Smith's

May 2008

Exceptional 40th Annual Memorial Day Estate Auction

Featuring Fine Antiques, Decorative Furnishings and Accessories, Artworks, Jewelry and Silver

Where: W.A. Smith Auction Gallery in Plainfield, NH

When: Monday, May 26, 2008
at 10:00 AM

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.

Syntax error or access violation: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 2

The error occurred in C:\Inetpub\vhosts\wsmithauction.com\httpdocs\inc\auctionlinks.cfm: line 4
Called from C:\Inetpub\vhosts\wsmithauction.com\httpdocs\auctions\index.cfm: line 56
Called from C:\Inetpub\vhosts\wsmithauction.com\httpdocs\inc\auctionlinks.cfm: line 4
Called from C:\Inetpub\vhosts\wsmithauction.com\httpdocs\auctions\index.cfm: line 56

2 :     <cfquery name="lots" datasource="#application.dsn#">
3 :     SELECT items.itemID FROM items INNER JOIN images where items.itemID = images.itemID
4 :     AND items.auctionID = #session.auctionID#
5 :     </cfquery>
6 :   </cfif>

SQL	SELECT items.itemID FROM items INNER JOIN images where items.itemID = images.itemID AND items.auctionID =
DATASOURCE	amerida_wasmithauction
VENDORERRORCODE	1064
SQLSTATE	42000

Resources:

Check the ColdFusion documentation to verify that you are using the correct syntax.
Search the Knowledge Base to find a solution to your problem.

Browser	CCBot/1.0 (+http://www.commoncrawl.org/bot.html)
Remote Address	38.103.63.16
Referrer
Date/Time	12-May-08 01:44 AM

Stack Trace

at cfauctionlinks2ecfm634460038.runPage(C:\Inetpub\vhosts\wsmithauction.com\httpdocs\inc\auctionlinks.cfm:4) at cfindex2ecfm1768760651.runPage(C:\Inetpub\vhosts\wsmithauction.com\httpdocs\auctions\index.cfm:56) at cfauctionlinks2ecfm634460038.runPage(C:\Inetpub\vhosts\wsmithauction.com\httpdocs\inc\auctionlinks.cfm:4) at cfindex2ecfm1768760651.runPage(C:\Inetpub\vhosts\wsmithauction.com\httpdocs\auctions\index.cfm:56)

java.sql.SQLException: Syntax error or access violation: You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 2
	at org.gjt.mm.mysql.MysqlIO.sendCommand(Unknown Source)
	at org.gjt.mm.mysql.MysqlIO.sqlQueryDirect(Unknown Source)
	at org.gjt.mm.mysql.MysqlIO.sqlQuery(Unknown Source)
	at org.gjt.mm.mysql.Connection.execSQL(Unknown Source)
	at org.gjt.mm.mysql.Connection.execSQL(Unknown Source)
	at org.gjt.mm.mysql.Statement.execute(Unknown Source)
	at org.gjt.mm.mysql.jdbc2.Statement.execute(Unknown Source)
	at coldfusion.server.j2ee.sql.JRunStatement.execute(JRunStatement.java:212)
	at coldfusion.sql.Executive.executeQuery(Executive.java:753)
	at coldfusion.sql.Executive.executeQuery(Executive.java:675)
	at coldfusion.sql.Executive.executeQuery(Executive.java:636)
	at coldfusion.sql.SqlImpl.execute(SqlImpl.java:236)
	at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:500)
	at cfauctionlinks2ecfm634460038.runPage(C:\Inetpub\vhosts\wsmithauction.com\httpdocs\inc\auctionlinks.cfm:4)
	at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:152)
	at coldfusion.filter.CFVariablesScopeFilter.invoke(CFVariablesScopeFilter.java:63)
	at coldfusion.tagext.lang.ModuleTag.doStartTag(ModuleTag.java:255)
	at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:1925)
	at cfindex2ecfm1768760651.runPage(C:\Inetpub\vhosts\wsmithauction.com\httpdocs\auctions\index.cfm:56)
	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:225)
	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)