Best of Talk (05/25/04)

 
Jun 02, 2004

by Dina Hess

Title: Date Bug in CFWDDX
Date: 05/25/04      (3 Posts)
Summary: Bug alert! If you use CFWDDX to convert CFML to JavaScript, be aware that date timestamps lose AM/PM distinction.
 
Title: CFQUERYPARAM
Date: 05/25/04      (9 Posts)
Summary: Trying to escape pound signs (#) in a string before sending to the database via CFQUERYPARAM?
<cfset str = replace(str, chr(35), chr(35) & chr(35),"all")>
*** OR ***
<cfset str = replace(str,"##","####","all")>
 
Title: DateDiff() to Determine Number of Weekdays Past?
Date: 05/25/04      (9 Posts)
Summary: Need to determine the third weekday after a given date? When attempts to use DateDiff() with a "w" (weekday) parameter don't produce the desired result, Pascal Peters provides a custom UDF.
 
Title: Oracle Unique ID or Identity
Date: 05/25/04      (23 Posts)
Summary: To automatically increment a primary key field in Oracle, create a SEQUENCE, like this:
CREATE SEQUENCE uniqueNum_s
START WITH 1
INCREMENT BY 1;

Then insert the value as follows:

INSERT INTO your_table (ID, ...)
VALUES (uniqueNum_s.NEXTVAL, ...)
Note that you can also use a SEQUENCE to access previous and current values with PREVVAL and CURRVAL, respectively. See Oracle 9i online documentation for further details.
 

Add a Comment
(If you subscribe, any new posts to this thread will be sent to your email address.)
  
Privacy | FAQ | Site Map | About | Guidelines | Contact | Advertising | What is ColdFusion?
House of Fusion | ColdFusion Jobs | Blog of Fusion | AHP Hosting