Interesting…
What version of the Dev Studio?
Steps…
- I opened a search action
- Selecte “Summary of
Groups” under Select Type
- dragged in State column in to “Group
By Columns and left the function as NONE
- dragged in City column in to “Group
By Columns and left the function as NONE
- dragged in ID column in to “Group
By Columns and Changed the function to COUNT
- right clicked on search action
and view SQL Statement
SELECT C1.State,C1.City,COUNT(DISTINCT
C1.ID) AS COUNT_ID FROM "Client Table" C1 GROUP BY C1.State,C1.City
I am wondering the exact sequence you just
attempted???
If you can reproduce the steps I would
submit it to Witango.com
-----Original Message-----
From: Bryan Hughes
[mailto:[EMAIL PROTECTED]
Sent: Tuesday, July 29, 2003 12:20
PM
To: [EMAIL PROTECTED]
Subject: Witango-Talk: Search
Action Summaries
I'm using a search action to do a count on rows by group. I add the
field I'm counting and then add the fields I want to group by.
On every new field I drag in, a distinct clause is prepended to the SQL
statement.
The query ends up being something like
SELECT s1.state,s1.city,COUNT(DISTINCT
.DISTINCT .DISTINCT .DISTINCT .DISTINCT s1._rowid) AS COUNT__rowid FROM
student_roster s1 GROUP BY s1.state,s1.city ORDER BY 1 ASC,2 ASC
And on execution returns...
Error
An
error occurred while processing your request:
File: index.taf
Position: Search_report
Class: DBMS
Main Error Number: 1064
[MySQL][ODBC 3.51
Driver][mysqld-4.0.12-nt]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
'DISTINCT .DISTINCT .DISTINCT s1._rowid) FROM student_roster s1
37000
This happens in summary of groups and summary of all rows.
Is this normal behavior or should this be submitted as a bug?
Witango 5.0.9
