@Mark Takata (Adobe) Is there any ETA on the vscode version of CFBuilder?

Is there anyone here familiar with using <br style="mso-data-placement:same-cell;" /> to prevent formatting in the data from creating new rows when dumping data into excel?

I'm setting up a test case to make sure it is actually the <br> tags in the data, then try just replacing the <br> or <br /> with <br style="mso-data-placement:same-cell;" /> that should eliminate the superfluous ones.

Sorry for off-topic, but hoping to get some impressions from anyone here who happens to read my blog (which is still reasonably on-topic for CFML I guess). Q: For the ppl here that read my blog... how have the lengths of these Kotlin musings I've been doing? Long / short / shrug / ?

OK new question. When running CF Server in an enterprise, why not use the built-in web server? Our ops connect CF to Apache. What is the benefit of doing it this way? Doesn’t it just complicate the setup?

You should just use commandbox for the simplest setup

@John Wilson Yes, but not an option here.

Care to explain? We have a number of commandbox servers running as services in both Linux and Windows. Fast, secure, stable and simple to setup and maintain

Enterprise policy

https://www.ortussolutions.com/blog/screencast-running-commandbox-servers-behind-iis-with-boncode?

I just ran a quick test using CF2021 connecting to UPS homepage (to a 302): CFX_HTTP5: 148ms; 91ms; 87ms CFHTTP: 497ms; 203ms; 189ms Microsoft homepage: 500 error using either method (weird) Accessing CFDOCS.org (200 OK): CFX: 81; 60; 27; 36; 24 CFHTTP: 73; 63; 75; 61; 55 It appears to still be faster. I like that it can ignore SSL errors and doesn't cache DNS lookups eternally. (This was causing a problem when using CFHTTP with cloud-based API servers with dynamic IP addresses.) Let me know if there's anything specific that you want compared.

haven't tried it yet and thought i'd ask in case anyone already tried, but what happens in a try/catch/finally if you rethrow the exception in the catch? will the finally code execute or be skipped? assuming skipped, but again haven't actually tried

I think I found a bug in serializeJSON(). We have an MSSQL db table with BIT columns, when I populate a coldfusion object with a property type of numeric or boolean, then create a memento structure from the properties of the object, then run serializeJSON on that structure, the first record will convert the columns that were of BIT in the db (but numeric or boolean in the object) to a string. All records after the first in the array convert the BIT columns to a non-quoted number. If I do a CAST AS INT on the BIT columns, then they all serialize properly as numbers. Is there something different about a struct key with a value from a BIT column? Its got me all confused.

A colleague says this:

I found a difference in CF2018 from CF9.
 
ListFind will not find a match in a list where the value starts or ends with a space.

CF9 : ListFind("A, B,C", "B") = true 
CF2018 : ListFind("A, B,C", "B") = false

(He doesn't really mean it returns true, just that it found the value in the list.) I thought listFind would only find exact matches, so leading or trailing spaces in either the find string or the list element that don't match would cause it not to be found, in every version. I don't have a cf9 server to verify that they used to be ignored. Does anyone? Or do you know about a change in this area?

This may not be a popular question but is there a version of the ColdFusion/Ajax Application wizard extension that works with CFBuilder 2018? or barring that an alternative that can create a skeleton CRUD admin based on a DB thru RDS?

writedump(xmlSearch(test, "allEnrollments/enrollment").map((enrollment) => enrollment.toString()).toList(""))

gives me output like

<?xml version="1.0" encoding="UTF-8"?><enrollment>...</enrollment><?xml version="1.0" encoding="UTF-8"?><enrollment>...</enrollment>

How do I get the same output without the

<?xml version="1.0" encoding="UTF-8"?>

XML declaration for each one? I just want the node itself, not each node as a full xml object.

Best CFML linting plugin for VSCode anyone?

Regex question: come all who are ready for a challenge! i need to be able to select this entire string skipping over escaped characters

'select *, 1 as ''top'', testCol as "top2" from mytable'

or

"select *, 1 as ""top"", testCol as 'top2' from mytable"

it also can have line breaks in it

"select *, 
        1 as ""top"", 
        testCol as 'top2' 
 from mytable"

I have tried googling it and creating a few additional solutions but none have proven to be the right solution. The reward for will be a new cfml vscode extension to format SQL syntax within cfc’s and cfm pages

Odd question. What would you think the cachedwithin attribute would be on an insert or update query?

@abram the CF2021 instance of trycf.com seems to have been down for a coupla days now.

Fun SAML issue. Everything is going swimmingly, until I use processSAMLResponse(). It throws an error The response was received at https://foo/SSO/index.cfm instead of https://foo/SSO/index.cfm?ssoid=12345. The IdP and SP are both configured properly, it's just that processSAMLResponse() is not taking the query string into account during verification. (apparently it uses getPageContext().getRequest().getRequestURL() ) Is there a way I can have it take the querystring into consideration? The query string is needed to determine which IdP/SP configurations to use.

is there a way to check if coldfusion has write access to a directory without actually making a file and checking for an exception?

Hi all. Getting back into CFML after a long break. I left just before Lucee became a thing. Seeing some names I recognise from a while back!

Looking to make some workspace upgrades, any ideas on tech and/or software that has been a great addition to your workspace?

Hey - I have a CF caching question - I have a table with 500k records in MS SQL, each of which has an ID (int) and 2 other identifiers that are both 6 -20 character varchar strings. Different components in the app are constantly converting between these IDs for different purposes - maybe 5 - 20 times/second. FWIW there are multiple server nodes in the cluster. The lookups from SQL are fast, but wondering if there is anything in the CF/Lucee caching arsenal that is an obvious fit for this - or if it's just too large of a dataset to bother caching.

This message was deleted.

QoQ not identifiable in debugging service's event table when datasource is set in application I just opened this ticket https://tracker.adobe.com/#/view/CF-4215317

Any suggestions for #Hacktoberfest this year? I was busy last year and didn't get a chance to join in.

using

EntityNew("name", struct)

it is easy to populate a new object and save it. Is there a way to do the same to an object that's been retrieved, and pass it a struct to update all fields as well, instead of having to write out the

set()

commands for each field to be updated?

i used the cfbuilder cfc generator for my tables but how should i use the bean, dao, gateway and service i need some guidance