Suggestion for Calendar stored procedures

This forum is only for questions or discussions about working with the mojoPortal source code in Visual Studio, obtaining the source code from the repository, developing custom features, etc. If your question is not along these lines this is not the right forum. Please try to post your question in the appropriate forum.

Please do not post questions about design, CSS, or skinning here. Use the Help With Skins Forum for those questions.

This forum is for discussing mojoPortal development

You can monitor commits to the repository from this page. We also recommend developers to subscribe to email notifications in the developer forum as occasionally important things are announced.

Before posting questions here you might want to review the developer documentation.

Do not post questions about design, CSS, or skinning here. Use the Help With Skins Forum for those questions.

This thread is closed to new posts. You must sign in to post in the forums.

9/21/2015 3:12:33 AM

Chris Quinn

Total Posts 66

View Posts

Suggestion for Calendar stored procedures

I have a site where I have multiple events taking place on the same date at the same time, and have noticed that there seems to be no logical order in which the events are displayed. I tried setting the StartTime to different times ( a few minutes apart), but this was still not guaranteed to work. Looking at the Calendar stored procedures ( mp_CalendarEvents_SelectByPage, mp_CalendarEvents_SelectByDate) I found that one had no sort, and the other sorted by [EventDate], Datepart(hh,[StartTime]) which would not help if the events all start within the same hour's range.

I have changed these to sort by EventDate, convert(time,starttime),[Title] which gives me the results I want and seems a bit more logical.

Could I suggest this for future releases?

You must sign in to post in the forums. This thread is closed to new posts.