Answer the question
In order to leave comments, you need to log in
SQL doesn't want to accept any numbers other than one. What is the problem?
Suppose the server (ASP.NET) has a database file in mdf format. It has a table with some fields. One of these fields (let's say ssf) contains only integer values. There are 3 records in the database - two with the ssf parameter equal to 1, and the third one with the ssf parameter equal to 2.
When selecting records by the ssf parameter with a value of 1, the database adequately returns two records that satisfy the condition (ssf = 1), but when selecting records for the ssf parameter with a value of 2, the base always returns null. Even if we replace the digit 2 with any other than one, and perform a selection according to the parameter ssf = 3, then the selection also does not occur. The query structure is the same with a difference of 1 digit.
What could be the problem?
Answer the question
In order to leave comments, you need to log in
Obviously in the request text - run profiler and look at the request text.
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question