As you wish! Here’s a little sneak preview into one of the collections coming up that I’m so excited about! Princess Bride is a complete source of nostalgia for me, as I grew up with my parents and even my uncle quoting it. Now my 11 loves it too! . #princessbride #cultclassics #moviebuffs #romanticmovies #vintagemovie #antiquestyle #cottagecoreaesthetic #princesscore #princesscoreaesthetic #robinwright #goodmovies #chickflicks #momentsoflove #simplelivinglifestyle #createarteveryday #watercolorart #realisticwatercolor #simplevalues #danielsmithwatercolors #proportionaldivider #artnerds #artsuppliesaddict https://www.instagram.com/p/CoDwMH4ujsP/?igshid=NGJjMDIxMWI=

Don’t Be Afraid To Change, You May Lose Something Good But You May Gain Something Better®🙏 #goodthing #photoshoot #photographytips #beachside #sea #sunsets #instalove #truth #awesomeday #alonelife #simplevalue #goodthoughtsonly https://www.instagram.com/p/BubS-JrAxD5/?utm_source=ig_tumblr_share&igshid=duqwv8gktsfz

When is a ColdFusion SimpleValue not a SimpleValue?

Answer:  When it’s a “QueryColumn”.

I was dumping a ColdFusion struct using a new CFDumpLite custom tag/UDF that I’m developing and I came across an issue that had been causing me a problem for a while.  I was looping over SQL query column names to auto-generate a struct.  The code looked something like this:

<CFSET MyStruct = StructNew()> <CFLOOP LIST="#myQuery.ColumnList#" INDEX="thisColumn">     <CFSET MyStruct[thisColumn] = myQuery[thisColumn]> </CFLOOP>

NOTE:  Apparently Adobe added their own QueryGetRow() function that mimics this behavior in CF11.

When dumped using CFDump, it looked like regular keys and simple text values... but using isSimpleValue() would return “no” as the underlying data type was detected as “coldfusion.sql.QueryColumn“.  (I identified this by outputting MyStruct[thisColumn].getClass().getName().toString(). Normally values are returned as java.lang.String, java.lang.Integer or java.sql.Date.

If I set the variables manually using dot notation, the values are detected as “simple strings”:

MyStrucy.Column1Name = myQuery.Column1Name

SOLUTION: In order to get the assignment via the loop to function as expected, I had to indicate that I wanted the result in the “first row”...

<CFSET MyStruct[thisColumn] = myQuery[thisColumn][1]>

The most frustrating thing is that I wasn’t able to initially determine why my script wasn’t working as expected.  It looked like a “simple value”, but ColdFusion refused to identify it as such.  It still looked like a simple value when using CFDump, but some validation I was using ignored the values because it was being detected as “QueryColumn” instead of string, integer, date, etc.

In 2015, I wrote a TypeOf() UDF to help identify CF data types, but I hadn’t identified and configured this datatype during my testing. I referred back to the UDF code for assistance and used getClass().getName() to compare the datatype differences, but since the variables were passed individually to the UDF, it wasn’t considered “QueryColumn” anymore and was detected as the simplier simple value data types.  (I was only able to determine this by directly outputting the getClass() result without using a UDF.)

So proud! 🥹 Finally got the new shop OPEN and synched with insta/fb. SO HARD. Now I’m adding products as fast as I can. My family’s help has been such a blessing... and it’s been a real whirlwind from losing my accounts, to starting all over, to now, getting this new shop live. I even had to register as a legit business with an LLC to do this when I wasn’t even sure about this new business name 🫤 But..Here goes! Haha! I’m working on what seems like 1000000 projects to go up in this baby all at once. Honestly I’m just having fun with it, because why not? This is my shop where my imagination can soar and I got past all the hurtles. Now it’s just up to me to put in the work! And I’m a hard worker 💪😁🎉 . This painting, entitled “Serene” is embracing the color blue as a physical method of finding calm and serenity. The color blue is proven to be a soothing color, at which our brains release a calming endorphin called “Serotonin”, as well as lower blood pressure and slow the heart rate down. I thought the image of an ocean and a dreamy dress was perfect way to capture that 😆😘 . . #cottagelife #cottagecore #cottagecoreaesthetic #paintinglife #cottagecoreart #dreamyart #watercolorpractice #simplevalues #thecolorblue #colorlovers #princesscore #tinyhouseartist https://www.instagram.com/p/CoBntqMunFX/?igshid=NGJjMDIxMWI=