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?LIST_15=Closed&LIST_68_from=(any)&Search=Search&LIST_22_from=(any)&quicksearch=0&LIST_48_to=(any)&LIST_57_to=(any)&LIST_22_to=(any)&LIST_57_from=(any)&LIST_66_from=(any)&display=thumbnail&pageid=47733&LIST_48_from=(any)&maxrows=20&LIST_66_to=(any)&mls=1&LIST_106=20140911212026854270000000&LIST_68_to=(any)&REALTYOFFICEID=56&orderby=LIST_115,%2520LIST_88,%2520LIST_77 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]Incorrect syntax near '20'. 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_132 > {d '2020-03-29'} AND ( mpr.LIST_106 = '20140911212026854270000000' OR mpr.listOfficeId = '20140911212026854270000000' OR mpr.coListOfficeId = '20140911212026854270000000' OR mpr.buyerOfficeId = '20140911212026854270000000' OR mpr.LIST_62 IN (SELECT DISTINCT MLSMemberID FROM brokers WHERE brokerId IN (677)) OR mpr.listAgentId IN (SELECT DISTINCT MLSMemberID FROM brokers WHERE brokerId IN (677)) OR mpr.coListAgentId IN (SELECT DISTINCT MLSMemberID FROM brokers WHERE brokerId IN (677)) ) AND (mpr.LIST_5 IN (SELECT DISTINCT MLSMemberID FROM brokers WHERE brokerId IN (677)) OR mpr.LIST_6 IN (SELECT DISTINCT MLSMemberID FROM brokers WHERE brokerId IN (677)) OR (mpr.LIST_62 IN (SELECT DISTINCT MLSMemberID FROM brokers WHERE brokerId IN (677))) ) ORDER BY LIST_115,%20LIST_88,%20LIST_77 Calling Stack: C:\inetpub\wwwroot\completesite\Webfiles\CustomTags\thinair\realestate\mlsquery.cfm, line 177 C:\inetpub\wwwroot\completesite\Webfiles\CustomTags\thinair\realestate\mlslist_responsive.cfm, line 36 C:\inetpub\wwwroot\completesite\Webfiles\CustomTags\thinair\realestate\mlslist_responsive.cfm, line 1 C:\inetpub\wwwroot\completesite\Webfiles\CustomTags\thinair\realestate\mls_responsive.cfm, line 52 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 2035 |SQLServer|6.0.0.1282|, line 632 |SQLServer|6.0.0.1282|, line 2699 |SQLServer|6.0.0.1282|, line 2508 |SQLServer|6.0.0.1282|, line 1358 |SQLServer|6.0.0.1282|, line 4478 Date and Time: 3/29/2024 9:05 AM Browser: claudebot Remote Address: 44.197.191.240 |