storing an ip

[a8le]

currently i am trying to store user ip address for a control i am developing but when i store the ip's in SQL Server 2000... all i get is the first digit.

the test ip is 127.0.0.1, so all i get is "1" for all my ip's. upon submit i have a label displaying the ip's and it shows "127.0.0.1", again when i look into the table using enterprise manager... all i get is "1's".

i tested the stored value on page_load... for example... label1.text = storedValueFromdb and i get "1".

i am storing the ip's as a string... i have tried setting the column type as char, varchar, nvarchar... still the same.

i am collecting the ip's using "ipAddress = request.userhostaddress".

can someone enlighten me as to why this is happening? thnx in advance.

-a8le

 

[JohnH]

the char types are default length one character, you can specify the field length

 

[a8le]

like char(15) or varchar(50).... yeah i did that. thnx john

 

[a8le]

hi john, you were right. it was my stored procedure. i forgot the (15). Thanx again.