[thelist] Coldfusion/SQL:queries:maxrows

[Simon Coggins]

> I'm getting an error - is "TOP" supported in MySQL?

I'm not sure, but can't you use LIMIT instead?

e.g. SELECT * FROM table WHERE this='that' ORDER BY this LIMIT 1

would return 1st record.

Simon