Reset Password · YAF.NET Support Forum

Welcome Guest! To enable all features please Login or Register

Posted by: balbes - Sunday, 9 October 2011 12:39:35
[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 [/quote] Dear [color=red]HERR[/color] (ну очень точное определение этого индивидуума) [b]tha_watcha[/b] ! How do you test your code before committing it in to repository?

Posted by: balbes - Sunday, 9 October 2011 12:39:35

[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 [/quote] Dear [color=red]HERR[/color] (ну очень точное определение этого индивидуума) [b]tha_watcha[/b] ! How do you test your code before committing it in to repository?

Posted by: tha_watcha - Sunday, 9 October 2011 15:50:41
Code has been removed. Sorry i should have tested this under a portal.

Posted by: bbobb - Sunday, 9 October 2011 15:57:33
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.

Posted by: Jaben - Tuesday, 11 October 2011 02:56:19
[quote=bbobb;51415]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. [/quote] Agreed. We all make mistakes sometimes. But also note that we can all do more/better testing (myself included).

Important Information: