Best of Talk (5/2/03)

 
May 02, 2003
by Dina Hess

Title: Deleting List Values
Date: 05/02/03      9 Posts
Summary: Need to delete records based on a list of values returned in a form's checkbox field? 

   DELETE FROM myTable 
   WHERE myField IN (0#FORM.formfield#)
The zero keeps the query from breaking if the list is empty. Caveat: This code breaks ORACLE if the list contains more than 1,000 values.
 
Title: HTML2PDF
Date: 05/02/03      23 Posts
Summary: Several developers compare notes about their experiences installing and configuring HTML2PDF, which is used as a custom tag and was recently highlighted in CFDJ. Note that the .EXE download is a compressed file that must be decompressed for the tag to work.
 
Title: Locking Issues and CFCs
Date: 05/02/03      9 Posts
Summary: In this excellent thread, CF experts discuss several advantages to storing queries in persistent CFCs, such as having all of the SQL in one place and being able to easily purge a single cached query. And since persistent CFCs are thread-safe, it is unnecessary to lock when writing to variables.

 

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