Dear list,
Happy Easter if anyone else is working. This statement is returning a
syntax error when I insert the WHERE line:
--
SELECT
tasks.task_id,
tasks.name AS taskname,
tasks.deadline,
tasks.project_id,
t
On 31 Jan 2005, at 11:39 pm, Tom Crimmins wrote:
I think datediff only takes two arguments and you have three listed.
Nailed it! Thanks, Tom.
Best regards,
CK.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Thanks very much for the replies, guys. My version is "4.1.7-max".
The error message I get is:
--
Error Executing Database Query.
Syntax error or access violation: You have an error in your SQL syntax;
check the manual that corresponds to your MySQL server version for the
right syntax to use nea
Dear list,
My ColdFusion server tells me I have an error in my query syntax, but I
can't work out what it is - because I'm working with code that someone
very kindly gave me and I only have a vague idea of what the first
line's doing! Can anyone see the problem here?
SELECT DATEDIFF(leadtime_t
Dear list,
Quick question. What's a reasonable length for a notes-type field? I
couldn't really find any guidelines on the web so I'm thinking of just
setting it to 65,535. Or is that ridiculously long?
Thanks list,
CK.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/m
Rhino wrote:
The primary key for the intersection table is the COMBINATION of EmpID
and
ProjID! Neither column by itself would make sense as the primary key
of the
table; the EmpID and ProjID need to be combined to form the primary
key. It
is now possible to store as many projects for an employe
Hola list,
Many thanks to all those who helped with my question about the schema.
Your kindness is sincerely appreciated.
I need to store passwords in my database, and I understand it's bad
form to store them anywhere in a readable format (I remember reading
once that if you call a company and
ers) two tables:
"people" and "projects". I want each project to have a list of people
that are authorised to view it. To my mind, the field ought to look a
bit like this:
--
Authorised list:
Chris Kavanagh
Joe Schmoe
Jane Doe
--
But fields can't ho
