Unable to retrieve 2D array from database

[Roy]

I'm having trouble with retrieving 2D arrays from my database(MySQL).
I have a number of clusters which all map to their own database table.
Some of these clusters contain 1D arrays and some contain 2D arrays.
Inserting a 1D array into the database is no issue (associated column
is of LONGBLOB type). Retrieving a 1D array from the database is easy
with the 'Database Data to Variant' function. Inserting a 2D array is
as easy as for a 1D array, however I can't seem to retrieve a 2D array
in the same way as for a 1D array. Any tips on how to do this would be
greatly appreciated.

[Zvezdana S.]

Roy, did you wire a 2D array or cluster of 2D array constant to the
Database Variant to Data type input when trying to retrieve a 2D
array? What is the error that this function returns? Are you using the
database toolkit?
Zvezdana S.

[shiza]

hello...how to insert two dimensional array in mysql database.
a=[1 2]
update(conn, 'candidate', colnames, a, ..
'where candidate_id = 1'
but it give error

??? Index exceeds matrix dimensions

Error in ==> database.update at 13
dataString = [ dataString fieldNames{j} ' = ' tmpstr ]
thnx in advanc

--http://compgroups.net/comp.lang.labview/unable-to-retrieve-2d-array-from-database/783647