dakoz
Programmer
- Feb 2, 2002
- 74
hi all,
i have the following i have a form which take dynamically data from a database, i can see that i have retrieved everything correctly, but i submit the form all field having a space ie "Store Type" sends only Store
can i fix this problem??
here is some sample code i use :
<form action="left.asp" method="post" id="form1" name="form1" target="iframe">
<table align=center valign=top>
<tr>
<b>Cube Name: </b><br>
<SELECT class=price id="strCubeName" name="strCubeName" onchange="document.form1.submit();">
<%
For Each cube in cat.CubeDefs
IF cube.Name=Request.Form("strCubeName" THEN
Response.Write "<option selected>" & cube.Name & "</OPTION>"
ELSE
Response.Write "<option>" & cube.Name
END IF
Next
%>
</select>
</td>
</tr>
</table>
</form>
<BR><BR>
<TABLE WIDTH=100% ALIGN=CENTER cellpadding=0 cellspacing=0>
<TR><TD align=center valign=middle>
<FORM name="olapselect" target="main" method="post" action="main_sql1.asp">
<TABLE border=0>
<TBODY>
<TR>
<TD>
<TABLE>
<TR><TD align=left>DIMENSIONS</TD></TR>
<TR>
<TD>
<SELECT class=price size=15 multiple name=list1>
<%
IF Session("CubeName"<>"" THEN
For di = 0 To cdf.Dimensions.Count - 1
Response.Write "<option value="& cdf.Dimensions(di).Name &">"& cdf.Dimensions(di).Name &"</option>"
IF cdf.Dimensions(di).Name=Request.form("dimension" then
hi=di
END IF
NEXT
Response.Write "Members : "& cdf.Dimensions(0).Hierarchies(0).Levels(0).Members.Count
END IF
%>
</SELECT>
</TD>
</TR>
</TABLE>
</TD>
<TD>
<TABLE>
<TR>
<TD vAlign=center align=middle>
<INPUT onclick=moveSelectedOptions(this.form.list1,this.form.list2,true,this.form.movepattern1.value) type=button value=">>" name=rightrows><BR>
<INPUT onclick=moveSelectedOptions(this.form.list2,this.form.list1,true,this.form.movepattern1.value) type=button value="<<" name=leftcols><BR>
</TD>
<TD>
<TABLE>
<TR><TD>ROWS</TD></TR>
<TR>
<TD>
<SELECT class=price size=7 multiple name=list2></SELECT>
</TD>
</TR>
</TABLE>
</TD>
<TR>
<TD vAlign=center align=middle>
<INPUT onclick=moveSelectedOptions(this.form.list1,this.form.list3,true,this.form.movepattern1.value) type=button value=">>" name=rightcols><BR>
<INPUT onclick=moveSelectedOptions(this.form.list3,this.form.list1,true,this.form.movepattern1.value) type=button value="<<" name=leftcols><BR>
</TD>
<TD>
<TABLE>
<TR><TD>COLUMNS</TD></TR>
<TR>
<TD>
<SELECT class=price size=7 multiple name=list3></SELECT>
</TD>
</TR>
</TABLE>
</TD></TR>
</TABLE>
</TD>
<TR><TD>
Show Empty Rows<INPUT TYPE="CHECKBOX" NAME="emptyrows">
<TR>
<INPUT name=movepattern1 TYPE=HIDDEN>
</TD></TR>
<TR><TD><input type="submit" value="ShowCube" id="query" name="query" onclick="selAll(true)"></FORM></TD></TR></TBODY></TABLE>
</TD></TR></TABLE>
</TD><TD height=100% BACKGROUND="dot.gif"><IMG SRC="spacer.gif" width=6></TD></TR></TABLE>
</TABLE>
</BODY>
</HTML>
i have the following i have a form which take dynamically data from a database, i can see that i have retrieved everything correctly, but i submit the form all field having a space ie "Store Type" sends only Store
can i fix this problem??
here is some sample code i use :
<form action="left.asp" method="post" id="form1" name="form1" target="iframe">
<table align=center valign=top>
<tr>
<b>Cube Name: </b><br>
<SELECT class=price id="strCubeName" name="strCubeName" onchange="document.form1.submit();">
<%
For Each cube in cat.CubeDefs
IF cube.Name=Request.Form("strCubeName" THEN
Response.Write "<option selected>" & cube.Name & "</OPTION>"
ELSE
Response.Write "<option>" & cube.Name
END IF
Next
%>
</select>
</td>
</tr>
</table>
</form>
<BR><BR>
<TABLE WIDTH=100% ALIGN=CENTER cellpadding=0 cellspacing=0>
<TR><TD align=center valign=middle>
<FORM name="olapselect" target="main" method="post" action="main_sql1.asp">
<TABLE border=0>
<TBODY>
<TR>
<TD>
<TABLE>
<TR><TD align=left>DIMENSIONS</TD></TR>
<TR>
<TD>
<SELECT class=price size=15 multiple name=list1>
<%
IF Session("CubeName"<>"" THEN
For di = 0 To cdf.Dimensions.Count - 1
Response.Write "<option value="& cdf.Dimensions(di).Name &">"& cdf.Dimensions(di).Name &"</option>"
IF cdf.Dimensions(di).Name=Request.form("dimension" then
hi=di
END IF
NEXT
Response.Write "Members : "& cdf.Dimensions(0).Hierarchies(0).Levels(0).Members.Count
END IF
%>
</SELECT>
</TD>
</TR>
</TABLE>
</TD>
<TD>
<TABLE>
<TR>
<TD vAlign=center align=middle>
<INPUT onclick=moveSelectedOptions(this.form.list1,this.form.list2,true,this.form.movepattern1.value) type=button value=">>" name=rightrows><BR>
<INPUT onclick=moveSelectedOptions(this.form.list2,this.form.list1,true,this.form.movepattern1.value) type=button value="<<" name=leftcols><BR>
</TD>
<TD>
<TABLE>
<TR><TD>ROWS</TD></TR>
<TR>
<TD>
<SELECT class=price size=7 multiple name=list2></SELECT>
</TD>
</TR>
</TABLE>
</TD>
<TR>
<TD vAlign=center align=middle>
<INPUT onclick=moveSelectedOptions(this.form.list1,this.form.list3,true,this.form.movepattern1.value) type=button value=">>" name=rightcols><BR>
<INPUT onclick=moveSelectedOptions(this.form.list3,this.form.list1,true,this.form.movepattern1.value) type=button value="<<" name=leftcols><BR>
</TD>
<TD>
<TABLE>
<TR><TD>COLUMNS</TD></TR>
<TR>
<TD>
<SELECT class=price size=7 multiple name=list3></SELECT>
</TD>
</TR>
</TABLE>
</TD></TR>
</TABLE>
</TD>
<TR><TD>
Show Empty Rows<INPUT TYPE="CHECKBOX" NAME="emptyrows">
<TR>
<INPUT name=movepattern1 TYPE=HIDDEN>
</TD></TR>
<TR><TD><input type="submit" value="ShowCube" id="query" name="query" onclick="selAll(true)"></FORM></TD></TR></TBODY></TABLE>
</TD></TR></TABLE>
</TD><TD height=100% BACKGROUND="dot.gif"><IMG SRC="spacer.gif" width=6></TD></TR></TABLE>
</TABLE>
</BODY>
</HTML>