Error: Cell contents reference from a non cell array object.
2 views (last 30 days)
Show older comments
I am using the following matlab code for selecting a particular row which matches a columnname from an access database. Once the row is retrieved , i try to store the values in a cell array .But i get an error when i try to print it.
q=FileNamevalue;
conn1=database('Dbname','','');
fna=exec(conn1,'select * from table1 where ImageName="',q,'"');
fna=fetch(fna);
fda=fna.data;
C = fda.'; %storing data in a cell array.
sprintf('ImageNo:%d\nImageName:%s\nDiseaseCategory: %s',C{1,1},C{2,1},C{3,1})
And here is the error: ??? Cell contents reference from a non-cell array object.
Error in ==> featurecomparison at 7 sprintf('IMAGENO:%d"\n"IMAGE NAME:%s"\n"DISEASE CATEGORY:%s"\n'); %Assumed to have 3 columns.
2 Comments
Image Analyst
on 2 Mar 2014
And you forgot to post your error message. Post ALL the red text . Don't snip out just part of it or paraphrase it, give us the whole thing.
Answers (3)
Image Analyst
on 2 Mar 2014
What is the class of fda? Is it a cell array? What does this show if you put it just before the line that throws an error
whos fda
class(fda)
My guess is that fda is not a cell and so C is not a cell either, and then when you try to do C{1,1} it gives you the error because in order to use braces C must be a cell, which it is not .
13 Comments
dpb
on 2 Mar 2014
Taking a chance with the crystal orb...
C = fda.'; %storing data in a cell array.
Excepting it isn't--you forgot the curlies...
C = {fda.'};
in which case it appears you might just as well have written
C={fna.data};
0 Comments
dpb
on 8 Mar 2014
Edited: John Kelly
on 27 Feb 2015
...
fname=fetch(fname,10);
...
OK, from the database documentation for fetch one finds...
When fetch returns a cursor object, you can run many other functions, such as get and rows. To import data into the MATLAB workspace without metadata, use fetch with a database connection object as the input argument.
So, since we now know that fname is an object, we have to use the methods defined for that object.
See
and the links therefrom to get and joy should then ensue.
0 Comments
See Also
Categories
Find more on Modeling and Prediction in Help Center and File Exchange
Products
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!