YAFLogo

balbes
  • balbes
  • 94% (Exalted)
  • YAF Lover Topic Starter
12 years ago
Quote:


FILE:
mssql/procedures.sql

ERROR:
Invalid column name 'Birthday'.
Invalid column name 'Birthday'.
Invalid column name 'Birthday'.

STATEMENT:
create procedure [dbo].[yaf_User_ListTodaysBirthdays](@BoardId int, @StyledNicks bit = null) as
begin

SELECT
usr.UserID,
[Birthday],
usr.DisplayName,
m.Username,
Style = case(@StyledNicks)
when 1 then ISNULL(( SELECT TOP 1 f.Style FROM [dbo].[yaf_UserGroup] e
join [dbo].[yaf_Group] f on f.GroupID=e.GroupID WHERE e.UserID=usr.UserID AND LEN(f.Style) > 2 ORDER BY f.SortOrder), rnk.Style)
else '' end
FROM [dbo].[yaf_prov_Profile] as u
JOIN [dbo].[yaf_prov_Membership] m on m.UserID=u.UserID
JOIN [dbo].[yaf_User] usr on usr.Name=m.UserName and usr.BoardID = @BoardId
join [dbo].[yaf_Rank] rnk on rnk.RankID=usr.RankID
where
datepart(MONTH,Birthday) = datepart(MONTH,GETUTCDATE()) and datepart(DAY,Birthday) = datepart(DAY,GETUTCDATE())
end



Dear HERR (ну очень точное определение этого индивидуума) tha_watcha ! How do you test your code before committing it in to repository?
mir scheissegal
Sponsor

tha_watcha
  • tha_watcha
  • 100% (Exalted)
  • YAF.NET Project Lead 🤴 YAF Version: 3.0.3
12 years ago
Code has been removed. Sorry i should have tested this under a portal.
bbobb
  • bbobb
  • 100% (Exalted)
  • YAF Developer
12 years ago
Hey, balbes, let's go without curses - the feature can be disabled. It's a sort of test feature in svn beta version there will be a universal solution.
Jaben
  • Jaben
  • 100% (Exalted)
  • YAF Developer
12 years ago
Originally Posted by: bbobb 

Hey, balbes, let's go without curses - the feature can be disabled. It's a sort of test feature in svn beta version there will be a universal solution.



Agreed. We all make mistakes sometimes.

But also note that we can all do more/better testing (myself included).
YAF Logo Copyright © YetAnotherForum.NET & Ingo Herbote. All rights reserved
About Us

The YAF.NET is an open source .NET forum project. YAF.NET is supported by an team of international developers who are build community by building community software.

Powered by Resharper Donate with PayPal button