Swapping out ICQ

Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic

   I'm trying to swap out the ICQ option with a MySpace URL. 
I left the strICQNum as the variable to save having to change more than I have to (yes, I'm lazy).  Below are the pages and edits (original in red, new in blue) I've done but it's not working.

Register.asp
<input type="text" name="ICQ" id="ICQ" size="15" maxlength="15" value="<% = strICQNum %>" />

<input type="text" name="ICQ" id="ICQ" size="30" maxlength="50" value="<% = strICQNum %>" />

Member_profile.asp
<% If strTxtICQNumber = "" OR IsNull(strTxtICQNumber) Then Response.Write("Not Given") Else Response.Write(strTxtICQNumber) %>

<% If strICQNum = "" OR IsNull(strICQNum) Then Response.Write(strTxtNotGiven) Else Response.Write("<a href=""" & formatInput(strICQNum) & """ target=""_blank""><img src=""" & strImagePath & "myspace_icon.gif""  border=""0"" align=""absmiddle"" alt=""" & strICQNum & """ /></a>") %>
(I did this hoping that the code for the Homepage would work for linking to a Myspace URL)

language_file_inc.asp
Const strTxtICQNumber = "ICQ Number"

Const strTxtICQNumber = "MySpace URL"

database
Table: Author -> Design View -> Changed ICQ Field size to 55

-----
Here's the problem.  I go into my profile, put in a myspace url and submit.  It accepts my changes, but when I go to the Member Profile Page, I see the image that should take me to the URL, however it just takes me to http://www.domain.com/0 (it just add's the 0).

If I go back in to edit my profile, the Myspace URL is not in there anymore.

Where did I go wrong or what am I missing?