How can I write variable in sub query

2011 6 16
2 个回答
回答已采纳
3 次查看（30 天）

1 个投票

i try to write variable in sub query like this :
exec(conn,['select course_id from course where course_id not in' (['select course_id from transcript where student_id=' '''' aa2 '''']) ]);
not respond
Thank you.

请先登录，再回答此问题。

 采纳的回答

the cyclist
the cyclist 2011-6-17

2 个投票

I think the following is what you want:
>> queryText = ['select course_id from course where course_id not in (select course_id from transcript where student_id=',num2str(aa2),')'];
>> exec(conn,queryText)

更多回答（1 个）

the cyclist
the cyclist 2011-6-16

1 个投票

Is aa2 a numeric variable, or a string? You might need to use the num2str() function.
I can't fully debug this right now, but in a case like this, I recommend building your string up piece by piece, outside the exec() function, to make sure the string you send as a query really looks like you expect it to. Looks to me that, for example, you do not really have the parentheses in there as part of the string, the way you want to for a subquery.

1 个评论
显示 -1更早的评论 隐藏 -1更早的评论

sayer ali
sayer ali 2011-6-16
aa2 is numeric ,i try the same query in ms sql it respond like this
select course_id from course where course_id not in (select course_id from transcript where student_id=7000032);
it respond
you knew when you write this query in mat lab with variable will be somehow different

请先登录，再进行评论。

类别

在 帮助中心 和 File Exchange 中查找有关 Whos 的更多信息

标签

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by