kamesh
07-20-2007, 11:20 AM
Hi
im using an mySQL query on one of our web pages and im getting an error.
the query is pulling in records and converting the date.
sql:
SELECT date_format(pressDate,'%d/%m/%Y') AS f_date,rssDesc,pressSubject,pressStory
FROM tbPress
WHERE pressID = colname
ORDER BY pressDate desc
the error we're getting is:
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'LIMIT 18446744073709551615' at line 1
does anyone know what the problem could be?
thanks in advance
im using an mySQL query on one of our web pages and im getting an error.
the query is pulling in records and converting the date.
sql:
SELECT date_format(pressDate,'%d/%m/%Y') AS f_date,rssDesc,pressSubject,pressStory
FROM tbPress
WHERE pressID = colname
ORDER BY pressDate desc
the error we're getting is:
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'LIMIT 18446744073709551615' at line 1
does anyone know what the problem could be?
thanks in advance