nastanford

select column_name, count(column_name)
from table
group by column_name
having count (column_name) > 1;

nastanford

<script type="text/javascript">
<!--
    function toggle_visibility(id) {
       var e = document.getElementById(id);
       if(e.style.display == 'block')
          e.style.display = 'none';
       else
          e.style.display = 'block';
    }

nastanford

<cfloop index="thefield" list="#form.fieldnames#">
  <cfset fields="#thefield# = #form[thefield]#">
  <cfset fields="#thefield# = #evaluate(thefield)#">
  <cfoutput>#fields#</cfoutput><br>
</cfloop>

Example making the form fields into hidden Form Fields
<!--- ********************************************** --->
<cfloop index="thefield" list="#form.fieldnames#">
  <input type="hidden" name="#thefield#" value="#form[thefield]#" />

nastanford

<basefont face="arial" />
<CFSET REQUEST.DSN   = "yourdatasource" />
<CFSET REQUEST.OWNER = "owner" />

<CFQUERY NAME="tables" Datasource="#REQUEST.DSN#" >
  SELECT 		table_name  
	FROM 		all_tables 
	WHERE 		owner = '#REQUEST.OWNER#'
	ORDER BY 	TABLE_NAME	
</CFQUERY>

nastanford

Path in Explorer to SendTo:
%APPDATA%\Microsoft\Windows\SendTo

nastanford

<cfscript>
  // Alternating Row (classes, bgcolor, or any other alternating row useage)
  // example: alternatingRow(TheCurrentRowCount,EvenRowText,OddRowText)
  function alternatingRow(currentRow,evenRow,oddRow) {
    var returnVar = IIF(currentRow Mod 2, DE(evenrow), DE(oddrow));
    return returnVar;
  }
</cfscript>