mk
09/06/2022, 4:24 PMJeff Stevens
09/06/2022, 6:26 PMJason Ryan
09/06/2022, 9:32 PMLucee-light
Docker image and attempting to add the necessary extensions one at a time. As an example, form.extension
. I've tried adding the f_orm.extension-1.0.0.10.jar_
to /opt/lucee/server/lucee-server/bundles/
as well as /opt/lucee/server/lucee-server/context/extensions/available
(per Lucee docs) and both yield a "not loaded" status for form.extension
when checking in Lucee admin. These happen at container build time so obviously restarting it isn't required. Any idea where I need to put these darn .jar
files to get an "active" status on them?Graham
09/07/2022, 8:25 AMGraham
09/07/2022, 8:25 AMzackster
09/07/2022, 2:36 PMJeanine Blount
09/07/2022, 6:49 PMVictor B Vieira
09/08/2022, 12:45 AMbdw429s
09/08/2022, 2:54 PMAdam Cameron
Adam Cameron
Daniel Mejia
09/09/2022, 4:46 PM<cftransaction action="begin">
<cfloop query="getEmployees">
<cfset employee.jobInfo = ultipro.GetJobByEmployeeIdentifier(getEmployees.cb_emp_n)> <!--- cfhttp() + xmlparse() --->
<cfquery name="qry" datasource="mainds">
insert into ....
</cfquery>
</cfloop>
<cftransaction action="commit">
</cftransaction>
gsr
09/12/2022, 12:13 PM<cfsavecontent variable="_bcp">
-- Run this command to the database you wish to export
DECLARE @Commands TABLE(CommandText NVARCHAR(4000));
DECLARE @SQL NVARCHAR(4000);
INSERT INTO @Commands
SELECT 'bcp ' --bcp
+ QUOTENAME(DB_NAME())+ '.' --database name
+ QUOTENAME(SCHEMA_NAME(SCHEMA_ID))+ '.' -- schema
+ QUOTENAME(name) -- table
+ ' out c:\temp\csvdump\' -- output directory
+ REPLACE(SCHEMA_NAME(schema_id),' ','') + '_'
+ REPLACE(name,' ','') -- file name
+ '.xls -Usa -Pqwerty -C 65001 -t "|" -k -c -S localhost' -- extension, security
FROM sys.tables
-- Copy-paste results to DOS or Powershell prompt or create a BAT file from these.
SELECT 'mkdir #application.args.bcpbackupsFolder#\#dateFormat(now(),'MMDDYYYY')#
UNION ALL
SELECT * FROM @Commands
</cfsavecontent>
<cffile action="write" file="#application.temp#/bcp.bat" output="#_bcp#">
<cfexecute name="C:\Windows\System32\cmd.exe" arguments="#application.temp#/bcp.bat" timeout="60" outputfile="#application.logs#/log_output_bcp.txt"/>
i also tried changing the arguments value to put in name but same issueFormiko
09/12/2022, 5:09 PMhpeter16
09/12/2022, 5:23 PMwebsolete
09/12/2022, 7:41 PMgsr
09/13/2022, 12:52 PMgsr
09/13/2022, 1:10 PMOokma-Kyi
09/13/2022, 7:28 PMIncorrect integer value: 'true' for column 'notifications' at row 1
. Inspecting my database it shows my column is a tinyint. Doing some research MySQL does not have support for true Booleans, however it does support true, false, True, False, TRUE, FALSE
values which is what I am doing. Is there something going on behind the scenes?
Source: https://www.mysqltutorial.org/mysql-boolean/TEMann
09/13/2022, 7:46 PMSlackbot
09/14/2022, 11:45 AMFormiko
09/14/2022, 4:46 PMFormiko
09/14/2022, 4:47 PMFormiko
09/14/2022, 4:49 PMFormiko
09/14/2022, 4:51 PMFormiko
09/14/2022, 5:44 PMjumpmaster
09/14/2022, 7:04 PMScott Steinbeck
09/14/2022, 10:01 PMRyan Albrecht
09/14/2022, 11:39 PMdavla
09/15/2022, 1:21 PM