Can somebody help me with the below response.redirect problem. I'm trying to send a parameter back to a page.
<%@ LANGUAGE="VBSCRIPT" %>
<%response.buffer=true%>
<%
Set conn = server.createobject("adodb.connection"
DSNtemp="DRIVER={Microsoft Access Driver (*.mdb)}; "
DSNtemp=dsntemp & "DBQ=" & server.mappath("../../fpdb/PMData.mdb"
conn.Open DSNtemp
%>
<%
SurveyID = Request("SurveyID"
response.write(surveyID)
strRegion=Replace(Request("Region"
,"'","''"
'response.write("Region:"&strRegion&"<BR>"
strcomments=Replace(Request("comments"
,"'","''"
'response.write("comments:"&strcomments&"<BR>"
SQLStmt ="UPDATE bsasurvey SET BPReply = '"&strcomments & "' WHERE SurveyID= CINT('"&SurveyID&"')"
Set rs = conn.Execute(SQLstmt)%
response.redirect ("../Questions/HDBankPro.asp?Region="strRegion"
"
%>
I have tried several formats on the redirect, but can't get it to work
Thanks
response.redirect ("../Questions/HDBankPro.asp?Region=<%"strRegion"%>"
<%@ LANGUAGE="VBSCRIPT" %>
<%response.buffer=true%>
<%
Set conn = server.createobject("adodb.connection"
DSNtemp="DRIVER={Microsoft Access Driver (*.mdb)}; "
DSNtemp=dsntemp & "DBQ=" & server.mappath("../../fpdb/PMData.mdb"
conn.Open DSNtemp
%>
<%
SurveyID = Request("SurveyID"
response.write(surveyID)
strRegion=Replace(Request("Region"
'response.write("Region:"&strRegion&"<BR>"
strcomments=Replace(Request("comments"
'response.write("comments:"&strcomments&"<BR>"
SQLStmt ="UPDATE bsasurvey SET BPReply = '"&strcomments & "' WHERE SurveyID= CINT('"&SurveyID&"')"
Set rs = conn.Execute(SQLstmt)%
response.redirect ("../Questions/HDBankPro.asp?Region="strRegion"
%>
I have tried several formats on the redirect, but can't get it to work
Thanks
response.redirect ("../Questions/HDBankPro.asp?Region=<%"strRegion"%>"