Ah Snap, an error occurred.We apologize for the inconvenience! An administrator has been notified about this error. If you wish to submit further information about this problem, you can email cferrors@thinairwebmail.com. Error DetailsError URL: http://www.demoraesproperties.com/page.cfm?display=thumbnail&pageid=34305&maxrows=20&Search=Search&mls=1&quicksearch=0&LIST_115=Basalt&startrow=1&orderby=LIST_22%2520DESC&LIST_1=20190815161111094997000000&RealtyOfficeID=56 Error Location: CFQUERY tag in C:\inetpub\wwwroot\completesite\Webfiles\CustomTags\thinair\realestate\mlsquery.cfm, line 177 Error Executing Database Query. [Macromedia][SQLServer JDBC Driver][SQLServer]The data types float and int are incompatible in the modulo operator. The error occurred on line 177. SQL: SELECT mpr.colisting_member_name, mpr.LIST_0,mpr.LIST_1,mpr.LIST_2,mpr.LIST_3 ,mpr.LIST_4,mpr.LIST_5,mpr.LIST_6 ,mpr.LIST_7,mpr.LIST_8,mpr.LIST_87 ,mpr.LIST_104,mpr.LIST_106 ,mpr.LIST_105,mpr.LIST_115 ,mpr.LIST_118,mpr.LIST_120,mpr.LIST_22,mpr.LIST_41,mpr.LIST_48 ,mpr.LIST_53,mpr.LIST_57,mpr.LIST_66,mpr.LIST_68,mpr.LIST_69 ,mpr.LIST_73,mpr.LIST_75,mpr.LIST_77,mpr.LIST_78,mpr.LIST_88,mpr.LIST_9 ,mpr.listing_member_name ,mpr.UNBRANDEDIDXVIRTUALTOUR, mpr.LIST_15, mpr.LIST_23 ,p.PhotoSeq,p.PhotoCaption,p.largeURL,p.smallURL , CASE WHEN mpr.LIST_106 = '20140911212026854270000000' THEN 1 ELSE 0 END AS OfficeListing FROM MLSProperties_spark mpr CROSS APPLY( SELECT TOP 1 * FROM MLSPhotos_spark p1 WHERE p1.LIST_1 = mpr.LIST_1 ORDER BY p1.photoSeq ASC ) p WHERE mpr.list_3 > 0 AND mpr.list_15 <> 'Closed' AND mpr.LIST_115 = 'Basalt' ORDER BY LIST_22%20DESC Calling Stack: C:\inetpub\wwwroot\completesite\Webfiles\CustomTags\thinair\realestate\mlsquery.cfm, line 177 C:\inetpub\wwwroot\completesite\Webfiles\CustomTags\thinair\realestate\mlsnextprevious.cfm, line 12 C:\inetpub\wwwroot\completesite\Webfiles\CustomTags\thinair\realestate\mlsproperty_responsive.cfm, line 107 C:\inetpub\wwwroot\completesite\Webfiles\CustomTags\thinair\realestate\mlsproperty_responsive.cfm, line 106 C:\inetpub\wwwroot\completesite\Webfiles\CustomTags\thinair\realestate\mlsproperty_responsive.cfm, line 1 C:\inetpub\wwwroot\completesite\Webfiles\CustomTags\thinair\realestate\mls_responsive.cfm, line 31 C:\inetpub\wwwroot\completesite\Webfiles\CustomTags\completesite\realestatecontent_responsive.cfm, line 122 C:\inetpub\wwwroot\completesite\Webfiles\CustomTags\completesite\realestatecontent_responsive.cfm, line 116 C:\inetpub\wwwroot\completesite\Webfiles\CustomTags\completesite\realestatecontent_responsive.cfm, line 101 C:\inetpub\wwwroot\completesite\Webfiles\CustomTags\completesite\realestatecontent_responsive.cfm, line 100 C:\inetpub\wwwroot\completesite\Webfiles\CustomTags\completesite\realestatecontent_responsive.cfm, line 1 C:\inetpub\wwwroot\completesite\Webfiles\CustomTags\completesite\pagecontent_responsive.cfm, line 223 C:\inetpub\wwwroot\completesite\Webfiles\CustomTags\completesite\pagecontent_responsive.cfm, line 1 C:\inetpub\wwwroot\completesite\Webfiles\CustomTags\completesite\pagecontent_responsive.cfm, line 1 C:\inetpub\wwwroot\completesite\demoraes\page.cfm, line 333 |SQLServer|6.0.0.1282|, line 1103 |SQLServer|6.0.0.1282|, line 980 |SQLServer|6.0.0.1282|, line 1124 |SQLServer|6.0.0.1282|, line 193 |SQLServer|6.0.0.1282|, line 1153 |SQLServer|6.0.0.1282|, line 4126 |SQLServer|6.0.0.1282|, line 1059 |SQLServer|6.0.0.1282|, line 327 |SQLServer|6.0.0.1282|, line 4275 |SQLServer|6.0.0.1282|, line 856 |SQLServer|6.0.0.1282|, line 815 |SQLServer|6.0.0.1282|, line 463 |SQLServer|6.0.0.1282|, line 1376 |SQLServer|6.0.0.1282|, line 2505 |SQLServer|6.0.0.1282|, line 1358 |SQLServer|6.0.0.1282|, line 4478 Date and Time: 4/19/2024 9:04 PM Browser: Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com) Remote Address: 13.58.151.231 |