Here's a question for everyone out there.
I created a query:
WHERE companyId = #url.companyId#
Then without really thinking tried to set some new variables so my page wouldn't error out:
<cfset companyInfo.newVariableTwo = "">
I did a CFDUMP of companyInfo, and it dumps the query result without the additional variables. What exactly happened to the new variables? If I try to declare the structure with a StructNew() it overwrites the query.
Now before anyone gets anxious, I realize you can't set a static variable like this into a complex object type, especially a query. I'd have to create the new column in the query, and specify what row this value is for, and blah blah blah.
I'm just curious if anyone knows how Coldfusion handles this situation, and how I would retrieve a static value set like this. Thanks.