Marco Herrn wrote:


Currently I am trying to use the aggregate function count(), but don't know how to form the query. A normal select would be
"SELECT count(kontakt FROM de.devlogix.kontakt.data.Kontakt) kontakt".

I seems that I found the right form:
"SELECT count(*) FROM de.devlogix.kontakt.data.Kontakt kontakt".
Why do I have to use "*" instead of "kontakt"? In the first select I also want _all_ columns. And I get them. As you can see I am not yet very familiar with OQL....


But anyway, the above Query doesn't work. It returns 1, which isn't correct, since there are much more entries in the DB.

What is the problem here? Is the syntax still wrong?

Marco

----------------------------------------------------------- If you wish to unsubscribe from this mailing, send mail to
[EMAIL PROTECTED] with a subject of:
unsubscribe castor-dev


Reply via email to