chris-schmitz
01/28/2023, 9:25 AMcast( value as UNSIGNED)
stops processing value
as soon as it encounters something that does not represent a number, iirc. So here it would stop at the comma.
What you could try is to build the join on a LIKE clause:
ON x.opt_code LIKE concat( '%', y.opt_code_id, '%')
Definitely not the fastest join, but, it should workchris_hopkins
01/29/2023, 12:02 AMAdam Cameron
I am going to ask a contextless question because any context will influence the point of the question, and accordingly the answer.
THIS IS IMPORTANT: Any answers given should be from existing knowledge, and not from googling. I'm not testing ppl's ability to google stuff. I am trying to establish what "common knowledge" on the topic is.
MySQL "CREATE TABLE ... SELECT Statements". Any observations?Cheers. Sorry it's vague.
John Wilson
02/07/2023, 10:35 PMselects
only?gsr
03/11/2023, 3:38 PMselect individual_Ratings.*,count(rating) as tRating from individual_Ratings where productID = 99 group by rating
and my query is giving me an error on this
Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'shopzone1.individual_Ratings.individualid' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
gsr
03/11/2023, 3:38 PMgsr
03/11/2023, 3:40 PMmysql> ET GLOBAL sql_mode=(SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY',''));ET GLOBAL sql_mode=(SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY',''));
ERROR 2006 (HY000): MySQL server has gone away
No connection. Trying to reconnect...
Connection id: 49
Current database: *** NONE ***
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ET GLOBAL sql_mode=(SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY',''))' at line 1
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ET GLOBAL sql_mode=(SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY',''))' at line 1
mysql> ET GLOBAL sql_mode=(SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY',''));ET GLOBAL sql_mode=(SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY',''));
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ET GLOBAL sql_mode=(SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY',''))' at line 1
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ET GLOBAL sql_mode=(SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY',''))' at line 1
mysql> ET GLOBAL sql_mode=(SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY',''));ET GLOBAL sql_mode=(SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY',''));
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.