Syntax for SQL Query - used to work with Access

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: ADO

Freelance Help Sought

. There'd be some (reasonable -- 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 Creat

SQL Query Syntax Error

n give me... Best wishes Trevor Sather

Default Datetime?

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 I

RE: Help with Date Range Query

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

Help with Date Range Query

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())