Well, I am assuming that the value of getcccode != 456
(Since you posted this in the .NET forum I am assuming you are using .NET)
Some things to check, you declare codestate like this:
Dim codestate (While you can do this is in .NET and the variable has type system.object, its good practice to declare the variables type.)
Your if statement it checking the variable getccode (which you havent supplied to show us what the value of getcccode is) but i am assuming that the value is 456.
Are you sure the that Querystring varible is 456?
"The one language all programmers understand is profanity."