What error do you get?
James Opere wrote:
> Hi All,
> I'm trying to pass variables from one form to the other.I have a problem
> when i want to do the the following:
> 1.COUNT($variable)
> 2.DISTINCT($variable)
> .
> I realise i can not use the brackets in my query and the variable b
Why do you need the group by clause? Do one or the other, not both.
either do a
select count(id) from table
or
select field, count(id) from table group by field
Check your query,
Nicole Amashta
www.aeontrek.com
James Opere wrote:
> Hi All,
> I'm trying to pass variables from
2 matches
Mail list logo