How to concat UUID into a SQL query string to MariaDB

Anders S anders at xore.se
Tue Aug 27 08:08:05 UTC 2019


Hi guys,

Using MariaDB to communicate between appz via FIFO pipe

Now I stumbled on the next problem, how to extract UUID from 
database into an UPDATE query that is a string ( the sql variable 
).

Got in a loop:

char [16][10] hash;

for(i =0; i < count; i++){

auto hash1 = row[0];

hash[i] = hash1.get!(string);

... do some FIFO Pipe work

sql = "UPDATE guirequest SET done_request = SYSDATE() WHERE 
request_id=" + hash[i] + ";";

Get this error :Error: invalid array operation "UPDATE guirequest 
SET done_request = SYSDATE() WHERE request_id=" + 
hash[cast(uint)i] (possible missing [])

Any ideas?

/a


More information about the Digitalmars-d-learn mailing list