parameter problems

[bafidi]

i have info table in sql server 2000

INFO:

name surname
______________________________________
1 Null

select * from INFO where name=@name and surname=@surname
i run this and input
name=1
surname=

but then no results turn back empty why???????

[msnews]

because NULL is a value and your input is empty string!!!!

Ahmad

"bafidi" <ba****@discussions.microsoft.com> wrote in message
news:57**********************************@microsof t.com...

i have info table in sql server 2000

INFO:

name surname
______________________________________
1 Null

select * from INFO where name=@name and surname=@surname
i run this and input
name=1
surname=

but then no results turn back empty why???????

[bafidi]

how can i input null value to a parameter

"msnews" wrote:

because NULL is a value and your input is empty string!!!!

Ahmad

"bafidi" <ba****@discussions.microsoft.com> wrote in message
news:57**********************************@microsof t.com...

i have info table in sql server 2000

INFO:

name surname
______________________________________
1 Null

select * from INFO where name=@name and surname=@surname
i run this and input
name=1
surname=

but then no results turn back empty why???????

[Morten Wennevik]

Hi Bafidi,

Use DBNull.Value for a null.

On Mon, 26 Sep 2005 14:56:02 +0200, bafidi <ba****@discussions.microsoft.com> wrote:

how can i input null value to a parameter

"msnews" wrote:

because NULL is a value and your input is empty string!!!!

Ahmad

"bafidi" <ba****@discussions.microsoft.com> wrote in message
news:57**********************************@microsof t.com...

> i have info table in sql server 2000
>
> INFO:
>
> name surname
> ______________________________________
> 1 Null
>
> select * from INFO where name=@name and surname=@surname
>
>
> i run this and input
> name=1
> surname=
>
> but then no results turn back empty why???????

--
Happy coding!
Morten Wennevik [C# MVP]

[bafidi]

how can i write null value?

for example:
dim count1 as integer
count1=DBNull.Value


"Morten Wennevik" wrote:

Hi Bafidi,

Use DBNull.Value for a null.

On Mon, 26 Sep 2005 14:56:02 +0200, bafidi <ba****@discussions.microsoft.com> wrote:

how can i input null value to a parameter

"msnews" wrote:

because NULL is a value and your input is empty string!!!!

Ahmad

"bafidi" <ba****@discussions.microsoft.com> wrote in message
news:57**********************************@microsof t.com...
> i have info table in sql server 2000
>
> INFO:
>
> name surname
> ______________________________________
> 1 Null
>
> select * from INFO where name=@name and surname=@surname
>
>
> i run this and input
> name=1
> surname=
>
> but then no results turn back empty why???????

--
Happy coding!
Morten Wennevik [C# MVP]

[Jon Skeet [C# MVP]]

bafidi <ba****@discussions.microsoft.com> wrote:

how can i input null value to a parameter

It doesn't matter even if you do - your query still won't work, because
in SQL, null doesn't equal itself. You need something like

select * from INFO where name=@name and (surname=@surname OR
(surname is null and @surname is null))

--
Jon Skeet - <sk***@pobox.com>
http://www.pobox.com/~skeet Blog: http://www.msmvps.com/jon.skeet
If replying to the group, please do not mail me too

[Morten Wennevik]

You need to use SqlParameter/OleDbParameter

[C#]
SqlParameter param1 = new SqlParameter("@count1", SqlDbType.Int);
param1.Value = DBNull.Value;
On Tue, 27 Sep 2005 07:44:01 +0200, bafidi <ba****@discussions.microsoft.com> wrote:

how can i write null value?

for example:
dim count1 as integer
count1=DBNull.Value


"Morten Wennevik" wrote:

Hi Bafidi,

Use DBNull.Value for a null.

On Mon, 26 Sep 2005 14:56:02 +0200, bafidi <ba****@discussions.microsoft.com> wrote:

> how can i input null value to a parameter
>
> "msnews" wrote:
>
>> because NULL is a value and your input is empty string!!!!
>>
>> Ahmad
>>
>>
>>
>> "bafidi" <ba****@discussions.microsoft.com> wrote in message
>> news:57**********************************@microsof t.com...
>> > i have info table in sql server 2000
>> >
>> > INFO:
>> >
>> > name surname
>> > ______________________________________
>> > 1 Null
>> >
>> > select * from INFO where name=@name and surname=@surname
>> >
>> >
>> > i run this and input
>> > name=1
>> > surname=
>> >
>> > but then no results turn back empty why???????
>>
>>
>>
>

--
Happy coding!
Morten Wennevik [C# MVP]

--
Happy coding!
Morten Wennevik [C# MVP]

[Cor Ligthert [MVP]]

> select * from INFO where name=@name and (surname=@surname OR

(surname is null and @surname is null))

Terrible that SQL in another language (where I don't like the used operands)
it would in my opinion simple be

if (name==@name){if (surname==@surname){do what you need to do;}}

:-)

Cor