dbo.ui_listSubMenu_Sermon @TBL_NAME ='t_CD_Service',@Search_Key=''
dbo.ui_listSermon @SQLType = '1',@PageSize = 25,@NowPage = 1,@Search_Key=' AND ( contains(S.Title, ''"2013 Prayer Titles"'') or contains(S.SubTitle, ''"2013 Prayer Titles"'') ) AND ( (S.FileNum7 IS NOT NULL AND S.FileNum7 > 0) or (S.FileNum4 IS NOT NULL AND S.FileNum4 > 0) or (S.MsgNum=''1'') ) ' ,@CodeNum = 100 ,@Search_Order_Name='s_date' ,@Search_Order_Type='DOWN'
dbo.ui_listSermon @SQLType = '0',@PageSize = 25,@NowPage = 1,@Search_Key=' AND ( contains(S.Title, ''"2013 Prayer Titles"'') or contains(S.SubTitle, ''"2013 Prayer Titles"'') ) AND ( (S.FileNum7 IS NOT NULL AND S.FileNum7 > 0) or (S.FileNum4 IS NOT NULL AND S.FileNum4 > 0) or (S.MsgNum=''1'') ) ' ,@CodeNum = 100 ,@Search_Order_Name='s_date' ,@Search_Order_Type='DOWN'
dbo.ui_listSubMenu @TBL_NAME='t_CD_Service',@Search_Key = ' AND CodeNum = 100'