Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
Unable to retrieve 2D array from database
18 views
Skip to first unread message
Roy
Nov 12, 2003, 8:27:01 AM11/12/03
to
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.
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.
Nov 18, 2003, 2:43:35 PM11/18/03
to
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.
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
Aug 7, 2012, 9:19:25 PM8/7/12
to
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 136
dataString = [ dataString fieldNames{j} ' = ' tmpstr ];
thnx in advance
--http://compgroups.net/comp.lang.labview/unable-to-retrieve-2d-array-from-database/783647
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 136
dataString = [ dataString fieldNames{j} ' = ' tmpstr ];
thnx in advance
--http://compgroups.net/comp.lang.labview/unable-to-retrieve-2d-array-from-database/783647
0 new messages