我在此更新查询中有问题，需要帮助 [英] I Have problem in this update query ,I need help

问题描述

UPDATE Voting Set Davg=(("+ Davg +"*no_of_voting)+ " " )/(no_of_voting+1),Cavg=(("+Cavg+"*no_of_voting )+ " ")/(no_of_voting+1),Favg=(("+Favg+"*no_of_voting)+ "")/(no_of_voting+1) WHERE BrandName='"+Dropdownlist4.SelectedItem.Value+"'";

推荐答案

对于一个，您使用双引号而不是单引号es.其次，您尝试将字符串乘以字段.没有一些错误信息就无法告诉您还有什么问题.另外，如果您实际上解释了问题，而不是仅仅声明您有问题并发布了一些我们一无所知的代码，这将非常有用.您还应该说明您使用的是哪种类型的SQL ...不确定为什么用C#标记了此问题.

For one, you use a double quote instead of an apostrophe for quotes. Second, you try to multiply a string by a field. Can''t tell you what else is wrong without some error messages. Also, it would be useful if you actually explained your problem rather than just stating that you have a problem and posting some code we know nothing about. You should also state which type of SQL you are using... not sure why you tagged this question with C#.

这篇关于我在此更新查询中有问题，需要帮助的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！