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

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

CFLOOP Vs. CFOUTPUT with a query attribute

dasignz , Posted August, 19 2008, 09:02 AM
When I was a noob (new user) to coldfusion, I racked my brain, and spent countless hours trying to figure out when to use which.  So after speaking to many developers, and doing countless tests of my own, I will give you my take.  Hopefully you will find this information useful, and if y... [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