В Сбт, 29.05.2004, в 12:38, Aaron Stone пишет:
> These should actually be inserted via snprintf using constants. Someone posted
> about their definitions recently, but I can't find them in the code...
>
> Aaron
>
[EMAIL PROTECTED] dbmail]$ cvs -z3 update -A db.c|cat db.c|egrep
'(001|002|003)'
"AND msg.status < 002 "
"message_idnr='%llu' AND status<002",
to status >= 002, the quotum has to be recalculated */
"UPDATE messages SET status = '003' WHERE status =
'002'");
"SELECT message_idnr FROM messages WHERE
status='003'");
* this also means that the status will be set to '001'
"recent_flag) VALUES ('%llu', '%llu', '', '001', '1')",
"AND msg.status < '002' "
"AND msg.status < '002'", mailbox_idnr);
"UPDATE messages SET status='002' "
"AND deleted_flag='1' AND status < '002'",
mailbox_idnr);
"AND status< '002' AND unique_id!=''", msg_idnr,
>
> Anton Nekhoroshih <[EMAIL PROTECTED]> said:
>
> > Hi All!
> >
> > It is now used statuses: 001, 002, 003
> > Logically that it corresponds: 1, 2, 3
> >
> > But me personally and db oracle it is not clear why it is used 001,
> > instead of 1 and ....?
> >
> > In oracle '001' not equal '1' and .... !!!
> >
> > Besides a field status numerical if you want where or to output numbers
> > with zero that look 'man printf' !!!
> >
> > Personally for myself I in db.c all zero have removed also all works
> > correctly.
> >
> >
> >
> >
> >
> > _______________________________________________
> > Dbmail-dev mailing list
> > Dbmail-dev@dbmail.org
> > http://twister.fastxs.net/mailman/listinfo/dbmail-dev
> >
>
>
