if condition

[dave]

hi
i have got one field in sql server 2000 database.
field1 char 50

in one record, i m storing value -1

but it doesnt satisfy following condition

if (rs("field1")) = cstr("-1") Then
response.write ("true")
end if

i already checked its value by response.write and
print -1 only..
then y its above condition is false???
thanx
dave

 

[Steven Burn]

Try the following;

Select Case rs("field1")
Case "-1"
Response.Write "-1"
Case Else
Response.Write "Not -1"
End Select

--
Regards

Steven Burn
Ur I.T. Mate Group
www.it-mate.co.uk

Keeping it FREE!

Disclaimer:
I know I'm probably wrong, I just like taking part ;o)

 

[dave]

tried but doesnt work..
dave

-----Original Message-----
Try the following;

Select Case rs("field1")
Case "-1"
Response.Write "-1"
Case Else
Response.Write "Not -1"
End Select

--
Regards

Steven Burn
Ur I.T. Mate Group
www.it-mate.co.uk

Keeping it FREE!

Disclaimer:
I know I'm probably wrong, I just like taking part ;o)





.

 

[Steven Burn]

Oks try this;

Dim valTable As Long
valTable = rs("field1")

Select Case valTable
Case -1
Response.Write "-1"
Case Else
Response.Write "Not -1"
End Select

--
Regards

Steven Burn
Ur I.T. Mate Group
www.it-mate.co.uk

Keeping it FREE!

Disclaimer:
I know I'm probably wrong, I just like taking part ;o)

 

[dave]

no..not working

-----Original Message-----
Oks try this;

Dim valTable As Long
valTable = rs("field1")

Select Case valTable
Case -1
Response.Write "-1"
Case Else
Response.Write "Not -1"
End Select

--
Regards

Steven Burn
Ur I.T. Mate Group
www.it-mate.co.uk

Keeping it FREE!

Disclaimer:
I know I'm probably wrong, I just like taking part ;o)





.

 

[Steven Burn]

How are you getting the value from the record set? and what is the value
type (integer, long, byte, string etc etc?)

--
Regards

Steven Burn
Ur I.T. Mate Group
www.it-mate.co.uk

Keeping it FREE!

Disclaimer:
I know I'm probably wrong, I just like taking part ;o)

 

[dave]

field1 char 50

-----Original Message-----
How are you getting the value from the record set? and what is the value
type (integer, long, byte, string etc etc?)

--
Regards

Steven Burn
Ur I.T. Mate Group
www.it-mate.co.uk

Keeping it FREE!

Disclaimer:
I know I'm probably wrong, I just like taking part ;o)





.

 

[Ray at]

If it's char(50) as opposed to varchar(50), would the value be:

"-1 ....[48 spaces]"


Try:

<%
if Trim(rs.Fields.Item("field1").Value) = "-1" Then
response.write "true"
end if
%>

Ray at home

 

[dave]

thanx a lot, ray
its all working now using trim

-----Original Message-----
If it's char(50) as opposed to varchar(50), would the value be:

"-1 ....[48 spaces]"


Try:

<%
if Trim(rs.Fields.Item("field1").Value) = "-1" Then
response.write "true"
end if
%>

Ray at home

field1 char 50

.

 

[Lasse Edsvik]

dave,


if trim(rs("field1")) = "-1" Then
response.write ("true")
end if

/Lasse