BLOG de WLLC

view all

NOTICIAS

ver todo

Biblioteca

Let Us Know How We Can Help
Williamson & Lavecchia, L.C.

6800 Paragon Place, Suite 233
Richmond, VA 23230-1652

Tel: 804 288-1661
Fax: 804 282-1766

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 'date'.
 
The error occurred in E:\Sites\INCLUDES\compoments\helperfunctions.cfc: line 506
Called from E:\Sites\INCLUDES\compoments\dsscontent.cfc: line 1062
Called from E:\Sites\wllc.com\subdomains\spanish\includes\right.cfm: line 19
Called from E:\Sites\wllc.com\subdomains\spanish\includes\footer.cfm: line 3
Called from E:\Sites\wllc.com\subdomains\spanish\faq.cfm: line 34
Called from E:\Sites\INCLUDES\compoments\helperfunctions.cfc: line 506
Called from E:\Sites\INCLUDES\compoments\dsscontent.cfc: line 1062
Called from E:\Sites\wllc.com\subdomains\spanish\includes\right.cfm: line 19
Called from E:\Sites\wllc.com\subdomains\spanish\includes\footer.cfm: line 3
Called from E:\Sites\wllc.com\subdomains\spanish\faq.cfm: line 34
 
504 : 		<cfset sqllist=sqllist & " order by cat desc, a.date desc">
505 : 		<cfquery name="DSSQuery" datasource="#application.ds#">
506 : 			#preserveSingleQuotes(sqllist)#
507 : 		</cfquery>
508 :
SQL    select TOP 5 a.id, a.question, a.answer, 721 as cat, 'Productos Defectivos' as cat_name, 'PA' as type, 0 as previd, 1.0 as sortby from DSSClient_FAQ a where 1=1 and a.projectid=154 and a.catid=721 and a.isinpa=1 union all select TOP 5 a.id, a.question, a.answer, 722 as cat, 'Negligencia Médica' as cat_name, 'PA' as type, 721 as previd, 1.0 as sortby from DSSClient_FAQ a where 1=1 and a.projectid=154 and a.catid=722 and a.isinpa=1 union all select TOP 5 a.id, a.question, a.answer, 725 as cat, 'Objetos Olvidados en la Cirugía' as cat_name, 'PA' as type, 722 as previd, 1.0 as sortby from DSSClient_FAQ a where 1=1 and a.projectid=154 and a.catid=725 and a.isinpa=1 union all select TOP 5 a.id, a.question, a.answer, 724 as cat, 'Maltrato en Instituciones de Cuidados Médicos y Conducta Indebida de las Compañías de Seguros' as cat_name, 'PA' as type, 723 as previd, 1.0 as sortby from DSSClient_FAQ a where 1=1 and a.projectid=154 and a.catid=724 and a.isinpa=1 union all select TOP 5 a.id, a.question, a.answer, 723 as cat, 'Maltrato y Abandono de Ancianos' as cat_name, 'PA' as type, 725 as previd, 1.0 as sortby from DSSClient_FAQ a where 1=1 and a.projectid=154 and a.catid=723 and a.isinpa=1 order by cat desc, a.date desc
DATASOURCE   Fosterdad
VENDORERRORCODE   207
SQLSTATE   42S22
Resources:

Browser   CCBot/1.0 (+http://www.commoncrawl.org/bot.html)
Remote Address   38.103.63.17
Referrer  
Date/Time   13-May-08 05:17 PM
Stack Trace
at cfhelperfunctions2ecfc1080761731$funcLIMITSTRINGQUERY.runFunction(E:\Sites\INCLUDES\compoments\helperfunctions.cfc:506) at cfdsscontent2ecfc895010373$funcDISPLAYCATEGORIZEDFAQS.runFunction(E:\Sites\INCLUDES\compoments\dsscontent.cfc:1062) at cfright2ecfm1360095864.runPage(E:\Sites\wllc.com\subdomains\spanish\includes\right.cfm:19) at cffooter2ecfm628853943.runPage(E:\Sites\wllc.com\subdomains\spanish\includes\footer.cfm:3) at cffaq2ecfm688450866.runPage(E:\Sites\wllc.com\subdomains\spanish\faq.cfm:34) at cfhelperfunctions2ecfc1080761731$funcLIMITSTRINGQUERY.runFunction(E:\Sites\INCLUDES\compoments\helperfunctions.cfc:506) at cfdsscontent2ecfc895010373$funcDISPLAYCATEGORIZEDFAQS.runFunction(E:\Sites\INCLUDES\compoments\dsscontent.cfc:1062) at cfright2ecfm1360095864.runPage(E:\Sites\wllc.com\subdomains\spanish\includes\right.cfm:19) at cffooter2ecfm628853943.runPage(E:\Sites\wllc.com\subdomains\spanish\includes\footer.cfm:3) at cffaq2ecfm688450866.runPage(E:\Sites\wllc.com\subdomains\spanish\faq.cfm:34) 

java.sql.SQLException: [Macromedia][SQLServer JDBC Driver][SQLServer]Invalid column name 'date'.
	at macromedia.jdbc.base.BaseExceptions.createException(Unknown Source)
	at macromedia.jdbc.base.BaseExceptions.getException(Unknown Source)
	at macromedia.jdbc.sqlserver.tds.TDSRequest.processErrorToken(Unknown Source)
	at macromedia.jdbc.sqlserver.tds.TDSRequest.processReplyToken(Unknown Source)
	at macromedia.jdbc.sqlserver.tds.TDSRequest.processReply(Unknown Source)
	at macromedia.jdbc.sqlserver.SQLServerImplStatement.getNextResultType(Unknown Source)
	at macromedia.jdbc.base.BaseStatement.commonTransitionToState(Unknown Source)
	at macromedia.jdbc.base.BaseStatement.postImplExecute(Unknown Source)
	at macromedia.jdbc.base.BaseStatement.commonExecute(Unknown Source)
	at macromedia.jdbc.base.BaseStatement.executeInternal(Unknown Source)
	at macromedia.jdbc.base.BaseStatement.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 cfhelperfunctions2ecfc1080761731$funcLIMITSTRINGQUERY.runFunction(E:\Sites\INCLUDES\compoments\helperfunctions.cfc:506)
	at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:344)
	at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:254)
	at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:56)
	at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:207)
	at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:169)
	at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:194)
	at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:146)
	at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:1634)
	at cfdsscontent2ecfc895010373$funcDISPLAYCATEGORIZEDFAQS.runFunction(E:\Sites\INCLUDES\compoments\dsscontent.cfc:1062)
	at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:344)
	at coldfusion.filter.SilentFilter.invoke(SilentFilter.java:47)
	at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:254)
	at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:56)
	at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:207)
	at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:366)
	at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:198)
	at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:157)
	at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:1594)
	at coldfusion.tagext.lang.InvokeTag.doEndTag(InvokeTag.java:341)
	at coldfusion.runtime.CfJspPage._emptyTag(CfJspPage.java:1916)
	at cfright2ecfm1360095864.runPage(E:\Sites\wllc.com\subdomains\spanish\includes\right.cfm:19)
	at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:152)
	at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:349)
	at coldfusion.runtime.CfJspPage._emptyTag(CfJspPage.java:1915)
	at cffooter2ecfm628853943.runPage(E:\Sites\wllc.com\subdomains\spanish\includes\footer.cfm:3)
	at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:152)
	at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:349)
	at coldfusion.runtime.CfJspPage._emptyTag(CfJspPage.java:1915)
	at cffaq2ecfm688450866.runPage(E:\Sites\wllc.com\subdomains\spanish\faq.cfm:34)
	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.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)