General SQL Error<!-- <style type="text/css">.cfdump_table { cell-spacing: 2; background-color: #cccccc }.cfdump_th { font-size: small; font-family: verdana, arial, helvetica, sans-serif; color: white; text-align: left; padding: 5px; background-color: #666666 }.cfdump_td_name  { font-size: small; font-family: verdana, arial, helvetica, sans-serif; color: black; text-align: left; padding: 3px; background-color: #e0e0e0; vertical-align: top }.cfdump_td_value { font-size: small; font-family: verdana, arial, helvetica, sans-serif; color: black; text-align: left; padding: 3px; background-color: #ffffff; vertical-align: top }.cfdump_table_struct { cell-spacing: 2; background-color: #336699 }.cfdump_th_struct { font-size: small; font-family: verdana, arial, helvetica, sans-serif; color: white; text-align: left; padding: 5px; background-color: #3366cc }.cfdump_td_struct  { font-size: small; font-family: verdana, arial, helvetica, sans-serif; color: black; text-align: left; padding: 3px; background-color: #99ccff; vertical-align: top }.cfdump_table_array { cell-spacing: 2; background-color: #006600 }.cfdump_th_array { font-size: small; font-family: verdana, arial, helvetica, sans-serif; color: white; text-align: left; padding: 5px; background-color: #009900 }.cfdump_td_array  { font-size: small; font-family: verdana, arial, helvetica, sans-serif; color: black; text-align: left; padding: 3px; background-color: #ccffcc; vertical-align: top }.cfdump_table_binary { cell-spacing: 2; background-color: #ff6600 }.cfdump_th_binary { font-size: small; font-family: verdana, arial, helvetica, sans-serif; color: white; text-align: left; padding: 5px; background-color: #ff9900 }.cfdump_table_object { cell-spacing: 2; background-color: #990000 }.cfdump_th_object { font-size: small; font-family: verdana, arial, helvetica, sans-serif; color: white; text-align: left; padding: 5px; background-color: #cc3300 }.cfdump_td_object  { font-size: small; font-family: verdana, arial, helvetica, sans-serif; color: black; text-align: left; padding: 3px; background-color: #ffcccc; vertical-align: top }.cfdump_table_query { cell-spacing: 2; background-color: #990066 }.cfdump_th_query { font-size: small; font-family: verdana, arial, helvetica, sans-serif; color: white; text-align: left; padding: 5px; background-color: #993399 }.cfdump_td_query  { font-size: small; font-family: verdana, arial, helvetica, sans-serif; color: black; text-align: left; padding: 3px; background-color: #ffccff; vertical-align: top }.cfdump_table_xml { cell-spacing: 2; background-color: #666666 }.cfdump_th_xml { font-size: small; font-family: verdana, arial, helvetica, sans-serif; color: white; text-align: left; padding: 5px; background-color: #999999 }.cfdump_td_xml  { font-size: small; font-family: verdana, arial, helvetica, sans-serif; color: black; text-align: left; padding: 3px; background-color: #dddddd; vertical-align: top }.cfdump_table_udf { cell-spacing: 2; background-color: #660033 }.cfdump_th_udf { font-size: small; font-family: verdana, arial, helvetica, sans-serif; color: white; text-align: left; padding: 5px; background-color: #996633 }.cfdump_td_udf  { font-size: small; font-family: verdana, arial, helvetica, sans-serif; font-style: italic; color: black; text-align: left; padding: 3px; background-color: #ffffff; vertical-align: top }.cfdump_table_udf_args { cell-spacing: 2; background-color: #996600 }.cfdump_th_udf_args { font-size: small; font-family: verdana, arial, helvetica, sans-serif; color: white; text-align: left; padding: 5px; background-color: #cc9900 }</style><table class='cfdump_table_struct'><th class='cfdump_th_struct' colspan='2'>struct</th><tr><td class='cfdump_td_struct'>column</td><td class='cfdump_td_value'>2</td></tr><tr><td class='cfdump_td_struct'>datasource</td><td class='cfdump_td_value'>NEDSCHOOLS</td></tr><tr><td class='cfdump_td_struct'>detail</td><td class='cfdump_td_value'>Database reported: ORA-01722: invalid number
</td></tr><tr><td class='cfdump_td_struct'>errorcode</td><td class='cfdump_td_value'>errorCode.sqlError</td></tr><tr><td class='cfdump_td_struct'>extendedinfo</td><td class='cfdump_td_value'>[empty string]</td></tr><tr><td class='cfdump_td_struct'>line</td><td class='cfdump_td_value'>264</td></tr><tr><td class='cfdump_td_struct'>message</td><td class='cfdump_td_value'>General SQL Error</td></tr><tr><td class='cfdump_td_struct'>nativeerrorcode</td><td class='cfdump_td_value'>1722</td></tr><tr><td class='cfdump_td_struct'>queryError</td><td class='cfdump_td_value'>ORA-01722: invalid number
</td></tr><tr><td class='cfdump_td_struct'>sql</td><td class='cfdump_td_value'>select * from schoolsearch.school_data 
		where school_num =  '8471%20-%2024k'</td></tr><tr><td class='cfdump_td_struct'>sqlstate</td><td class='cfdump_td_value'>42000</td></tr><tr><td class='cfdump_td_struct'>tagcontext</td><td class='cfdump_td_value'><table class='cfdump_table_array'><th class='cfdump_th_array' colspan='2'>array</th><tr><td class='cfdump_td_array'>1</td><td class='cfdump_td_value'><table class='cfdump_table_struct'><th class='cfdump_th_struct' colspan='2'>struct</th><tr><td class='cfdump_td_struct'>column</td><td class='cfdump_td_value'>2</td></tr><tr><td class='cfdump_td_struct'>id</td><td class='cfdump_td_value'>CFTRY</td></tr><tr><td class='cfdump_td_struct'>line</td><td class='cfdump_td_value'>11</td></tr><tr><td class='cfdump_td_struct'>template</td><td class='cfdump_td_value'>/u01/app/ias/10.1.3/j2ee/ct10/applications/schoolfind/schoolfind-web/locator/index.cfm</td></tr></table></td></tr><tr><td class='cfdump_td_array'>2</td><td class='cfdump_td_value'><table class='cfdump_table_struct'><th class='cfdump_th_struct' colspan='2'>struct</th><tr><td class='cfdump_td_struct'>column</td><td class='cfdump_td_value'>1</td></tr><tr><td class='cfdump_td_struct'>id</td><td class='cfdump_td_value'>CFSWITCH</td></tr><tr><td class='cfdump_td_struct'>line</td><td class='cfdump_td_value'>12</td></tr><tr><td class='cfdump_td_struct'>template</td><td class='cfdump_td_value'>/u01/app/ias/10.1.3/j2ee/ct10/applications/schoolfind/schoolfind-web/locator/index.cfm</td></tr></table></td></tr><tr><td class='cfdump_td_array'>3</td><td class='cfdump_td_value'><table class='cfdump_table_struct'><th class='cfdump_th_struct' colspan='2'>struct</th><tr><td class='cfdump_td_struct'>column</td><td class='cfdump_td_value'>1</td></tr><tr><td class='cfdump_td_struct'>id</td><td class='cfdump_td_value'>CFCASE</td></tr><tr><td class='cfdump_td_struct'>line</td><td class='cfdump_td_value'>47</td></tr><tr><td class='cfdump_td_struct'>template</td><td class='cfdump_td_value'>/u01/app/ias/10.1.3/j2ee/ct10/applications/schoolfind/schoolfind-web/locator/index.cfm</td></tr></table></td></tr><tr><td class='cfdump_td_array'>4</td><td class='cfdump_td_value'><table class='cfdump_table_struct'><th class='cfdump_th_struct' colspan='2'>struct</th><tr><td class='cfdump_td_struct'>column</td><td class='cfdump_td_value'>2</td></tr><tr><td class='cfdump_td_struct'>id</td><td class='cfdump_td_value'>CFSET</td></tr><tr><td class='cfdump_td_struct'>line</td><td class='cfdump_td_value'>48</td></tr><tr><td class='cfdump_td_struct'>template</td><td class='cfdump_td_value'>/u01/app/ias/10.1.3/j2ee/ct10/applications/schoolfind/schoolfind-web/locator/index.cfm</td></tr></table></td></tr><tr><td class='cfdump_td_array'>5</td><td class='cfdump_td_value'><table class='cfdump_table_struct'><th class='cfdump_th_struct' colspan='2'>struct</th><tr><td class='cfdump_td_struct'>column</td><td class='cfdump_td_value'>1</td></tr><tr><td class='cfdump_td_struct'>id</td><td class='cfdump_td_value'>CFFUNCTION</td></tr><tr><td class='cfdump_td_struct'>line</td><td class='cfdump_td_value'>262</td></tr><tr><td class='cfdump_td_struct'>template</td><td class='cfdump_td_value'>/u01/app/ias/10.1.3/j2ee/ct10/applications/schoolfind/schoolfind-web/locator/main_v2.cfc</td></tr></table></td></tr><tr><td class='cfdump_td_array'>6</td><td class='cfdump_td_value'><table class='cfdump_table_struct'><th class='cfdump_th_struct' colspan='2'>struct</th><tr><td class='cfdump_td_struct'>column</td><td class='cfdump_td_value'>2</td></tr><tr><td class='cfdump_td_struct'>id</td><td class='cfdump_td_value'>CFQUERY</td></tr><tr><td class='cfdump_td_struct'>line</td><td class='cfdump_td_value'>264</td></tr><tr><td class='cfdump_td_struct'>template</td><td class='cfdump_td_value'>/u01/app/ias/10.1.3/j2ee/ct10/applications/schoolfind/schoolfind-web/locator/main_v2.cfc</td></tr></table></td></tr></table></td></tr><tr><td class='cfdump_td_struct'>tagname</td><td class='cfdump_td_value'>CFQUERY</td></tr><tr><td class='cfdump_td_struct'>template</td><td class='cfdump_td_value'>/u01/app/ias/10.1.3/j2ee/ct10/applications/schoolfind/schoolfind-web/locator/main_v2.cfc</td></tr><tr><td class='cfdump_td_struct'>type</td><td class='cfdump_td_value'>Database</td></tr></table> -->