Hi
This query used to work with an Access database:
SELECT *, (SELECT COUNT (*) FROM Links WHERE Links.CAT_ID =
Categories.CAT_ID AND LINK_APPROVED = 'Yes') AS LINK_COUNT FROM
Categories ORDER BY CAT_NAME ASC
Now that we've upgraded to MySQL, the same ASP script returns this
error:
-- the
client is a charity) remuneration.
If you're interested, please drop me an e-mail letting me know who you are!
Many thanks if you're able to lend a hand!
Best wishes
(unsubscribing from list now)
_
Trevor Sather
Creative Director
Square Eye Ltd
22-24 Monmouth Rd
Trevor Sather
Hello
I have a table for messages, and when a new message is inserted I want the
current date and time to be inserted into the MessageDated and MessageTimed
fields. I'm using MySQL 3.23.56 (?), with Chilisoft ASP, and using the
MySQL Control Center interface.
The problem is that no matter what
Hello,
Any idea why the following doesn't work? It's taken from the MySQL manual
which says it should return records in the last 30 days. As you can see,
I'm getting records spanning some 19 months from last May to December
2004...
mysql SELECT StartDate FROM Events
- WHERE TO_DAYS(NOW())
Thanks very much (to all who replied) -- this looks good!
Best wishes
-Original Message-
From: Paul DuBois [mailto:[EMAIL PROTECTED]
Sent: 06 June 2003 20:46
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: Re: Help with Date Range Query
At 20:34 +0100 6/6/03, Trevor Sather wrote