I want to limit my client to creating ten records. Once they have created ten records I will hide the insert form.

I tried using count() and limiting count but that dosen't work. CAn anyone point e in the right direction?

Thanks

Nick

I should add that if the have ten record thenI would let them delete ont if they wanted to add another.

by un-hiding the delete form?

the mere fact that you are implementing some logic (hiding) in the application code suggests that you could easily handle the 10-row limit there as well

just do a SELECT COUNT(*) before deciding whether to hide or show the insert form

I've over simplified what I'm trying to do.
I wan the query to return nothing if the count is greater then 10 OR only return results if there are ten or more records.

This dosn't work of course:

SELECT COUNT(*) AS C
FROM image_img
WHERE C>10

Nick

but those two options are diammetrically opposite to each other

let's try the first one

The recordset still has one record "NULL". What I need to an empty recordset if they have 10 records, If they have fewer than ten then return *


SELECT CASE WHEN COUNT(*) >10
THEN NULL
ELSE COUNT(*) END AS thecount
FROM image_img

WHERE artist_img=101


Thanks

Nick

Beautiful! Thanks very much