I need to find out if a certain record ID occurs more than once. What SQL code should I use to count the ID field if it occurs more than once (and output the occurrences)?
Thanks :) == Peter Tilbrook ([EMAIL PROTECTED]) Macromedia ColdFusion Applications Developer Cubok Pty. Ltd. Units 7-10 Australian Heritage Village Watson ACT 2602 AUSTRALIA http://www.cubok.com Mobile: 0401 973 415 Tel: +61-2-6262-4080 Fax: +61-2-6262-4081 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
