Best of Talk (Weekend, 4/26/03 - 4/27/03)

 
May 02, 2003
by Dina Hess

Title: Regex gurus
Date: 04/27/03      7 Posts
Summary: Need a regular expression to remove any characters in a string that are not standard characters? Try this:

   REreplace(string, '[^a-zA-Z0-9"<>=_/\\-]', "", "all")
 
Title: Format of Date Data type
Date: 04/26/03      9 Posts
Summary: To insert a date into an ODBC database, use #CreateODBCDate(theDate)#. Note that ColdFusion offers several functions to handle data for globalization.
Related: Newbie Question 2 and 3
 
Title: Great DB Schema Resource
Date: 04/26/03      1 Posts
Summary: Searching for a good resource to guide your design of a database schema? Take a look at Database Answers to choose from a wide selection of application models.
 
Title: INSERT and Get It's ID
Date: 04/26/03      17 Posts
Summary: Need to get the ID of a record after it has been inserted into Access? Since Access does not support ISOLATION="serializable," try using a named lock inside CFTRANSACTION tags to single-thread queries that INSERT and SELECT max(id) (or @@identity). But "the most universal, resource-unintensive method is to store a UUID, then query back for the UUID to get the ID number."
 

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