Error Diagnostic InformationODBC Error Code = 37000 (Syntax error or access violation) [Microsoft][ODBC SQL Server Driver][SQL Server]Implicit conversion from datatype 'text' to 'varchar' is not allowed. Use the CONVERT function to run this query. Data Source = "D_SQL_SOL_MAIN" SQL = "select *, photo_url_prefix = (select photo_url_prefix from albums where album_id = A.album_id) FROM photos A WHERE (description like '%%%' OR event like '%%%' OR rider like '%%%' OR location like '%%%' OR discipline like '%%%' OR credit like '%%%' OR caption like '%%%') AND rider like '%%' AND location like '%%0F%3D%60%2E%A0%0E%60%2E%A0%0Erivacy%20pp%2E%A0%0Ey%3C%2Ffont%3Ex%2E%A0%0E%80%2E%A0%0E%0A%3C%21%2D%84%2E%A0%0EI%3ACR%90%2E%A0%0E%90%2E%A0%0E%2D%2D%3E%0D%0A%3Csc%A0%2E%A0%0E%20languag%A8%2E%A0%0E%B0%2E%A0%0Ecrip%B4%2E%A0%0E%0A%3C%21%2D%C0%2E%A0%0E%C0%2E%A0%0Eion%20x%28s%29%D0%2E%A0%0E%20%20%20%20%20%20va%D8%2E%A0%0E%E0%2E%A0%0E%20s%2Eo%E4%2E%A0%0Ens%5Bs%F0%2E%A0%0E%F0%2E%A0%0EdIndex%5D%2E%' AND discipline like '%cription%' AND credit like '% ation%'" The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (13:3) to (28:36). Date/Time: 02/29/00 19:14:21 |
Please inform the site administrator that this error has occurred (be sure to include the contents of this page in your message to the administrator).