error: too many many input arguments matlab

Question

I am trying to execute a Sql query in matlab. The sql uses 'select' command for selecting a particular row using a columnname which matches a value that is stored in variable given in the following code. When I execute this , I get an error : Error using ==> database.exec Too many input arguments.

q=value;%computed value. 
conn1=database('Dbname','',''); 
fna=exec(conn1,'select * from table1 where ImageName="',q,'"');
fna=fetch(fna); fda=fna.data;

Daniel · Accepted Answer · 2014-03-01 13:18:07Z

1

You are passing four input arguments, the last three ones must be concatitated to one sql command.

sqlquery=['select * from table1 where ImageName="',q,'"'];
fna=exec(conn1,sqlquery);

answered Mar 1, 2014 at 13:18

Daniel

36.8k3 gold badges38 silver badges73 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

user3368213 Over a year ago

:Further i am storing the contents of fda in a cell. When i try to print the contents present in the cell , there is another error : C = fda.'; sprintf('%d%d%d'C{1,1},C{2,1},C{3,1}) Error :Cell contents reference from a non-cell array object.

Steffen Nieuwenhoven · Accepted Answer · 2014-03-01 13:16:26Z

0

in the matlab manual it says that exec has the following syntax:

curs = exec(conn,sqlquery)
curs = exec(conn,sqlquery,qTimeOut)

You have four parameters in the exec functions, that's what the error means!

answered Mar 1, 2014 at 13:16

Steffen Nieuwenhoven

5258 silver badges21 bronze badges

Collectives™ on Stack Overflow

error: too many many input arguments matlab

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related