This is for a legacy site. I'm not the person who developed it and am new to Coldfusion. This is happening when doing a search query.
Cold is old but running on CF9. Previous db was MSSQL 5 but was converted to MSSQL 14 during this conversion.
<cfquery name="registrylist" datasource="#DSN#">
and event.eventid = #eventid#
and registry.eventid = event.eventid
and Event.eventTypeCode = EventType.eventTypeCode
ORDER BY A.sortOrder,Registry.categoryOrder,Registry.registryID
[Macromedia][SQLServer JDBC Driver][SQLServer]Incorrect syntax near '*='.
Issue seems to be with the "*+" Removing just they "*"'s page will load but with no information from db. Removing jus the "=" or both "*+"'s returns similar error.
wow! That is some old SQL!
*= is a LEFT OUTER JOIN
This operator was depreciated about 10 years ago though, with the old version of SQL you were using you wouldn't have noticed an issue but now using a newer version of SQL you will see these problems.
You will need to re write the SQL queries using the correct LEFT JOIN syntax.
As a side note, if you are using CF9, you may find problems with SQL 2014 as support for it has only become available for CF11