YAFLogo

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

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: 4.0.0 rc 2
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

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.

Originally Posted by: bbobb 

Agreed. We all make mistakes sometimes.

But also note that we can all do more/better testing (myself included).