[Microsoft][ODBC Driver 18 for SQL Server][SQL Server]Conversion failed when converting the varchar value 'Featured' to data type int.
MSSQL error: [Microsoft][ODBC Driver 18 for SQL Server][SQL Server]Conversion failed when converting the varchar value 'Featured' to data type int.
Query:
SELECT rf.ID as EventID,
rf.Name as EventName,
rf.RegStart,
rf.RegEnd,
rf.RegLimit,
rf.EventStart,
rf.EventEnd,
SUBSTRING(rf.Description, 1, 800) as Description,
rf.ArenaName,
rf.ArenaAddress,
rf.ArenaCity,
UPPER(rf.ArenaState) as ArenaState,
rf.ArenaZip,
rf.ArenaCountry,
rf.bIsActive,
rf.bIsFullRegistration,
c.bFullRegistration,
c.code as clubcode,
c.Name as ClubName,
et.image as EventImage,
et.Name as EventType
FROM registrationforms rf
LEFT JOIN eventtypes et on rf.fkEventTypes = et.id
LEFT JOIN Clubs c ON c.ID = rf.fkClubs
WHERE rf.bIsActive = 1
AND YEAR(EventStart) = 'Featured'
AND bIscomplete = 1
ORDER BY rf.eventstart DESC
---
File: /ds0/server/webroot/cmsa.graphicsbydavin.com/results/by-year.php (Line: 24)
Func: fetchByID
Args: Array
(
[0] =>
SELECT rf.ID as EventID,
rf.Name as EventName,
rf.RegStart,
rf.RegEnd,
rf.RegLimit,
rf.EventStart,
rf.EventEnd,
SUBSTRING(rf.Description, 1, 800) as Description,
rf.ArenaName,
rf.ArenaAddress,
rf.ArenaCity,
UPPER(rf.ArenaState) as ArenaState,
rf.ArenaZip,
rf.ArenaCountry,
rf.bIsActive,
rf.bIsFullRegistration,
c.bFullRegistration,
c.code as clubcode,
c.Name as ClubName,
et.image as EventImage,
et.Name as EventType
FROM registrationforms rf
LEFT JOIN eventtypes et on rf.fkEventTypes = et.id
LEFT JOIN Clubs c ON c.ID = rf.fkClubs
WHERE rf.bIsActive = 1
AND YEAR(EventStart) = 'Featured'
AND bIscomplete = 1
ORDER BY rf.eventstart DESC
[1] => EventID
)
