websolete
03/11/2023, 4:01 PMwebsolete
03/11/2023, 4:02 PMBrian
03/29/2023, 2:48 PMDaniel Mejia
04/14/2023, 8:55 PM"mydatasourcename": {
...
"class": "macromedia.jdbc.MacromediaDriver",
"database": "${db_database}",
"dsn": "jdbc:macromedia:sqlserver://${db_host}:1433;databaseName=${db_database};SelectMethod=direct;sendStringParametersAsUnicode=false;querytimeout=0;MaxPooledStatements=100;jdbcbehavior=0",
"host": "${db_host}",
"password": "${db_password}",
"port": "1433",
"username": "${db_login}"
}
Daniel Mejia
04/14/2023, 10:21 PMRandy L. Smith
04/19/2023, 5:25 PMbdw429s
04/19/2023, 5:27 PMbdw429s
04/19/2023, 5:27 PMRandy L. Smith
04/19/2023, 5:29 PMchris_hopkins
04/20/2023, 8:58 AMs1deburn
04/20/2023, 12:05 PMbyron70
04/28/2023, 9:11 PMzackster
05/14/2023, 12:38 PMJohn Wilson
05/17/2023, 6:46 PMdbaseServer\DEMO
, for example? When using this in Lucee, the instance name is ignored.Simone
06/19/2023, 4:55 PMzackster
09/14/2023, 3:26 PMdavla
09/29/2023, 8:15 AMwebsolete
10/09/2023, 2:53 PMwebsolete
10/23/2023, 5:29 PMgsr
12/01/2023, 2:50 AMselect * from schedule where TRIM(gameTime) = "2023-11-14 00:00:00"
and my column gameTime is
gameTime datetime YES
gsr
12/01/2023, 2:50 AMgsr
12/01/2023, 2:50 AMgavinbaumanis
12/01/2023, 5:57 AMselect * from schedule;
And as a test you can use BETWEEN
select * from schedule where gameTime between 'xxx' AND 'yyy';
Actually I might have just worked it out...
What results do you get if you use single-quotes instead of double-quotes?
Double quotes is used a column name in mySQL
select * from schedule where TRIM(gameTime) = '2023-11-14 00:00:00'
You can avoid that problem by using cfqueryparam
for all items that appear in a WHERE / GROUP By etc.Brian
02/08/2024, 7:31 PMshawnoden
02/13/2024, 12:14 PMshawnoden
02/13/2024, 12:14 PMshawnoden
02/13/2024, 12:14 PMgsr
02/28/2024, 3:22 PMehoffman
03/04/2024, 4:50 PMScott Stroz
04/16/2024, 3:37 PMvarchar(max)
. This data can be very large (an array of base64 encoded images).
On my local dev environment, I can retrieve this data without issue.
However, on the staging server, the data in this column gets truncated at 64,000 characters. I have verified that CLOB is enabled for the data source (oddly enough, the CLOB buffer is higher than 64,000 bytes).
I am using Cf 2021, and the DB is SQL Server. Has anyone ever seen issues like that and can point me toward a solution?