sql count function for duplicate rows inserted into dreamweaver

I need to Identify the unique rows and put the number of times they are duplicated next to them.
I have tried the following from your existing response to another fellow:

SELECT cust_name, COUNT(*) AS count_name
FROM sometable
GROUP BY cust_name
HAVING COUNT (*) > 1

I tried putting this into a recordset with Dreamweaver and it chokes.
Any ideas?
Thanks
kermodieAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

sdstuberCommented:
I suggest cross-posting this to a dreamweaver zone.

Your sql statement is correct syntax for all of the major databases.

So either your "choke" is something trivial like a misspelled column or table name

or it's a dreamweaver problem
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
sdstuberCommented:
glad I could help, could you post what it was that helped you?
0
kermodieAuthor Commented:
This is my first request for support.
It did not really help other than redirect my query to another area and I don't have the energy to pursue it here.  I was hoping somebody with dreamweaver experience might have picked out what isn't working.
0
sdstuberCommented:
oh, I was just suggesting adding it as an additonal zone, but ok.
0
sdstuberCommented:
good luck
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Query Syntax

From novice to tech pro — start learning today.