Best of Talk (4/25/03)

 
May 02, 2003
by Dina Hess

Title: Best Pratice FB3 Question
Date: 04/25/03      15 Posts
Summary: Get advice about adding "admin" functionality and security to a Fusebox 3 application. The Model-View-Controller (MVC) framework is also mentioned.
 
Title: Keeping up with CFFlush
Date: 04/25/03      8 Posts
Summary: You can use JavaScript with URL fragments to move focus to the bottom of a long page load that is displayed with CFFLUSH. Several code snippets are provided.
 
Title: mySQL Backups
Date: 04/25/03      7 Posts
Summary: How can you schedule backups of a mySQL database on a shared Windows host? The best approach would be to set up a replication slave in a different location for real-time backups. Barring that, you could try mysqldump or mysqlhotcopy and use WinCron for scheduling.
 
Title: Query Recordsets Aren't Structures?
Date: 04/25/03      31 Posts
Summary: Query recordsets are not structures. They are more like a structure of arrays. In fact, you can display recordset data without knowing the column names using syntax like this: 

   <cfoutput query="q">
      <cfloop index="col" list="#q.columnList#">
         #q[col][currentRow]#
      </cfloop>
      <p>
   </cfoutput>
You can also use QueryAddRow() and QuerySetCell() to add data to an existing recordset. To transfer recordset data into a structure of arrays, try the QueryToArrayOfStructures() UDF available at cflib.org. Use ORDER BY if the order of the recordset is important. An in-depth discussion of row order is included.
 
Title: Tricky?
Date: 04/25/03      7 Posts
Summary: Looking for a query to join "employee" and "mail" tables to return all employees and a count of their unread messages? This thread provides the solution with a query that makes use of LEFT JOIN and COUNT() to return the desired recordset.
 

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