| ← Декабрь 2010 → | ||||||
|
2
|
4
|
5
|
||||
|---|---|---|---|---|---|---|
|
7
|
9
|
11
|
12
|
|||
|
14
|
16
|
18
|
19
|
|||
|
21
|
23
|
25
|
26
|
|||
|
28
|
30
|
|||||
За последние 60 дней 2 выпусков (1-2 раза в 2 месяца)
Сайт рассылки:
http://lotusnotes.wordpress.com
Открыта:
28-03-2008
Статистика
+1 за неделю
LO52840: SERVER SPATANEOUSLY RESTARTS
Рассылку ведет: Программист на Lotus NotesLotus CoderВыпуск No 424 от 2010-12-08
рассылка о программировании на Lotus Notes/Domino Обсуждения на форумах, блогах. Примеры программного кода на LotusScript,@formula, Java рассылка:выпускархивлентаблогсайт Бюллетень "Lotus Notes CodeStore" Выпуск 13 от 21.04.2008comp.soft.prog.lotuscodesrore
|
CodeStore. Примеры кодов
Форумы.Свежи темы и обсуждения
Tips. Советы
| Msg_ID | User_ID | Sent | Subject | Body |
| 1 | 1 | 2010-12-07 12:34:56 | First test | This is a test |
| 2 | 1 | 2010-12-07 12:36:12 | Second test | This is another test |
There's then a table called "Replies" which looks like this:
| Reply_ID | Msg_ID | User_ID | Sent | Body |
| 1 | 1 | 2 | 2010-12-07 12:35:12 | This is a reply. Seems to work. |
| 2 | 2 | 2 | 2010-12-07 12:38:45 | This is another reply. Got your second message too |
| 3 | 2 | 1 | 2010-12-07 12:40:54 | Cool. Glad I could help. |
As you can see. The Replies table is tied back to the Message table via the Msg_ID foreign key. All very straightforward. Notice, however, that the replies don't have their own subject, but the Inbox we're creating will need one.
The problem, for me anyway, was working out how to display an Inbox to the Administrators.
The Inbox for the normal users was easy. They only ever see replies (this isn't the "Sent" folder after all) and so a simple SQL SELECT on the Replies table covered that.
Administrators need to see both the main messages and the replies too. They should be displayed in a time-ordered way, like this:
| Sent | Subject | From |
| 2010-12-07 12:40:54 | Re: Second test | User One |
| 2010-12-07 12:38:45 | Re: Second test | Admin Two |
| 2010-12-07 12:36:12 | Second test | User One |
| 2010-12-07 12:35:12 | Re: First test | Admin Two |
| 2010-12-07 12:34:56 | First test | User One |
Knowing no better I tackled this by trying to JOIN the two table together using the Msg_ID foreign key. The trouble with that (as will be very obvious to most of you) is that the matching rows get joined in to one row. So, any Message that has a Reply will only appear in the inbox once - as the Reply. The message itself won't appear - which isn't how you'd expect an inbox to behave.
After much head scratching and fruitless Googling I found the solution. It has to use a UNION of two SELECT statements. Seems so obvious now. It's just been so long since I covered the very basics of SQL that I'd forgotten there was anything other than JOINs.
So, here's what the SQL looks like:
SELECT Msg_ID, NULL as Reply_ID, Sent, Subject, (SELECT Users.FullName as [SentBy] FROM Users WHERE Users.User_ID = Message.User_ID) FROM Messages UNION SELECT Msg_ID, Reply_ID, Sent, 'Re: '+(SELECT Subject FROM Messages WHERE Msg_ID = Replies.Msg_ID) as Subject, (SELECT Users.FullName as [SentBy] FROM Users WHERE Users.User_ID = Replies.User_ID) FROM Replies ORDER BY Sent DESC;
My quest to master SQL continues. Perhaps I need to take a step back and master the very basics first...
DominoPower contributor Vlad Tankhimovich brought the strange story of Domino 8.5.2 Interim Fix 2 (IF2) to our attention and it's a weird one.
IF2 was supposed to fix a bunch of Domino annoyances, in particular out-of-memory HTTP crashes. Always good to fix those.
As it turns out, Vlad installed IF2 and instead of getting better performance, he started getting all sorts of new problems. These included MIME content moved to attachments, HTML code in message body, and Blackberry messages not showing message body.
Oops. Once he removed IF2, everything went back to normal.
So, here's where it gets weird. A day or so later, IF2 was removed from the support portal. Then, later IF2 was put back on the support portal, but with a whole new set of hotfix numbers.
Frankly, it would have made everyone's life easier if the newly replaced update had been called IF2a or IF3, but that's sadly not the way it worked out.
In any case, if you're using IF2, be sure it's the new IF2.
Good luck and you all be safe out there, okay?
Joe is a ZATZ associate editor. Prior to this job, he was customer support manager for the FileFlex database engine.
Блоги. Что обсуждают и пишут
Tags: symphony graphics clip art
Idea:
Tags: eml export import
Idea:
Tags: travel time calendar
Idea:
Статьи и Документация
| Ссылки | Утилиты и программы | Сайты о Lotus Notes |
| В избранное | ||
