string concatenation with %s

Suliman via Digitalmars-d-learn digitalmars-d-learn at puremagic.com
Mon Mar 30 10:18:00 PDT 2015


same problem. I am preparing string to next SQL request:

string sss = format("SELECT * FROM test.imgs WHERE src LIKE 
CONCAT('%', REPLACE(CAST(CURDATE()as char), "-", ""), '%') OR 
CONCAT('%', CAST(CURDATE()as char), '%')");

but I am getting next error:

source\app.d(178): Error: invalid array operation "SELECT * FROM 
test.imgs WHERE
  src LIKE CONCAT('%', REPLACE(CAST(CURDATE()as char), " - ", ), 
'%') OR CONCAT('
%', CAST(CURDATE()as char), '%')" (possible missing [])
FAIL 
.dub\build\application-debug-windows-x86-dmd_2067-112ADE4A65EFD822A10EE5558
208F889\ geodataloader executable


More information about the Digitalmars-d-learn mailing list