On 14.03.2008 00:55 CE(S)T, Rob Wultsch wrote:
I am guessing it is an issue with SearchRevision being an INTEGER,
and RevisionNumber being a SMALLINT.
Thank you, that was the problem. My design was incorrect anyway to use
different types here... Now that's fixed, too. :)
Hi, im having troubles with one query, hope someone can help.
on this table:
messages:
id_fromint(10)
id_toint(10)
textvarchar(1000)
time
with index on id_form and id_to
i want to get messages sent from one user to another and vice versa order by
time.
let say we want to search
On Sat, Mar 15, 2008 at 2:42 PM, Nacho Garcia [EMAIL PROTECTED] wrote:
Hi, im having troubles with one query, hope someone can help.
on this table:
messages:
id_fromint(10)
id_toint(10)
textvarchar(1000)
time
with index on id_form and id_to
i want to get messages
which method is better to do.
I have 5 tables. They represent sections/parts of a companies
standards. There are 13 main categories, each of those categories
has subsections (some with 3, some with 10 or more), those
subsections have subsections, etc.
Which table design is better to do.