"John S. Gage" wrote:
> Is the *locked* status saved in the DB? As a field in the message record
> [what are the fields in the message record?] for example (perhaps the only
> example)?
mysql> describe Message;
+-----------------+--------------+------+-----+---------------------+-------+
| Field | Type | Null | Key | Default |
Extra |
+-----------------+--------------+------+-----+---------------------+-------+
| message_name | varchar(128) | | PRI |
| |
| repository_name | varchar(128) | | PRI |
| |
| message_state | varchar(30) | | |
| |
| error_message | varchar(200) | YES | | NULL
| |
| sender | varchar(100) | | |
| |
| recipients | text | | |
| |
| remote_host | varchar(100) | | |
| |
| remote_addr | varchar(20) | | |
| |
| message_body | longblob | | |
| |
| last_updated | datetime | | | 0000-00-00 00:00:00
| |
+-----------------+--------------+------+-----+---------------------+-------+
The answer would be "no".
> Off the top of my head, if you are retrieving "message records" from a
> database with a SELECT statement, as part of that SELECT statement you can
> include an ORDER BY clause:
>
> SELECT * FROM Messages ORDER BY Locked ASC
>
> to bring to the top of the return table the records you want. Or you could
> just include a WHERE clause.
>
> If the records *don't* include a "locked" field, it would be interesting to
> know why not if it is possible to find out the locked status once the
> messages are retrieved from the database.
The message gets sent, and the record would be deleted.
I think there'd be a problem if you had a "locked" field in the db; what
if a record was locked, and James got restarted (or the machine died and
assuming that the db was on a different machine). When James got
resurrected, the record would be still in the locked status; as if that
a thread had been sending it out, which in fact, none was. So the
message would stay on the db forever.
Oki
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
