Error Occurred While Processing Request

Error Diagnostic Information ODBC 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 '%cription%' AND location like '%%0Fike%20%27%60%03%09%10AUTH%5FTYPE%' AND discipline like '%>ø ë t color=E7EACB>Chat Calendar<˜¡ë The Shop <˜¢ë src=../images/1pix.gif width=1¸¢ë ght=7> Classifieds £ë mg src=../images/1pix.gif widt8£ë height=7> Directories<˜£ë Magazine ¤ë mg src=../images/1pix.gif widt8¤ë height=7> Subscribe ˜¤ë form method=POST action=/sea¸¤ë search_skate.cfm> SEARCH SKATEø¤ë advan¸¥ë search Ø¥ë orm method=POST action=/regiø¥ë /register_insert_quick.cfm> ¦ë nt size=1 color=B8C7EB>su8¦ë ibe to THE GRIND ¸¦ë r>

The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (59:4) to (63:44). Date/Time: 02/29/00 14:34:21 Browser: ia_archiver Remote Address: 206.132.186.131 Template: D:\Websites\sol\htdocs\slideshow\enlarge.cfm Query String: description=%&rider=%&location=%&discipline=%&event=%&credit=%&photo=1&pos=1

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).