zackster
01/14/2023, 12:01 PMagentk
01/14/2023, 9:30 PMjohnbarrett
01/16/2023, 10:56 PMsalted
01/18/2023, 1:50 PMthisOldDave
01/18/2023, 3:57 PMQuery Of Queries syntax error. Encountered "email not in ( select. Incorrect conditional expression, Expected one of [like|null|between|in|comparison] condition,StackTracejava.sql.SQLException
. The Adobe documentation claims NOT IN
is fine https://helpx.adobe.com/coldfusion/developing-applications/accessing-and-using-data/using-query-of-queries/query-of-queries-user-guide.html (search in conditional) . but I cant get it to fly locally and this gist https://trycf.com/gist/91a2db7d0767096bc1fc9d93f8caba93/lucee5?theme=monokai seems to demonstrate thjat it is fine in Lucee and Railo but not in any version of ACF although I am sure I have used the construct in the past.richard.herbert
01/19/2023, 12:26 PM[Thu Jan 19 11:18:20.283069 2023] [modcfml:notice] [pid 11049] Handler Pattern Found => .cfm
[Thu Jan 19 11:18:20.283723 2023] [modcfml:notice] [pid 11049] Pattern Match TRUE: extension [.cfm] matches handler [.cfm]
[Thu Jan 19 11:18:20.283738 2023] [modcfml:notice] [pid 11049] Handler Pattern Found => .cfc
[Thu Jan 19 11:18:20.283749 2023] [modcfml:notice] [pid 11049] Handler Pattern Found => .cfml
[Thu Jan 19 11:18:20.283774 2023] [modcfml:notice] [pid 11049] Printing aliases: [1] found
[Thu Jan 19 11:18:20.283786 2023] [modcfml:notice] [pid 11049] 1. Alias: [/cgi-bin/] -> [/opt/homebrew/var/www/cgi-bin/]
[Thu Jan 19 11:18:20.283800 2023] [modcfml:notice] [pid 11049] URI => /index.cfm, filename => proxy:<ajp://localhost/index.cfm?page=dashboard&aId=7ba566594b1c2772f8008c1ac9a853c0>
[Thu Jan 19 11:18:20.283812 2023] [modcfml:notice] [pid 11049] Request header [Host] => <http://example.com|example.com>
[Thu Jan 19 11:18:20.283823 2023] [modcfml:notice] [pid 11049] Request header [Connection] => keep-alive
[Thu Jan 19 11:18:20.283832 2023] [modcfml:notice] [pid 11049] Request header [DNT] => 1
[Thu Jan 19 11:18:20.283847 2023] [modcfml:notice] [pid 11049] Request header [Upgrade-Insecure-Requests] => 1
[Thu Jan 19 11:18:20.283858 2023] [modcfml:notice] [pid 11049] Request header [User-Agent] => Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/109.0.0.0 Safari/537.36
[Thu Jan 19 11:18:20.283876 2023] [modcfml:notice] [pid 11049] Request header [Accept] => text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.9
[Thu Jan 19 11:18:20.283887 2023] [modcfml:notice] [pid 11049] Request header [Accept-Encoding] => gzip, deflate
[Thu Jan 19 11:18:20.283897 2023] [modcfml:notice] [pid 11049] Request header [Accept-Language] => en-GB,en;q=0.9,es;q=0.8,en-US;q=0.7,fr-FR;q=0.6,fr-CH;q=0.5,fr-CA;q=0.4,fr;q=0.3
[Thu Jan 19 11:18:20.283907 2023] [modcfml:notice] [pid 11049] Request header [Cookie] => LUCEE_ADMIN_LANG=en; LUCEE_ADMIN_PW_5.3.4.77_SERVER=6a10b09acc3112eeba7afa420c117257878a4c3ba7ca89f63af39f3ddf09ba11; LUCEE_ADMIN_LASTPAGE=services.datasource; cfid=876215ca-18ba-4520-ae17-8a87b80ce6ee; cftoken=0; JSESSIONID=FHKsPmev45ADw376DKOMBdBYicuUdkTtZIDodSWD
[Thu Jan 19 11:18:20.283918 2023] [modcfml:notice] [pid 11049] Request header [sec-gpc] => 1
[Thu Jan 19 11:18:20.283929 2023] [modcfml:notice] [pid 11049] Request header [X-Tomcat-DocRoot] => /Volumes/websites/example.com/
[Thu Jan 19 11:18:20.283939 2023] [modcfml:notice] [pid 11049] Request header [X-Webserver-Context] => example-com-confl3
[Thu Jan 19 11:18:20.283948 2023] [modcfml:notice] [pid 11049] Request header [X-ModCFML-SharedKey] => **************
[Thu Jan 19 11:18:20.283958 2023] [modcfml:notice] [pid 11049] Request header [x-vdirs] => /cgi-bin,/opt/homebrew/var/www/cgi-bin;
[Thu Jan 19 11:18:20.616301 2023] [proxy_ajp:error] [pid 11049] AH01081: ajp_msg_check_header() incoming message is too big 11704, max is 8192
[Thu Jan 19 11:18:20.616470 2023] [proxy_ajp:error] [pid 11049] AH01031: ajp_ilink_receive() received bad header
[Thu Jan 19 11:18:20.616491 2023] [proxy_ajp:error] [pid 11049] [client 127.0.0.1:64568] AH00992: ajp_read_header: ajp_ilink_receive failed
[Thu Jan 19 11:18:20.616511 2023] [proxy_ajp:error] [pid 11049] (120007)APR does not understand this error code: [client 127.0.0.1:64568] AH00893: dialog to (null) (localhost:8009) failed
Thoughts or directions to further reading appreciated.satauros
01/19/2023, 12:39 PMCharles Robertson
01/20/2023, 11:03 AM<cfinclude />
When creating cross cfml engine [ACF/Lucee] compatible code.
For instance, if you do something like this, you will get a compilation error:
function GetFrameworksByParam() {
var local = {};
local.frameworkbyparam = {
var1 = "hello world"
};
local.szResponse = {};
if(server.keyExists( 'lucee' )){
local.serializeParam_lucee_object = local.frameworkbyparam;
local.serializeResponse_lucee = Serialize(local.serializeParam_lucee_object);
local.szResponse = local.serializeResponse_lucee;
}
else{
local.serializeParam_acf_object = local.frameworkbyparam;
local.serializeParam_acf_type = "xml";
local.szResponse = Serialize(local.serializeParam_acf_object, local.serializeParam_acf_type);
}
WriteDump(var=local.szResponse);
}
GetFrameworksByParam();
The error occurs because of there are differences between the amount of params that the native method:
Serialize()
Can accept.
In ACF, it is two params, whereas in Lucee, it is just one param.
Differences in param names, if the params are named within the method call, also cause errors.
The compiler checks code in every conditional branch.
But, if you hide the code in an include, there is no error:
function GetFrameworksByParam() {
var local = {};
local.frameworkbyparam = {
var1 = "hello world"
};
local.szResponse = {};
if(server.keyExists( 'lucee' )){
local.serializeParam_lucee_object = local.frameworkbyparam;
include "includes/serialize-lucee.cfm";
local.szResponse = local.serializeResponse_lucee;
}
else{
local.serializeParam_acf_object = local.frameworkbyparam;
local.serializeParam_acf_type = "xml";
include "includes/serialize-acf.cfm";
local.szResponse = local.serializeResponse_acf;
}
WriteDump(var=local.szResponse);
}
GetFrameworksByParam();
includes/serialize-lucee.cfm
<cfset local.serializeResponse_lucee = Serialize(local.serializeParam_lucee_object) />
includes/serialize-acf.cfm
<cfset local.serializeResponse_acf = Serialize(local.serializeParam_acf_object, local.serializeParam_acf_type) />
Am I correct in thinking that CFML application servers don't check code within cfinclude
, at compile time?johnbarrett
01/20/2023, 8:58 PMJim Priest
01/20/2023, 8:59 PMDave Merrill
01/21/2023, 3:36 PMvalues = queryReduce(qry, function(result={}, row)
{
result[row.ID] = row.Name;
return result;
});
The 2-line function setting the result key value then returning it seems awkward.
Is there a cleaner way?gavinbaumanis
01/23/2023, 12:25 AMWHERE wsq.internalName = 'NPS_response'
When I pass the string into a cfquery tag
<cfquery name="theQuery" datasource = "#customer.getDataSource()#" >
#theLastSQL#
</cfquery>
I get SQL errors - where my "where" clause above is "double quoted"
You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'NPS_response''
Any and ALL quoted strings - end up with an extra set of single quotes.
It isn't just this one instance - it is simply the first one - that the error gets caught up on.
Thanks.johnbarrett
01/23/2023, 1:57 AMnickg
01/23/2023, 4:16 PMMichael Gillespie
01/24/2023, 2:21 PM<cfmailparam file="#variables.imgPath#icon-yt.png" contentid="iconyt" disposition="inline" />
Any tips on either, a) how to modify the display page, or b) an alternative to spoolmail that shows what the actual email looks like.Slackbot
01/24/2023, 5:12 PMzackster
01/25/2023, 12:37 PMJim Priest
01/25/2023, 9:42 PMabhalani
01/25/2023, 9:45 PMDave Merrill
01/26/2023, 2:37 PMScott Steinbeck
01/26/2023, 5:13 PMarrayMap
?
The reason for the question is i would like to filter an array of structs and also return a single column while getting the benefits of asyncelpete
01/26/2023, 5:17 PMScott Steinbeck
01/26/2023, 5:22 PMScott Steinbeck
01/26/2023, 5:26 PMAdam Cameron
Mark Takata (Adobe)
01/26/2023, 7:24 PMzackster
01/26/2023, 9:12 PMDaniel Mejia
01/27/2023, 2:30 AMMichael Gillespie
01/27/2023, 9:32 PMgrandTotal=val(h.total)+val(h.tax)+val(h.shiptotal);
when serializing the total to send back in Ajax I get "847.8100000000001" but when I output it to page or cfdump the result I get 847.81, as expected..
edited to add, in ACF2016Umair Khan
01/29/2023, 4:55 PM