Pages
Categories
Archive
Keywords
Calendar
<<  September 2010  >>
MoTuWeThFrSaSu
303112345
6789101112
13141516171819
20212223242526
27282930123
45678910
Blogroll

Avoid Evaluate() in ColdFusion because its slower

dasignz , Posted August, 20 2009, 12:05 PM
Recently I have come to realize that the evaluate() function in coldfusion can be slow.  So the best this to do to avoid this is to evaluate it as a struct variable. For example, if you have 3 form variables with counter numbers, and you want to loop through them and pull the data from e... [More]

Be the first to rate this post

  • Currently 0/5 Stars.
  • 1
  • 2
  • 3
  • 4
  • 5
Tags: , , ,

Category: Coldfusion
E-mail   |   Comments (0)   |   Trackback

Using CFQUERYPARAM to create quotes on a list for an IN operator within SQL

dasignz , Posted August, 12 2009, 07:34 AM
I have found that when you are trying to use a string list variable in an IN operator of a SQL query, it can sometimes be difficult.  The IN operator requires a list to have single quotes around each list item, if they are strings, in order for the query to process correctly.  There are ... [More]

Currently rated 5.0 by 3 people

  • Currently 5/5 Stars.
  • 1
  • 2
  • 3
  • 4
  • 5
Tags: , , , , , ,

Category: Coldfusion
E-mail   |   Comments (0)   |   Trackback

Get an ID of record after a SQL insert using ColdFusion

dasignz , Posted August, 11 2009, 01:29 PM
When you want to get an ID field of a record that was just inserted, you have to use the code below in ColdFusion.  First you "SET NOCOUNT ON" and process your insert statement.  After the insert, use a select statement like the following "SELECT @@IDENTITY AS varname".... [More]

Be the first to rate this post

  • Currently 0/5 Stars.
  • 1
  • 2
  • 3
  • 4
  • 5
Tags: , , , ,

Category: Coldfusion
E-mail   |   Comments (0)   |   Trackback