thanks @pothys-mitrahsoft for writing this up https://docs.lucee.org/guides/cookbooks/mail_listeners.html

is my usage of replace is right, asking all i am getting is 14 when i am running in the trycf my errorMsg is 14 and i want to check replace 14 with 11

<cfset Replacelist(Errormsg,'3,4,5,6,7,8,9,11,12,13,14,15,16,17,18','1,2,3,4,5,6,7,8,9,10,11,12,13,14,15')>

it seems its working but not displaying data https://trycf.com/gist/9c1c82b733e30dac122eb4dfb45dd6f4/acf2021?theme=monokai it seemsthe issue is with replacelist

Having just browsed to a .cfc file, I am seeing this:

To see details for this component you need to enable debug output

Two things: 1. why? 2. Um... if that means the debug settings in admin (

/lucee/admin/server.cfm?action=debugging.settings

and/or

/lucee/admin/web.cfm?action=debugging.settings

)... then... erm... they are all switched on. Does it mean something else?

(this is unrelated to my previous comment, although is still a question on the debug settings in Lucee admin). Having checked and saved all the options in the WEB admin, I then click "Reset to Server Administrator Setting" (NB: that should probably be plural: "settingS", it resets all the settings except "Template" which is still enabled. Presume this is a bug (had a look in Jira, couldn't see anything)

I see posts come up every 6 - 9 months on SQL Server data sources and windows authentication. Since windows auth is more secure, it would be my first choice - but TBH the only way I can get integrated auth to work is using the deprecated (in lucee admin) 'other JDBC' driver. Even though my 'other JDBC' driver connection string references SQL Server JDBC 8.4.1 {JRE8] under the covers when you look at the connection string in lucee-server.xml. Despite my preference to use windows auth, I also really don't want to implement a data source that is either deprecated for a good reason (might be no longer supported soon) or has material performance issues that will show up under heavy prod load. this thread - https://dev.lucee.org/t/using-a-windows-domain-account-in-a-lucee-ms-sql-datasource/4459 talks about hooking up a supported driver by editing the lucee-server.xml, but i could not get that to work under 8.4.1, on the latest release of lucee 5. Lastly - I think Zac said in March in a thread that windows auth is not supported...Not sure if he meant setting up via admin, or just meant.. 'stop using it at all, people' so bottom line - is anyone using window auth to SQL server in production reliably and are there valid reasons not to?

crud are useless if sql has been denied permissions from back-end

greeting Lucee-ites. I am having a very strange issue in Lucee, with MSSQL server, and using either the (deprecated) JDBC driver, or the Microsoft JDBC extension. (These appear to be the only two options). When retrieving a country from our

Countries

table, we have an NCHAR(2) field for isoAlpha2 country codes (e.g.,

US

or

DZ

or

EN

, etc.). However, when I select a single country using ORM (e.g.

c = EntityLoadByPK("Country", 220);

) the isoAlpha2 value comes back TRUNCATED to just a single letter (

U

or

D

or

E

). As mentioned, I've tried the (deprecated) JDBC driver that comes with Lucee as well as the Microsoft JDBC extension. This same select / retrieval works fine in the Adobe CF version of the app that we are migrating from. I have checked all the possible datasource settings, to no avail. Any advice on troubleshooting from here would be welcome.

mysql 8.0.30 extension published

incoming 5.3.10 RC1 today...............

Well done on the upcoming release, I think you're doing and awesome job, and I hope to work closer with lucee soon, I wonder if 6 is still not to far away ?

hopefully sooner than later, production stability (aka with 5.3) is our primary goal, now that 5.3.10 is pretty much done n dusted, assuming we have no further problems, our focus switches back to 6.0. All the fixes in 5.3.10 are also going into 6 as well

5.3.10.79-RC is out

what do people think of

cachedWithin="instance"

along the lines of

cachedWithin="request"

for functions https://docs.lucee.org/reference/tags/function.html

Hello Everyone! I am stuck in finding the right CF_SQL_TYPE for the cfqueryparam. The DBMS is PostgresSQL and the table column data type is “money”. I tried several cf_sql_type but it not works. Also see at https://docs.lucee.org/guides/cookbooks/Sql-Types.html but not find any “money” type. What is the solution? change the column type in postgreSQL or there any type that works with cfqueryparam for “money”? Thank you!

Is there much of a difference between 5.3.9 and 5.3.10 ?

Hello all. Anyone have a case where your connection to a mongo db at mongodb.com suddently stops working and throws an error as follows: PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target}, caused by {sun.security.validator.ValidatorException: PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target}, caused by {sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target}}]

It's been working for months, nothing has changed that we are aware of on the server and we manage the server ourselves.

I can see that the cert is in the certstore via the Lucee admin for the mongodb.net domain

Using createObject, I am unable to call a method inside a java inner class. Backstory: I’m attempting to locally use the maxmind database and reader API. This allows me to get location data on an IP address. Along with their database and reader, maxmind also has a simple caching object which can be used to speed up API requests. I am able to get their database reader API up and running, however, I am struggling including the cache object and hoped someone here may have a better idea on what I could try. This is what I’m attempting to replicate with Lucee:

new DatabaseReader.Builder(file).withCache(new CHMCache()).build();

Builder

is an inner class of

DatabaseReader

. I’m able to init() Builder (and subsequently the database reader API) using the

$

notation as defined in the Lucee docs. However I am unable to call the Builder

withCache()

method. The API docs for

build()

and

withCache()

are here. This is the code I’m running; 1st what works, and then 2nd my failing attempt at including the cache object. 1st: This works, it creates a database using a maxmind DB file, and the database reader API:

<cfscript>

ip = '209.85.231.104';

// build the database file object
dbfile = "/pathto/geoip/lib/GeoLite2-Country.mmdb";
db = createObject("java","java.io.File").init(expandpath(dbfile));

// initiate the database reader object
reader = createObject("java", "com.maxmind.geoip2.DatabaseReader$Builder",expandpath('/pathto/geoip/lib/geoip2-3.0.1.jar')).init(db).build();

// create ipaddr class 
iaddrClass=CreateObject("java", "java.net.InetAddress");

// test
address=iaddrClass.getByName(ip);
writedump(reader.country(address).getCountry().getName());
writedump(reader.country(address).getCountry().getIsoCode());


</cfscript>

2nd: This doesn't work, I create the cache object and attempt to call it on the builder object with

.withCache(maxMind_CHMCaching)

and returns the following error:

No matching Method/Function for com.maxmind.geoip2.DatabaseReader$Builder.withCache(com.maxmind.db.CHMCache) found

<cfscript>

ip = '209.85.231.104';

// build the database object
dbfile = "/pathto/geoip/lib/GeoLite2-Country.mmdb";
db = createObject("java","java.io.File").init(expandpath(dbfile));

// initiate a maxmind caching object
maxMind_CHMCaching = createObject("java", "com.maxmind.db.CHMCache",expandpath('/pathto/geoip/lib/maxmind-db-2.0.0.jar')).init();

// initiate the database reader object using cache
reader = createObject("java", "com.maxmind.geoip2.DatabaseReader$Builder",expandpath('/pathto/geoip/lib/geoip2-3.0.1.jar')).init(db).withCache(maxMind_CHMCaching).build();

// create ipaddr class 
iaddrClass=CreateObject("java", "java.net.InetAddress");

// test
address=iaddrClass.getByName(ip);
writedump(reader.country(address).getCountry().getName());
writedump(reader.country(address).getCountry().getIsoCode());


</cfscript>

If anyone has an idea of what I should try next I would appreciate the feedback.

pop quiz, which one is fastest?

a = [].set(1, 10000, "zac");

c = 0;

timer type="outline" {

loop array=a index="b" {

c++;

}

}

dump(c);

d = 0;

timer type="outline" {

a.each(function(e){

d++;

});

}

dump(d);

f = 0;

timer type="outline" {

a.each(function(g){

f++;

}, true);

}

dump(f);

first one id guess

This message was deleted.

so has anyone tried out the 5.3.10.79-RC yet? no news is good news?

i created a login system but i want to know without using cflogin, how can i call my checklogin page i onrequest or onrequest to make sure all pages being browsed are member only pages, my page which is checklogin checks if logged in, navigate to index.cfm, but includfing that in redirect will happen redirect too many imes, i was thinking to create a validation.cfm file and call it on onrequest method so everytime request is made, it checks that file first and then continue next, but my confusion lies how can i stop that file to be executed in the login page and check login page and logout page maybe i am understanding wrong but that is what i am going through as of now

Hi all, there seems to be a difference in the specs for the named arguments in https://cfdocs.org/fileupload vs https://docs.lucee.org/reference/functions/fileupload.html. The latter seems to adhere to the CFFILE specs regarding the named arguments. How should one go about this in CFDOCS.org? Specifically the accept vs the mimeType and the nameConflict vs onConflict arguments. Lucee 5.x errors on the latters, but accepts the formers (is this even a word? 😄).

I am attempting to send a file stored in Amazon S3 as an email attachment using cfmail in Lucee 5.3.8.206. The emails are not being sent and when I check the tasks in the lucee admin it is reporting that the file does not exist. Am I wrong in assuming that adding a file with a path of s3:///someBucket/somefile as an attachment should work? I have checked that the file does exist using fileexists() so it is definitely there and the mail param tag itself doesn't complain about the file not existing either. If I am trying to do something that can't be done then I can work around it - just wanted to check if anyone had any insight before doing so.

i am trying to make a menu by passing the structure values along with nested structures i ended up somewhat but i am stuck on the inner nested struct where i have to loop over and set the values passed, in case the dashboard i am passing, the value is empty, i do not want any syubmenu but it is still showing up