Best of Talk (4/11/03)

 
May 02, 2003
by Dina Hess

Title: CFSQLTYPE
Date: 04/11/03      14 Posts
Summary: Within CFQUERYPARAM, MS Access "Yes/No" datatypes should be referenced as CFSQLType="CF_SQL_BIT."
 
Title: Dynamic Radio Button Submission
Date: 04/11/03      9 Posts
Summary: Need to update the status field of a database table based on a dynamically-created radio button selection? An efficient way to approach this problem is to set the NAME attribute of each INPUT TYPE="radio" button to the status (i.e., approved, declined, reopen) and set the VALUE attribute to the table record's identifying field. You can then loop over the "status" list on the action page to do the update.
 
Title: Mail Help
Date: 04/11/03      5 Posts
Summary: Set CFMAILPARAM's NAME attribute to "return-path" to bounce an email back to the original sender's account. Check the RFC at http://www.ietf.org/rfc/rfc2076.txt for a list of available mail parameters.
 
Title: New Line in ColdFusion Strings
Date: 04/11/03      12 Posts
Summary: To add a line break within a concatenated series of substrings, use any one of the following solutions:
  1. <br />
  2. <cfoutput>#chr(13)##chr(10)#</cfoutput>
  3. <cfset lb = chr(13) & chr(10)> <cfoutput>#lb#</cfoutput>
Note that the character representation for a new line is dependent on the operating system in use on the server:
  • Windows (\r\n): #chr(13)##chr(10)#
  • Unix (\n): #chr(10)#
  • MacOS 9 and earlier (\r): #chr(13)#
 

Privacy | FAQ | Site Map | About | Guidelines | Contact | Advertising | What is ColdFusion?
House of Fusion | ColdFusion Jobs | Blog of Fusion | AHP Hosting