Put SELECT result into a variable

[Silvio Pedretti]

Hello,

please help me with this (for me) big problem, I'm struggling trying to find a solution with no results.....

I have this part of code:

sprintf(query, SELECT_DATA);
my_conn.cmd_query(query);
column_names *cols = my_conn.get_columns();
Serial.println();
for (int f = 0; f < cols->num_fields; f++) {
Serial.print(cols->fields[f]->name);
if (f < cols->num_fields - 1)
Serial.print(',');
}
Serial.println();
row_values *row = NULL;
while (row = my_conn.get_next_row()) {
for (int f = 0; f < cols->num_fields; f++) {
Serial.print(row->values[f]);
if (f < cols->num_fields - 1)
Serial.print(',');
}
my_conn.free_row_buffer();
Serial.println();
}

It works, I can read from the serial monitor the results of the query, but I don't know how to put them into a variable...

any help is much appreciated...

thank you