http://coldfusion.com logo
Join Slack
Powered by
First time using query of queries on lucee. ```var...
# lucee
d
First time using query of queries on lucee.
Copy code
var qry = queryExecute("update tags set path = :path where id = :id",{path:path, id:id}, {dbtype:"query"});
Error in thread.
message has been deleted
b
you can't update in qoq
never have in adobe either
only selects
d
oh that sucks
b
use qry.map()
d
ah nice thank you
s
i never would have thought to do an update/insert, though maybe a delete
d
lol
b
The interesting thing is it wouldn't be too hard to implement 
update
in Lucee's QoQ. Now that I know how it all works, lol
If any one wants to sponsor it, let me know 😆
d
lol
s
before you know it it will have a flag 
persist=true
and it will add the qoq table to a file and now you have CFSQLite
💥 2
d
I'm glad to have sparked some innovation lol
b
I'm never at a lack of ideas of fun things to do with QoQ
Though, usually all I hear is "WhY aRe YoU sTiLl uSiNg QoQ?? does it suck???" 😆
d
You're article on qoq performance for lucee inspired me to look into qoq. I swear I have avoived qoq like the plague.
👍 1
b
Cool. Here's that link for anyone who hasn't seen it 😉 https://www.codersrevolution.com/blog/improving-lucees-qoq-support-again-now-200-faster
👍🏼 1
d
i want to learn qoq to use it like python devs use defaultdict() aka a dictionary.
I don't know how else I could accomplish a "dictionary" in cfml
b
It's just a struct, lol
👍🏼 1
👍 1
Don't overcomplicate it
Just because other languages do 🙂
A dictionary is just a key/value store
Early versions of ColdBox had a Dictionary class (modeled off the Java design pattern) until I harassed Luis to just replace it with a struct
2 Views
Open in Slack
PreviousNext
Powered by