Dropdownlist NULL [英] Dropdownlist NULL

问题描述

请帮助我使用此查询与页面上的下拉列表选择一起使用，以搜索在列表框中选择的信息。

但是当选择为null时出现问题


否则在查询分析器中它可以100％工作

展开 | 选择 | Wrap | 行号

解决方案

如果它在查询分析器中100％工作，则问题可能在于您传递给查询的数据。你确定你的参数被传递为NULL，你期望它们在哪里吗？

博士B

请帮助我将此查询与页面上的下拉列表选择一起使用，以搜索在列表框中选择的信息。

但是当选择为null时出现问题;


否则在查询分析器中它可以100％工作

展开 | 选择 | 换行 | 行号

< blockquote>

如果它在查询分析器中100％工作，则问题可能在于您传递给查询的数据。你确定你的参数被传递为NULL，你期望它们是什么？


博士B

这里Web表单上的下拉列表框是什么样的。


第一个示例

展开 | 选择 | Wrap | 行号

Please help i have this query that works with drop downlist selections on a page to search for the information selected in the listboxes.
but having a problem when the selection is "null"

otherwise in query analyser it works 100%

Expand|Select|Wrap|Line Numbers

解决方案

If it works 100% in Query Analyser then the problem might lie with the data you are passing to the query. Are you sure that your parameters are being passed as NULL where you would expect them to be?

Dr B

Please help i have this query that works with drop downlist selections on a page to search for the information selected in the listboxes.
but having a problem when the selection is "null"

otherwise in query analyser it works 100%

Expand|Select|Wrap|Line Numbers

If it works 100% in Query Analyser then the problem might lie with the data you are passing to the query. Are you sure that your parameters are being passed as NULL where you would expect them to be?

Dr B

here is what the dropdownlist boxes on the web form look like.

example of the first one

Expand|Select|Wrap|Line Numbers

这篇关于Dropdownlist NULL的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！