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>

nastanford

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

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

<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

<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

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

nastanford

<cffunction name="querytoarray" returntype="array" output="No"> 
 <cfargument name="q" required="Yes" type="query"> 
 <cfset var aTmp = arraynew(1)> 
  
 <cfif q.recordcount> 
  <cfloop query="q"> 
   <cfset stTmp = structNew()> 
   <cfloop list="#lcase(q.columnlist)#" index="col"> 
    <cfset stTmp[col] = q[col][currentRow]> 
   </cfloop> 

nastanford

function getSelectedText(){    
  var e = document.getElementById("nameSelect");
  var dspText = e.options[e.selectedIndex].text;
  return dspText;
}

nastanford

	<base href="#getSetting('htmlbaseURL')#"/>
    <link href="#getSetting('htmlbaseURL')#includes/styles/default.css" rel="stylesheet">

nastanford

<cfcomponent output="false" hint="My App Configuration">
<cfscript>
/**
structures/arrays to create for configuration

- coldbox (struct)
- settings (struct)
- conventions (struct)
- environments (struct)
- ioc (struct)