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.


Query Of Queries syntax error.
Encountered "offerid in ( ). Incorrect conditional expression, Expected one of [like|null|between|in|comparison] condition,
 
The error occurred in \\itchynscratchy\websites-templates\public-websites\www.igluvillas.com\family_deals.cfm: line 35
 
33 : 	<cfquery name="QQ_param" dbtype="query">
34 : 		select * from application.villasOfferList
35 : 		where offerid in (#valueList(res_offerList.offerid,",")#)
36 : 	</cfquery>
37 :
SQL    select * from application.villasOfferList where offerid in ()
Resources:

Browser   CCBot/1.0 (+http://www.commoncrawl.org/bot.html)
Remote Address   38.107.191.81
Referrer  
Date/Time   21-Mar-10 09:02 AM
Stack Trace
at cffamily_deals2ecfm1532182143.runPage(\\itchynscratchy\websites-templates\public-websites\www.igluvillas.com\family_deals.cfm:35) at cffamily_deals2ecfm1532182143.runPage(\\itchynscratchy\websites-templates\public-websites\www.igluvillas.com\family_deals.cfm:35) 

java.sql.SQLException: <br><b>Query Of Queries syntax error.</b><br>
Encountered "offerid in ( ).
Incorrect conditional expression, 
Expected one of [like|null|between|in|comparison] condition, 

	at coldfusion.sql.imq.jdbcStatement.parseSQL(jdbcStatement.java:566)
	at coldfusion.sql.imq.jdbcStatement.fetchResult(jdbcStatement.java:536)
	at coldfusion.sql.imq.jdbcStatement.execute(jdbcStatement.java:131)
	at coldfusion.sql.Executive.executeQuery(Executive.java:753)
	at coldfusion.sql.SqlImpl.execute(SqlImpl.java:240)
	at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:500)
	at cffamily_deals2ecfm1532182143.runPage(\\itchynscratchy\websites-templates\public-websites\www.igluvillas.com\family_deals.cfm:35)
	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)