Good question. [] are CF constructs. These two are equivalent:
FORM.someVar = 101 and FORM["someVar"] = 101 You'd use the latter for dynamic variable names: FORM["someVar" & i] Deffo use cfqps, have a look back in the cf-talk archives to see a bunch of trouble caused by the lack of them in SQL statements. Also take note of Mark's post, the fact you're creating column names dynamically will also be a problem, one that cfqp can't solve. Adrian -----Original Message----- From: David Moore, Jr. [mailto:[EMAIL PROTECTED] Sent: 10 September 2008 15:44 To: CF-Talk Subject: RE: How NOT to Evaluate (moved from cfset so not to confuse topic) Adrian Wrote: > SELECT *> FROM Contacts> WHERE Contacts.ContactType = 'Physician'> AND Contacts.#FORM.Field# = '#FORM[FORM.Field]#'> ORDER BY Contacts.LastName What is the [] for. How would they be used. I have never used them at all. What is the protocal. Is that CF or SQL or... > And then throw in some cfqueryparams. I am just starting to write in the cfqueryparams. That is a new one too. ~David ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:312311 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
