Help with 301 redirect code - jsp in url

[bsmith]

I'm trying to set a 301 redirect in my jsp code (this is tomcat btw) using this:

<%
response.setContentType("text/html");
response.setDateHeader("Expires", 0);
response.setHeader("Location", "http://www.mysite.com/record/pleasehelpme /helpmeheretoo");
response.setStatus(301);
%>

the pleasehelpme and helpmeheretoo need to use variable values i get from mysql which i would normally express in the application like

<%=(((Recordset1_data = Recordset1.getObject("avariable"))==null || Recordset1.wasNull())?"":Recordset1_data)%>

so what do i need to stick in those parts of the path in the url?
it works great redirecting to a flat url but I need those variable (well, that's the point of this anyway).
sticking the <%= recordset stuff %> is breaking since it's like a tag in a tag (i guess) - have tried variations on sticking println around (String)Recordset1.getObject("avariable") like
"http://www.mysite.com/record/(out.println(String)Recordset1.getObject("avariable"))"
and variations with curly braces and semicolons and everything but i keep getting
Syntax error on token "avalue", invalid AssignmentOperator
errors. (i'm obviously tring to figure out just one variable before i stick both in the path while i get this figured out).
can someone hit me with a clue stick?

[hooknc]

I'm trying to set a 301 redirect in my jsp code (this is tomcat btw) using this:

<%
response.setContentType("text/html");
response.setDateHeader("Expires", 0);
response.setHeader("Location", "http://www.mysite.com/record/pleasehelpme /helpmeheretoo");
response.setStatus(301);
%>

the pleasehelpme and helpmeheretoo need to use variable values i get from mysql which i would normally express in the application like

<%=(((Recordset1_data = Recordset1.getObject("avariable"))==null || Recordset1.wasNull())?"":Recordset1_data)%>

so what do i need to stick in those parts of the path in the url?
it works great redirecting to a flat url but I need those variable (well, that's the point of this anyway).
sticking the <%= recordset stuff %> is breaking since it's like a tag in a tag (i guess) - have tried variations on sticking println around (String)Recordset1.getObject("avariable") like
"http://www.mysite.com/record/(out.println(String)Recordset1.getObject("avariable"))"
and variations with curly braces and semicolons and everything but i keep getting
Syntax error on token "avalue", invalid AssignmentOperator
errors. (i'm obviously tring to figure out just one variable before i stick both in the path while i get this figured out).
can someone hit me with a clue stick?

You post is very confusing...but my guess is you need to do the following in your code...

// As long as there is a Recordset1 object by this time...
<% String variable1 = (String)Recordset1.getObject("avariable") %>
<% String variable2 = (String)Recordset2.getObject("avariable") %>
<% String url = "http://www.mysite.com/record" + variable1 + "/" + variable2 %>

<%
response.setContentType("text/html");
response.setDateHeader("Expires", 0);
response.setHeader("Location", url);
response.setStatus(301); 
%>

Regards,

Nate