Here are some things you may need to know. Check out the link posted at the cfbuilder blog. http://blogs.adobe.com/cfbuilder/2010/03/things_to_watch_out_while_inst.html Share on Facebook Share on Linkedin Tweet about it Print for later Tell a friend
Posts Tagged: ColdFusion
Avoid Evaluate() in ColdFusion because its slower
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… Read more »
Using CFQUERYPARAM to create quotes on a list for an IN operator within SQL
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… Read more »
Get an ID of record after a SQL insert using ColdFusion
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". After this you can "SET NOCOUNT OFF". … Read more »
ColdFusion Verity Document Search Limit
Okay, so I don’t know how relevant this question really is, but I have been questioning something about Verity in ColdFusion. For you noobs out there, verity is a search server that comes as part of the package, you have the ability to not install the search server on setup though. Basically, verity indexes data,… Read more »