nastanford

<!--- All methods in this helper will be available in all handlers,plugins,views & layouts --->
<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

/**
 * @accessors true
 * @output "no"
*/
component  displayname="Artist" hint="Artist"
{
	property name="artistid" type="numeric" displayname="ArtistID" hint="ArtistID";
	property name="firstname" type="string" displayname="First Name" hint="First Name";
	property name="lastname" type="string" displayname="Last Name" hint="Last Name";
	property name="address" type="string" displayname="Address" hint="Address";

nastanford

<cfsetting showdebugoutput="false">

Data Example

<cfdump var="#form#">

nastanford

u = window.location.href;t1 = u.indexOf("?");q="?";a="&";d="cfdebug=1";if(t1<=0){r=u.concat(q,d)}else{r=u.concat(a,d)};window.location=r;

nastanford

<cfoutput>
	<cfset thedate = '2014-10-30 00:00:00.0'>
	Exam Date: 
		#DateFormat(examdate,'mm/dd/yyyy')#<br />
	Today's Date: 
		#DateFormat(now(),'mm/dd/yyyy')#<br />
	DateDiff: 
		#DateDiff('d',CreateDate(year(now()),month(now()),Day(now())),DateFormat(CreateDate(year(thedate), month(thedate), Day(thedate)),'mm/dd/yyyy'))#
	<br />

nastanford

<!--- Example. --->	
<cfset this.mappings["/model"]="C:\wwwroot\fv\model">	
<cfset structAppend(url,createObject( "component", "model.udf" )) />

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]#" />