使用SQL按查询顺序 [英] Order by query using sql

问题描述

大家晚上好，我已经在我的项目中使用了此查询
从TabDupMembers中选择*，其中id按MemberName <(/> + str +)的顺序排列
在此查询中，"+ Str +"是变量.(str ="7385,7386,7387")
每当我尝试执行查询时，我都会收到错误消息
没有为一个或多个必需参数给出值".我找不到问题，请任何人帮助我.

Good Evening to all, i have use this query into my project
select * from TabDupMembers where id in(" + str + ") order by MemberName
In this query " + Str + " is a variable.(str="7385,7386,7387")
whenever am try execute the query i got an error
"No Value given for one or more required parameters". I can''t find out the problem Please any body can help me.

Thanks in Advance!

推荐答案

请确保已使用命令定义了参数-http://msdn.microsoft.com/en-us/library/bbw6zyha%28v=vs.71%29.aspx [ ^ ].

Make sure you have defined the parameters with you command - http://msdn.microsoft.com/en-us/library/bbw6zyha%28v=vs.71%29.aspx[^].

这是原因
未为一个或多个必需参数提供值. (ADO错误) [

Here the reasons
No value given for one or more required parameters. (ADO Error)[^]

已阅读此VBForum文章: ^ ]

通常，这是某种语法问题，我建议您直接在正在使用的数据库中尝试构造的" sql语句

Have a read of this VBForum article : No Value given for one or more required parameters[^]

Normally this is a syntax issue of some kind, I would suggest that you try the "constructed" sql statement directly in the database that you are using

这篇关于使用SQL按查询顺序的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！