syntax i think

[oakpark5]

this is my code:

select sum(lonhand) from iciloc where loctid = stock,zbond and item=@item

@item is a parameter i passed. I'm not sure about the syntax but there is a table with where item come up twice. one for loctid=stock and one for loctid=bond. I'm trying to add the two together. Cant seem to get it right. Thanks in advance for any help.

Software Engineer
Team Lead
damn bill gates, he has everything

 

[dbomrrsm]

[case]
select sum(lonhand)
from iciloc
where loctid IN ('stock','zbond')
and item=@item
[/case]

good luck


[blue]DBomrrsm[/blue]

 

[mrdenny]

almost there.

select sum(lonhand) 
from iciloc 
where loctid in ('stock','zbond')
     and item=@item

Try that out.

Denny

--Anything is possible. All it takes is a little research. (Me)

 

[oakpark5]

Thanks for the help, i've tried that as well. I'm writing this as a sql string in C#, which is running behind an ASp.NET page. I dont know why but it doesnt seem to like the syntax, this is the error i get: [FormatException: Input string was not in a correct format.]

Not sure if anyone knows the correct format using c# but if ya do, i would appreciate the help, thansk.

Software Engineer
Team Lead
damn bill gates, he has everything

 

[mrdenny]

Nope, not a C# programmer.

Denny

--Anything is possible. All it takes is a little research. (Me)