Error on Page: /club/scripts/calendar/daily.asp

Query String: NS=HOME&D=4/10/2023

Database Error: (-2147217913) Conversion failed when converting the varchar value 'HOME' to data type int.

Source:


SQL: select V.*
, WLS.*
,null as ureg_id
from vw_clubcalendar V (nolock)
left outer join tbl_club_calendar_waitlist_settings WLS (nolock) on V.clubcal_id = WLS.ClubCal_Waitlist_ClubCal_ID
where v.ClubCal_Club_ID = 3555
and ( ( ClubCal_Date_End is null
and ( ClubCal_Date >= '4/10/2023'
and ClubCal_Date <= '4/10/2023'
) )
or ( ClubCal_Date_End is not null
and ( ClubCal_Date <= '4/10/2023'
and ClubCal_Date_End >='4/10/2023'
) )
)
and (clubcal_event_hide_days is null or ClubCal_Reg_Start is null or (
getdate() >= dateadd(day, clubcal_event_hide_days ,clubcal_reg_start)
) )
and (clubcal_memfac_id = 0 or clubcal_memfac_id is null)
AND ( (
clubcal_categ_nav_code in ('HOME')
or (v.clubcal_id in
(select clubcal_id
from tbl_club_calendar_sections
where clubcal_nav_section in (2688012)
and clubcal_club_id = 3555)
)
)

) and ((CLUBCAL_SECURE_FLAG = 0 or CLUBCAL_SECURE_FLAG = 2))
and clubcal_active = 1
ORDER BY ClubCal_Date, datepart(HOUR,IsNull(ClubCal_Time,ClubCal_Date)), datepart(Minute,IsNull(ClubCal_Time,ClubCal_Date)), ClubCal_Desc