CODEWITHSUNDEEP
sqlmatlabqsqlquery
daenerysTarg
daenerysTarg

Reputation: 352

Sql query not working on matlab properly

So i'm working on a laravel project where i pass some data to matlab and then matlab will edit them..everything works fine except the function of matlab that i wrote..

function show(a)
econ=database('datamining','root','');
curs=exec(con,'SELECT name FROM dataset_choices WHERE id = a');
curs = fetch(curs);
curs.Data
end

i want this function to display the name of the dataset the user choose..the problem is that it doesnt work writing just where id = a... but if i write for example where id=1 it works.. i tried to display just the a with disp(a) to see what is the value of the a and it is store the right id that user had choose..so how can i use it in my query??

Upvotes: 0

Views: 168

Answers (1)

Flynn
Flynn

Reputation: 269

Try:

a = num2str(a); % or make sure the user inputs a string instead
curs=exec(con,['SELECT name FROM dataset_choices WHERE id = ',a]);

If a = '1', then the brackets would print: 'SELECT name FROM dataset_choices WHERE id = 1'

Upvotes: 1

Related Questions