|
| |
|
|
BerylSmall
Posts: 33
Joined: 8/8/2005
Status: offline
 |
RE: get values from dynamic dropdown - 8/15/2005 1:12:12
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=windows-1252">
<meta name="GENERATOR" content="Microsoft FrontPage 4.0">
<meta name="ProgId" content="FrontPage.Editor.Document">
<title>Picture</title>
</head>
<body>
<table width="898" border="1">
<thead>
<tr>
<td width="165"><b>Picture</b></td>
<td width="137"><b>Style</b></td>
<td width="66"><b>Color</b></td>
<td width="65"><b>Size</b></td>
<td width="225"> </td>
<td width="225"><b>Description</b></td>
<td width="132"><b>Retail_Price</b></td>
<td width="78">Add to Cart</td>
</tr>
</thead>
<tbody>
<tr>
<td width="165"><a href="ProductPage.asp?Style=5505"><img border="0" src="C:\Inetpub\wwwroot\ModeleStyle6\ProductPictures\5505.jpg" width="250" height="250">
</a>
</td>
<td width="137">5505
</td>
<td width="66"><p><strong>Color:</strong> <select name='Product' ID='Color' Size='1'><option>DEN</option></select><br>
</td>
<td width="65"><p><strong>Size:</strong> <select name='Product' ID='Size' Size='1'><option>L</option><option>S</option></select><br>
</td>
<td width="225">
<a href="http://ww9.aitsafe.com/cf/add.cfm?userid=B828873&product=apple bottom slvls vest+'Test'&price=54"><img border="0" src="../images/ADDButton.gif"></a>
</td>
<td width="225">apple bottom slvls vest
</td>
<td width="132">54
</td>
<td width="78"><form action="http://ww9.aitsafe.com/cf/add.cfm" method="post">
<input type="hidden" name="userid" value="B828873">
<input type="hidden" name="return" value="http://localhost/Test2/applebottoms.asp">
<table width="100%" border="0" bgcolor="#f5f5f5">
<tr>
<td width="80%">
Select your size :
<input type="hidden" name="product[]" value="apple bottom slvls vest">
<select name="Product[]" Size='1'>
<option value=L>L</option><option value=S>S</option>
</select><br>
Color :
<select name="product[]">
<option value="Red">Red</option>
<option value="Navy">Navy</option>
<option value="Green">Green</option>
</select>
</td>
<td>
<input type="hidden" name="price" value="54">
<input type="submit" value="Buy Now!">
</td>
</tr>
</table>
</form> </td>
</tr>
<tr>
<td width="165"><a href="ProductPage.asp?Style=AB5316"><img border="0" src="C:\Inetpub\wwwroot\ModeleStyle6\ProductPictures\ab5316.jpg" width="250" height="250">
</a>
</td>
<td width="137">AB5316
</td>
<td width="66"><p><strong>Color:</strong> <select name='Product' ID='Color' Size='1'><option>BLU</option><option>LME</option><option>PNK</option></select><br>
</td>
<td width="65"><p><strong>Size:</strong> <select name='Product' ID='Size' Size='1'><option>L</option><option>M</option><option>S</option><option>XL</option></select><br>
</td>
<td width="225">
<a href="http://ww9.aitsafe.com/cf/add.cfm?userid=B828873&product=Baby Doll Top+'Test'&price=34"><img border="0" src="../images/ADDButton.gif"></a>
</td>
<td width="225">Baby Doll Top
</td>
<td width="132">34
</td>
<td width="78"><form action="http://ww9.aitsafe.com/cf/add.cfm" method="post">
<input type="hidden" name="userid" value="B828873">
<input type="hidden" name="return" value="http://localhost/Test2/applebottoms.asp">
<table width="100%" border="0" bgcolor="#f5f5f5">
<tr>
<td width="80%">
Select your size :
<input type="hidden" name="product[]" value="Baby Doll Top">
<select name="Product[]" Size='1'>
<option value=L>L</option><option value=M>M</option><option value=S>S</option><option value=XL>XL</option>
</select><br>
Color :
<select name="product[]">
<option value="Red">Red</option>
<option value="Navy">Navy</option>
<option value="Green">Green</option>
</select>
</td>
<td>
<input type="hidden" name="price" value="34">
<input type="submit" value="Buy Now!">
</td>
</tr>
</table>
</form> </td>
</tr>
<tr>
<td width="165"><a href="ProductPage.asp?Style=AB5319"><img border="0" src="C:\Inetpub\wwwroot\ModeleStyle6\ProductPictures\ab5319.jpg" width="250" height="250">
</a>
</td>
<td width="137">AB5319
</td>
<td width="66"><p><strong>Color:</strong> <select name='Product' ID='Color' Size='1'><option>LEM</option><option>WHT</option></select><br>
</td>
<td width="65"><p><strong>Size:</strong> <select name='Product' ID='Size' Size='1'><option>L</option><option>M</option><option>S</option><option>XL</option></select><br>
</td>
<td width="225">
<a href="http://ww9.aitsafe.com/cf/add.cfm?userid=B828873&product=Short sleeve V-neck+'Test'&price=32"><img border="0" src="../images/ADDButton.gif"></a>
</td>
<td width="225">Short sleeve V-neck
</td>
<td width="132">32
</td>
<td width="78"><form action="http://ww9.aitsafe.com/cf/add.cfm" method="post">
<input type="hidden" name="userid" value="B828873">
<input type="hidden" name="return" value="http://localhost/Test2/applebottoms.asp">
<table width="100%" border="0" bgcolor="#f5f5f5">
<tr>
<td width="80%">
Select your size :
<input type="hidden" name="product[]" value="Short sleeve V-neck">
<select name="Product[]" Size='1'>
<option value=L>L</option><option value=M>M</option><option value=S>S</option><option value=XL>XL</option>
</select><br>
Color :
<select name="product[]">
<option value="Red">Red</option>
<option value="Navy">Navy</option>
<option value="Green">Green</option>
</select>
</td>
<td>
<input type="hidden" name="price" value="32">
<input type="submit" value="Buy Now!">
</td>
</tr>
</table>
</form> </td>
</tr>
<tr>
<td width="165"><a href="ProductPage.asp?Style=AB5322"><img border="0" src="C:\Inetpub\wwwroot\ModeleStyle6\ProductPictures\ab5322.jpg" width="250" height="250">
</a>
</td>
<td width="137">AB5322
</td>
<td width="66"><p><strong>Color:</strong> <select name='Product' ID='Color' Size='1'><option>BLU</option><option>LME</option><option>WHT</option></select><br>
</td>
<td width="65"><p><strong>Size:</strong> <select name='Product' ID='Size' Size='1'><option>L</option><option>M</option><option>XL</option></select><br>
</td>
<td width="225">
<a href="http://ww9.aitsafe.com/cf/add.cfm?userid=B828873&product=Front Rouched Tank+'Test'&price=34"><img border="0" src="../images/ADDButton.gif"></a>
</td>
<td width="225">Front Rouched Tank
</td>
<td width="132">34
</td>
<td width="78"><form action="http://ww9.aitsafe.com/cf/add.cfm" method="post">
<input type="hidden" name="userid" value="B828873">
<input type="hidden" name="return" value="http://localhost/Test2/applebottoms.asp">
<table width="100%" border="0" bgcolor="#f5f5f5">
<tr>
<td width="80%">
Select your size :
<input type="hidden" name="product[]" value="Front Rouched Tank">
<select name="Product[]" Size='1'>
<option value=L>L</option><option value=M>M</option><option value=XL>XL</option>
</select><br>
Color :
<select name="product[]">
<option value="Red">Red</option>
<option value="Navy">Navy</option>
<option value="Green">Green</option>
</select>
</td>
<td>
<input type="hidden" name="price" value="34">
<input type="submit" value="Buy Now!">
</td>
</tr>
</table>
</form> </td>
</tr>
<tr>
<td width="165"><a href="ProductPage.asp?Style=AB5511"><img border="0" src="C:\Inetpub\wwwroot\ModeleStyle6\ProductPictures\ab5511.jpg" width="250" height="250">
</a>
</td>
<td width="137">AB5511
</td>
<td width="66"><p><strong>Color:</strong> <select name='Product' ID='Color' Size='1'><option>RED</option></select><br>
</td>
<td width="65"><p><strong>Size:</strong> <select name='Product' ID='Size' Size='1'><option>10</option><option>12</option><option>14</option><option>2</option><option>4</option><option>6</option><option>8</option></select><br>
</td>
<td width="225">
<a href="http://ww9.aitsafe.com/cf/add.cfm?userid=B828873&product=Core Dye Capri+'Test'&price=60"><img border="0" src="../images/ADDButton.gif"></a>
</td>
<td width="225">Core Dye Capri
</td>
<td width="132">60
</td>
<td width="78"><form action="http://ww9.aitsafe.com/cf/add.cfm" method="post">
<input type="hidden" name="userid" value="B828873">
<input type="hidden" name="return" value="http://localhost/Test2/applebottoms.asp">
<table width="100%" border="0" bgcolor="#f5f5f5">
<tr>
<td width="80%">
Select your size :
<input type="hidden" name="product[]" value="Core Dye Capri">
<select name="Product[]" Size='1'>
<option value=10>10</option><option value=12>12</option><option value=14>14</option><option value=2>2</option><option value=4>4</option><option value=6>6</option><option value=8>8</option>
</select><br>
Color :
<select name="product[]">
<option value="Red">Red</option>
<option value="Navy">Navy</option>
<option value="Green">Green</option>
</select>
</td>
<td>
<input type="hidden" name="price" value="60">
<input type="submit" value="Buy Now!">
</td>
</tr>
</table>
</form> </td>
</tr>
<TR><TD ALIGN=LEFT VALIGN=MIDDLE COLSPAN=4><FORM NAME="fpdbr_0" ACTION="/test2/Mall/AppleBottoms.asp" TARGET="_self" METHOD=POST><NOBR><INPUT TYPE=Button NAME="fpdbr_0_PagingMove" VALUE=" -- "><INPUT TYPE=Button NAME="fpdbr_0_PagingMove" VALUE=" -- "><INPUT TYPE=Submit NAME="fpdbr_0_PagingMove" VALUE=" > "><INPUT TYPE=Submit NAME="fpdbr_0_PagingMove" VALUE=" >| "> [1/3]</NOBR></FORM></TD></TR>
</tbody>
</table>
</body>
</html>
< Message edited by Spooky -- 8/15/2005 1:25:57 >
|
|
|
|
BerylSmall
Posts: 33
Joined: 8/8/2005
Status: offline
|
RE: get values from dynamic dropdown - 8/15/2005 1:31:59
Can;t post URL. Server is not available on internet. Was that not the source code you wanted?
| |
|
|
|
BerylSmall
Posts: 33
Joined: 8/8/2005
Status: offline
|
RE: get values from dynamic dropdown - 8/15/2005 1:56:36
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=windows-1252">
<meta name="GENERATOR" content="Microsoft FrontPage 4.0">
<meta name="ProgId" content="FrontPage.Editor.Document">
<title>Picture</title>
</head>
<body>
<table width="898" border="1">
<thead>
<tr>
<td width="165"><b>Picture</b></td>
<td width="137"><b>Style</b></td>
<td width="66"><b>Color</b></td>
<td width="65"><b>Size</b></td>
<td width="225"> </td>
<td width="225"><b>Description</b></td>
<td width="132"><b>Retail_Price</b></td>
<td width="78">Add to Cart</td>
</tr>
</thead>
<tbody>
<tr>
<td width="165"><a href="ProductPage.asp?Style=5505"><img border="0" src="C:\Inetpub\wwwroot\ModeleStyle6\ProductPictures\5505.jpg" width="250" height="250">
</a>
</td>
<td width="137">5505
</td>
<td width="66"><p><strong>Color:</strong> <select name='Product' ID='Color' Size='1'><option>DEN</option></select><br>
</td>
<td width="65"><p><strong>Size:</strong> <select name='Product' ID='Size' Size='1'><option>L</option><option>S</option></select><br>
</td>
<td width="225">
<a href="http://ww9.aitsafe.com/cf/add.cfm?userid=B828873&product=apple bottom slvls vest+'Test'&price=54"><img border="0" src="../images/ADDButton.gif"></a>
</td>
<td width="225">apple bottom slvls vest
</td>
<td width="132">54
</td>
<td width="78"><form action="http://ww9.aitsafe.com/cf/add.cfm" method="post">
<input type="hidden" name="userid" value="B828873">
<input type="hidden" name="return" value="http://localhost/Test2/applebottoms.asp">
<table width="100%" border="0" bgcolor="#f5f5f5">
<tr>
<td width="80%">
Select your size :
<input type="hidden" name="product[]" value="apple bottom slvls vest">
<select name="Product[]" Size='1'>
<option value=L>L</option>
<option value=S>S</option>
</select><br>
Color :
<select name="product[]">
<option value="Red">Red</option>
<option value="Navy">Navy</option>
<option value="Green">Green</option>
</select>
</td>
<td>
<input type="hidden" name="price" value="54">
<input type="submit" value="Buy Now!">
</td>
</tr>
</table>
</form> </td>
</tr>
<tr>
<td width="165"><a href="ProductPage.asp?Style=AB5316"><img border="0" src="C:\Inetpub\wwwroot\ModeleStyle6\ProductPictures\ab5316.jpg" width="250" height="250">
</a>
</td>
<td width="137">AB5316
</td>
<td width="66"><p><strong>Color:</strong> <select name='Product' ID='Color' Size='1'><option>BLU</option><option>LME</option><option>PNK</option></select><br>
</td>
<td width="65"><p><strong>Size:</strong> <select name='Product' ID='Size' Size='1'><option>L</option><option>M</option><option>S</option><option>XL</option></select><br>
</td>
<td width="225">
<a href="http://ww9.aitsafe.com/cf/add.cfm?userid=B828873&product=Baby Doll Top+'Test'&price=34"><img border="0" src="../images/ADDButton.gif"></a>
</td>
<td width="225">Baby Doll Top
</td>
<td width="132">34
</td>
<td width="78"><form action="http://ww9.aitsafe.com/cf/add.cfm" method="post">
<input type="hidden" name="userid" value="B828873">
<input type="hidden" name="return" value="http://localhost/Test2/applebottoms.asp">
<table width="100%" border="0" bgcolor="#f5f5f5">
<tr>
<td width="80%">
Select your size :
<input type="hidden" name="product[]" value="Baby Doll Top">
<select name="Product[]" Size='1'>
<option value=L>L</option>
<option value=M>M</option>
<option value=S>S</option>
<option value=XL>XL</option>
</select><br>
Color :
<select name="product[]">
<option value="Red">Red</option>
<option value="Navy">Navy</option>
<option value="Green">Green</option>
</select>
</td>
<td>
<input type="hidden" name="price" value="34">
<input type="submit" value="Buy Now!">
</td>
</tr>
</table>
</form> </td>
</tr>
<tr>
<td width="165"><a href="ProductPage.asp?Style=AB5319"><img border="0" src="C:\Inetpub\wwwroot\ModeleStyle6\ProductPictures\ab5319.jpg" width="250" height="250">
</a>
</td>
<td width="137">AB5319
</td>
<td width="66"><p><strong>Color:</strong> <select name='Product' ID='Color' Size='1'><option>LEM</option><option>WHT</option></select><br>
</td>
<td width="65"><p><strong>Size:</strong> <select name='Product' ID='Size' Size='1'><option>L</option><option>M</option><option>S</option><option>XL</option></select><br>
</td>
<td width="225">
<a href="http://ww9.aitsafe.com/cf/add.cfm?userid=B828873&product=Short sleeve V-neck+'Test'&price=32"><img border="0" src="../images/ADDButton.gif"></a>
</td>
<td width="225">Short sleeve V-neck
</td>
<td width="132">32
</td>
<td width="78"><form action="http://ww9.aitsafe.com/cf/add.cfm" method="post">
<input type="hidden" name="userid" value="B828873">
<input type="hidden" name="return" value="http://localhost/Test2/applebottoms.asp">
<table width="100%" border="0" bgcolor="#f5f5f5">
<tr>
<td width="80%">
Select your size :
<input type="hidden" name="product[]" value="Short sleeve V-neck">
<select name="Product[]" Size='1'>
<option value=L>L</option>
<option value=M>M</option>
<option value=S>S</option>
<option value=XL>XL</option>
</select><br>
Color :
<select name="product[]">
<option value="Red">Red</option>
<option value="Navy">Navy</option>
<option value="Green">Green</option>
</select>
</td>
<td>
<input type="hidden" name="price" value="32">
<input type="submit" value="Buy Now!">
</td>
</tr>
</table>
</form> </td>
</tr>
<tr>
<td width="165"><a href="ProductPage.asp?Style=AB5322"><img border="0" src="C:\Inetpub\wwwroot\ModeleStyle6\ProductPictures\ab5322.jpg" width="250" height="250">
</a>
</td>
<td width="137">AB5322
</td>
<td width="66"><p><strong>Color:</strong> <select name='Product' ID='Color' Size='1'><option>BLU</option><option>LME</option><option>WHT</option></select><br>
</td>
<td width="65"><p><strong>Size:</strong> <select name='Product' ID='Size' Size='1'><option>L</option><option>M</option><option>XL</option></select><br>
</td>
<td width="225">
<a href="http://ww9.aitsafe.com/cf/add.cfm?userid=B828873&product=Front Rouched Tank+'Test'&price=34"><img border="0" src="../images/ADDButton.gif"></a>
</td>
<td width="225">Front Rouched Tank
</td>
<td width="132">34
</td>
<td width="78"><form action="http://ww9.aitsafe.com/cf/add.cfm" method="post">
<input type="hidden" name="userid" value="B828873">
<input type="hidden" name="return" value="http://localhost/Test2/applebottoms.asp">
<table width="100%" border="0" bgcolor="#f5f5f5">
<tr>
<td width="80%">
Select your size :
<input type="hidden" name="product[]" value="Front Rouched Tank">
<select name="Product[]" Size='1'>
<option value=L>L</option>
<option value=M>M</option>
<option value=XL>XL</option>
</select><br>
Color :
<select name="product[]">
<option value="Red">Red</option>
<option value="Navy">Navy</option>
<option value="Green">Green</option>
</select>
</td>
<td>
<input type="hidden" name="price" value="34">
<input type="submit" value="Buy Now!">
</td>
</tr>
</table>
</form> </td>
</tr>
<tr>
<td width="165"><a href="ProductPage.asp?Style=AB5511"><img border="0" src="C:\Inetpub\wwwroot\ModeleStyle6\ProductPictures\ab5511.jpg" width="250" height="250">
</a>
</td>
<td width="137">AB5511
</td>
<td width="66"><p><strong>Color:</strong> <select name='Product' ID='Color' Size='1'><option>RED</option></select><br>
</td>
<td width="65"><p><strong>Size:</strong> <select name='Product' ID='Size' Size='1'><option>10</option><option>12</option><option>14</option><option>2</option><option>4</option><option>6</option><option>8</option></select><br>
</td>
<td width="225">
<a href="http://ww9.aitsafe.com/cf/add.cfm?userid=B828873&product=Core Dye Capri+'Test'&price=60"><img border="0" src="../images/ADDButton.gif"></a>
</td>
<td width="225">Core Dye Capri
</td>
<td width="132">60
</td>
<td width="78"><form action="http://ww9.aitsafe.com/cf/add.cfm" method="post">
<input type="hidden" name="userid" value="B828873">
<input type="hidden" name="return" value="http://localhost/Test2/applebottoms.asp">
<table width="100%" border="0" bgcolor="#f5f5f5">
<tr>
<td width="80%">
Select your size :
<input type="hidden" name="product[]" value="Core Dye Capri">
<select name="Product[]" Size='1'>
<option value=10>10</option>
<option value=12>12</option>
<option value=14>14</option>
<option value=2>2</option>
<option value=4>4</option>
<option value=6>6</option>
<option value=8>8</option>
</select><br>
Color :
<select name="product[]">
<option value="Red">Red</option>
<option value="Navy">Navy</option>
<option value="Green">Green</option>
</select>
</td>
<td>
<input type="hidden" name="price" value="60">
<input type="submit" value="Buy Now!">
</td>
</tr>
</table>
</form> </td>
</tr>
<TR><TD ALIGN=LEFT VALIGN=MIDDLE COLSPAN=4><FORM NAME="fpdbr_0" ACTION="/test2/Mall/AppleBottoms.asp" TARGET="_self" METHOD=POST><NOBR><INPUT TYPE=Button NAME="fpdbr_0_PagingMove" VALUE=" -- "><INPUT TYPE=Button NAME="fpdbr_0_PagingMove" VALUE=" -- "><INPUT TYPE=Submit NAME="fpdbr_0_PagingMove" VALUE=" > "><INPUT TYPE=Submit NAME="fpdbr_0_PagingMove" VALUE=" >| "> [1/3]</NOBR></FORM></TD></TR>
</tbody>
</table>
</body>
</html>
< Message edited by Spooky -- 8/15/2005 5:20:13 >
| |
|
|
|
BerylSmall
Posts: 33
Joined: 8/8/2005
Status: offline
|
RE: get values from dynamic dropdown - 8/15/2005 2:35:51
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=windows-1252">
<meta name="GENERATOR" content="Microsoft FrontPage 4.0">
<meta name="ProgId" content="FrontPage.Editor.Document">
<title>Picture</title>
</head>
<body>
<table width="898" border="1">
<thead>
<tr>
<td width="165"><b>Picture</b></td>
<td width="137"><b>Style</b></td>
<td width="66"><b>Color</b></td>
<td width="65"><b>Size</b></td>
<td width="225"> </td>
<td width="225"><b>Description</b></td>
<td width="132"><b>Retail_Price</b></td>
<td width="78">Add to Cart</td>
</tr>
</thead>
<tbody>
<!--webbot bot="DatabaseRegionStart" startspan
s-columnnames="Style,Description,Picture,Retail_Price"
s-columntypes="202,202,203,6" s-dataconnection="Products"
b-tableformat="TRUE" b-menuformat="FALSE" s-menuchoice s-menuvalue
b-tableborder="TRUE" b-tableexpand="TRUE" b-tableheader="TRUE"
b-listlabels="TRUE" b-listseparator="TRUE" i-ListFormat="0"
b-makeform="TRUE" s-recordsource
s-displaycolumns="Picture,Style,Description,Retail_Price" s-criteria s-order
s-sql="SELECT Distinct Products.Style,Description,Picture,Retail_Price FROM Query1"
b-procedure="FALSE" clientside SuggestedExt="asp" s-DefaultFields
s-NoRecordsFound="No records returned." i-MaxRecords="256" i-GroupSize="5"
BOTID="0" u-dblib="../_fpclass/fpdblib.inc" u-dbrgn1="../_fpclass/fpdbrgn1.inc"
u-dbrgn2="../_fpclass/fpdbrgn2.inc" tag="TBODY"
local_preview="<tr><td colspan=64 bgcolor="#FFFF00" align="left" width="100%"><font color="#000000">Database Results regions will not preview unless this page is fetched from a Web server with a web browser. The following table row will repeat once for every record returned by the query.</font></td></tr>"
preview="<tr><td colspan=64 bgcolor="#FFFF00" align="left" width="100%"><font color="#000000">This is the start of a Database Results region.</font></td></tr>" --><!--#include file="../_fpclass/fpdblib.inc"-->
<%
fp_sQry="SELECT Distinct Products.Style,Description,Picture,Retail_Price FROM Query1"
fp_sDefault=""
fp_sNoRecords="<tr><td colspan=4 align=left width=""100%"">No records returned.</td></tr>"
fp_sDataConn="Products"
fp_iMaxRecords=256
fp_iCommandType=1
fp_iPageSize=5
fp_fTableFormat=True
fp_fMenuFormat=False
fp_sMenuChoice=""
fp_sMenuValue=""
fp_iDisplayCols=4
fp_fCustomQuery=True
BOTID=0
fp_iRegion=BOTID
%>
<!--#include file="../_fpclass/fpdbrgn1.inc"-->
<!--webbot bot="DatabaseRegionStart" i-CheckSum="43172" endspan -->
<tr>
<td width="165"><a href="ProductPage.asp?Style=<%=FP_FieldURL(fp_rs,"Style")%>"><img border="0" src="<%=FP_FieldLink(fp_rs,"Picture")%>" width="250" height="250">
</a>
</td>
<td width="137"><!--webbot bot="DatabaseResultColumn" startspan
s-columnnames="Style,Description,Picture,Retail_Price" s-column="Style"
b-tableformat="TRUE" b-hasHTML="FALSE" clientside
local_preview="<font size="-1"><<</font>Style<font size="-1">>></font>"
preview="<font size="-1"><<</font>Style<font size="-1">>></font>" --><%=FP_FieldVal(fp_rs,"Style")%><!--webbot
bot="DatabaseResultColumn" i-CheckSum="10122" endspan -->
</td>
<td width="66"><!--webbot bot="HTMLMarkup" startspan --><%
Response.Write "<p><strong>Color:</strong> <select name='Product' ID='Color' Size='1'>"
Set rsSample = Server.CreateObject("ADODB.Recordset")
rsSample.Open "Select Distinct Color from Query1 where Products.Style='" & FP_FieldVal(fp_rs,"Style") & "'", fp_conn
While not rsSample.EOF
Response.Write "<option>" & rsSample.Fields("Color") & "</option>"
rsSample.MoveNext
Wend
rsSample.Close
Response.Write "</select><br>"
%>
<!--webbot bot="HTMLMarkup" endspan -->
</td>
<td width="65"><!--webbot bot="HTMLMarkup" startspan --><%
Response.Write "<p><strong>Size:</strong> <select name='Product' ID='Size' Size='1'>"
Set rsSample = Server.CreateObject("ADODB.Recordset")
rsSample.Open "Select Distinct Garment_Size from Query1 where Products.Style='" & FP_FieldVal(fp_rs,"Style") & "' ORDER BY Garment_Size ASC", fp_conn
While not rsSample.EOF
Response.Write "<option>" & rsSample.Fields("Garment_Size") & "</option>"
rsSample.MoveNext
Wend
rsSample.Close
Response.Write "</select><br>"
%>
<!--webbot bot="HTMLMarkup" endspan -->
</td>
<td width="225"><!--webbot bot="HTMLMarkup" startspan -->
<a href="http://ww9.aitsafe.com/cf/add.cfm?userid=B828873&product=<%=FP_FieldVal(fp_rs,"Description")%>+'Test'&price=<%=FP_FieldVal(fp_rs,"Retail_Price")%>"><img border="0" src="../images/ADDButton.gif"></a>
<!--webbot
bot="HTMLMarkup" endspan -->
</td>
<td width="225"><!--webbot bot="DatabaseResultColumn" startspan
s-columnnames="Style,Description,Picture,Retail_Price"
s-column="Description" b-tableformat="TRUE" b-hasHTML="FALSE" clientside
local_preview="<font size="-1"><<</font>Description<font size="-1">>></font>"
preview="<font size="-1"><<</font>Description<font size="-1">>></font>" --><%=FP_FieldVal(fp_rs,"Description")%><!--webbot
bot="DatabaseResultColumn" i-CheckSum="30092" endspan -->
</td>
<td width="132"><!--webbot bot="DatabaseResultColumn" startspan
s-columnnames="Style,Description,Picture,Retail_Price"
s-column="Retail_Price" b-tableformat="TRUE" b-hasHTML="FALSE"
clientside
local_preview="<font size="-1"><<</font>Retail_Price<font size="-1">>></font>"
preview="<font size="-1"><<</font>Retail_Price<font size="-1">>></font>" --><%=FP_FieldVal(fp_rs,"Retail_Price")%><!--webbot
bot="DatabaseResultColumn" i-CheckSum="31068" endspan -->
</td>
<td width="78"><form action="http://ww9.aitsafe.com/cf/add.cfm" method="post">
<input type="hidden" name="userid" value="B828873">
<input type="hidden" name="return" value="http://localhost/Test2/applebottoms.asp">
<table width="100%" border="0" bgcolor="#f5f5f5">
<tr>
<td width="80%">
Select your size :
<input type="hidden" name="product[]" value="<%=FP_FieldVal(fp_rs,"Description")%>">
<select name="Product[]" Size='1'>
<%Set rsSample = Server.CreateObject("ADODB.Recordset")
rsSample.Open "Select Distinct Garment_Size from Query1 where Products.Style='" & FP_FieldVal(fp_rs,"Style") & "' ORDER BY Garment_Size ASC", fp_conn
While not rsSample.EOF
Response.Write "<option value=" & rsSample.Fields("Garment_Size") & ">" & rsSample.Fields("Garment_Size") & "</option>" & Chr(13)
rsSample.MoveNext
Wend
rsSample.Close%>
</select><br>
Color :
<select name="product[]">
<option value="Red">Red</option>
<option value="Navy">Navy</option>
<option value="Green">Green</option>
</select>
</td>
<td>
<input type="hidden" name="price" value="<%=FP_FieldVal(fp_rs,"Retail_Price")%>">
<input type="submit" value="Buy Now!">
</td>
</tr>
</table>
</form> </td>
</tr>
<!--webbot bot="DatabaseRegionEnd" startspan b-tableformat="TRUE"
b-menuformat="FALSE" u-dbrgn2="../_fpclass/fpdbrgn2.inc" i-groupsize="5"
clientside tag="TBODY"
local_preview="<tr><td colspan=64 bgcolor="#FFFF00" align="left" width="100%"><font color="#000000">This is the end of a Database Results region.</font></td></tr><TR><TD ALIGN=LEFT VALIGN=MIDDLE COLSPAN=64><FORM><NOBR><INPUT TYPE=Button VALUE=" |< "><INPUT TYPE=Button VALUE=" < "><INPUT TYPE=Button VALUE=" > "><INPUT TYPE=Button VALUE=" >| "> [1/5]</NOBR></FORM></td></tr>"
preview="<tr><td colspan=64 bgcolor="#FFFF00" align="left" width="100%"><font color="#000000">This is the end of a Database Results region.</font></td></tr><TR><TD ALIGN=LEFT VALIGN=MIDDLE COLSPAN=64><NOBR><INPUT TYPE=Button VALUE=" |< "><INPUT TYPE=Button VALUE=" < "><INPUT TYPE=Button VALUE=" > "><INPUT TYPE=Button VALUE=" >| "> [1/5]</NOBR><BR></td></tr>" --><!--#include file="../_fpclass/fpdbrgn2.inc"-->
<!--webbot bot="DatabaseRegionEnd" i-CheckSum="56926" endspan -->
</tbody>
</table>
</body>
</html>
< Message edited by Spooky -- 8/15/2005 5:20:31 >
| |
|
|
|
Spooky
Posts: 26603
Joined: 11/11/1998
From: Middle Earth
Status: offline
|
RE: get values from dynamic dropdown - 8/15/2005 3:31:56
Please try this one?
Keep a backup of the old one!!!
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=windows-1252">
<meta name="GENERATOR" content="Microsoft FrontPage 6.0">
<meta name="ProgId" content="FrontPage.Editor.Document">
<title>Picture</title>
</head>
<body>
<table width="898" border="1">
<thead>
<tr>
<td width="165"><b>Picture</b></td>
<td width="137"><b>Style</b></td>
<td width="66"><b>Color</b></td>
<td width="65"><b>Size</b></td>
<td width="225"> </td>
<td width="225"><b>Description</b></td>
<td width="132"><b>Retail_Price</b></td>
<td width="78">Add to Cart</td>
</tr>
</thead>
<tbody>
<!--#include file="../_fpclass/fpdblib.inc"-->
<%
fp_sQry="SELECT Distinct Products.Style,Description,Picture,Retail_Price FROM Query1"
fp_sDefault=""
fp_sNoRecords="<tr><td colspan=4 align=left width=""100%"">No records returned.</td></tr>"
fp_sDataConn="Products"
fp_iMaxRecords=256
fp_iCommandType=1
fp_iPageSize=5
fp_fTableFormat=True
fp_fMenuFormat=False
fp_sMenuChoice=""
fp_sMenuValue=""
fp_iDisplayCols=4
fp_fCustomQuery=True
BOTID=0
fp_iRegion=BOTID
%>
<!--#include file="../_fpclass/fpdbrgn1.inc"-->
<form action="http://ww9.aitsafe.com/cf/add.cfm" method="post">
<input type="hidden" name="userid" value="B828873">
<input type="hidden" name="return" value="http://localhost/Test2/applebottoms.asp">
<tr>
<td width="165"><a href="ProductPage.asp?Style=<%=FP_FieldURL(fp_rs,"Style")%>"><img border="0" src="<%=FP_FieldLink(fp_rs,"Picture")%>" width="250" height="250">
</a>
</td>
<td width="137"><%=FP_FieldVal(fp_rs,"Style")%>
</td>
<td width="66"><%
Response.Write "<p><strong>Color:</strong> <select name=""product[]"" ID=""Color"" Size=""1"">"
Set rsSample = Server.CreateObject("ADODB.Recordset")
rsSample.Open "Select Distinct Color from Query1 where Products.Style='" & FP_FieldVal(fp_rs,"Style") & "'", fp_conn
While not rsSample.EOF
Response.Write "<option>" & rsSample.Fields("Color") & "</option>"
rsSample.MoveNext
Wend
rsSample.Close
Response.Write "</select><br>"
%>
</td>
<td width="65"><%
Response.Write "<p><strong>Size:</strong> <select name=""product[]"" ID=""Size"" Size=""1"">"
Set rsSample = Server.CreateObject("ADODB.Recordset")
rsSample.Open "Select Distinct Garment_Size from Query1 where Products.Style='" & FP_FieldVal(fp_rs,"Style") & "' ORDER BY Garment_Size ASC", fp_conn
While not rsSample.EOF
Response.Write "<option>" & rsSample.Fields("Garment_Size") & "</option>"
rsSample.MoveNext
Wend
rsSample.Close
Response.Write "</select><br>"
%>
</td>
<td width="225">
<a href="http://ww9.aitsafe.com/cf/add.cfm?userid=B828873&product=<%=FP_FieldVal(fp_rs,"Description")%>+'Test'&price=<%=FP_FieldVal(fp_rs,"Retail_Price")%>"><img border="0" src="../images/ADDButton.gif"></a>
</td>
<td width="225"><%=FP_FieldVal(fp_rs,"Description")%>
</td>
<td width="132"><%=FP_FieldVal(fp_rs,"Retail_Price")%>
</td>
<td width="78">
<input type="hidden" name="price" value="<%=FP_FieldVal(fp_rs,"Retail_Price")%>">
<input type="submit" value="Buy Now!">
</td>
</tr>
</form>
<!--#include file="../_fpclass/fpdbrgn2.inc"-->
</tbody>
</table>
</body>
</html>
You will use the form submit button to send the record - not the link
_____________________________
If you arent part of the solution, then there is good money to be made prolonging the problem
§þ k¥
| |
|
|
|
BerylSmall
Posts: 33
Joined: 8/8/2005
Status: offline
|
RE: get values from dynamic dropdown - 8/15/2005 12:20:40
Okay, this has gotten so frustrating its almost funny.
Now, the options show up, but not the Description. Where is it should say something like:
Stonewash Denim Jacket, Green, XS
it just says
Green, XS
BEFORE it said
Stonewash Denim Jacket
I think maybe you're on to something! Let me thank you in the meantime for helping me with this. This has been extremely nerve-racking, and I just wanted you to know that I really do appreciate the time you have spent trying to help me with this.
| |
|
|
|
Spooky
Posts: 26603
Joined: 11/11/1998
From: Middle Earth
Status: offline
|
RE: get values from dynamic dropdown - 8/15/2005 15:26:26
This should be the final one :-)
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=windows-1252">
<meta name="GENERATOR" content="Microsoft FrontPage 6.0">
<meta name="ProgId" content="FrontPage.Editor.Document">
<title>Picture</title>
</head>
<body>
<table width="898" border="1">
<thead>
<tr>
<td width="165"><b>Picture</b></td>
<td width="137"><b>Style</b></td>
<td width="66"><b>Color</b></td>
<td width="65"><b>Size</b></td>
<td width="225"> </td>
<td width="225"><b>Description</b></td>
<td width="132"><b>Retail_Price</b></td>
<td width="78">Add to Cart</td>
</tr>
</thead>
<tbody>
<!--#include file="../_fpclass/fpdblib.inc"-->
<%
fp_sQry="SELECT Distinct Products.Style,Description,Picture,Retail_Price FROM Query1"
fp_sDefault=""
fp_sNoRecords="<tr><td colspan=4 align=left width=""100%"">No records returned.</td></tr>"
fp_sDataConn="Products"
fp_iMaxRecords=256
fp_iCommandType=1
fp_iPageSize=5
fp_fTableFormat=True
fp_fMenuFormat=False
fp_sMenuChoice=""
fp_sMenuValue=""
fp_iDisplayCols=4
fp_fCustomQuery=True
BOTID=0
fp_iRegion=BOTID
%>
<!--#include file="../_fpclass/fpdbrgn1.inc"-->
<form action="http://ww9.aitsafe.com/cf/add.cfm" method="post">
<input type="hidden" name="userid" value="B828873">
<input type="hidden" name="return" value="http://localhost/Test2/applebottoms.asp">
<tr>
<td width="165"><a href="ProductPage.asp?Style=<%=FP_FieldURL(fp_rs,"Style")%>"><img border="0" src="<%=FP_FieldLink(fp_rs,"Picture")%>" width="250" height="250">
</a>
</td>
<td width="137"><%=FP_FieldVal(fp_rs,"Style")%>
</td>
<td width="66">
<input type="hidden" name="product[]" value="<%=FP_FieldVal(fp_rs,"Description")%>">
<%
Response.Write "<p><strong>Color:</strong> <select name=""product[]"" ID=""Color"" Size=""1"">"
Set rsSample = Server.CreateObject("ADODB.Recordset")
rsSample.Open "Select Distinct Color from Query1 where Products.Style='" & FP_FieldVal(fp_rs,"Style") & "'", fp_conn
While not rsSample.EOF
Response.Write "<option>" & rsSample.Fields("Color") & "</option>"
rsSample.MoveNext
Wend
rsSample.Close
Response.Write "</select><br>"
%>
</td>
<td width="65"><%
Response.Write "<p><strong>Size:</strong> <select name=""product[]"" ID=""Size"" Size=""1"">"
Set rsSample = Server.CreateObject("ADODB.Recordset")
rsSample.Open "Select Distinct Garment_Size from Query1 where Products.Style='" & FP_FieldVal(fp_rs,"Style") & "' ORDER BY Garment_Size ASC", fp_conn
While not rsSample.EOF
Response.Write "<option>" & rsSample.Fields("Garment_Size") & "</option>"
rsSample.MoveNext
Wend
rsSample.Close
Response.Write "</select><br>"
%>
</td>
<td width="225">
<a href="http://ww9.aitsafe.com/cf/add.cfm?userid=B828873&product=<%=FP_FieldVal(fp_rs,"Description")%>+'Test'&price=<%=FP_FieldVal(fp_rs,"Retail_Price")%>"><img border="0" src="../images/ADDButton.gif"></a>
</td>
<td width="225"><%=FP_FieldVal(fp_rs,"Description")%>
</td>
<td width="132"><%=FP_FieldVal(fp_rs,"Retail_Price")%>
</td>
<td width="78">
<input type="hidden" name="price" value="<%=FP_FieldVal(fp_rs,"Retail_Price")%>">
<input type="submit" value="Buy Now!">
</td>
</tr>
</form>
<!--#include file="../_fpclass/fpdbrgn2.inc"-->
</tbody>
</table>
</body>
</html>
_____________________________
If you arent part of the solution, then there is good money to be made prolonging the problem
§þk¥
| |
|
|
|
BerylSmall
Posts: 33
Joined: 8/8/2005
Status: offline
|
RE: get values from dynamic dropdown - 8/22/2005 13:38:25
In case anyone had this same problem, this line of code worked to pull the value of the dynamic dropdown:
<%
V_Color = request.querystring("Color")
Set rs = Server.CreateObject("ADODB.Recordset")
rs.Open "Select Distinct Color_Name from ProductDetails where Products.Style='" & FP_FieldVal(fp_rs,"Style") & "' ORDER BY Color_Name ASC", fp_conn
if v_Color = "" then
v_Color = rs("Color_Name")
end if
%>
<form method="POST" action="">
Color:
<select size="1" name="Color" onChange="window.location='<%=request.servervariables("Script_Name")%>?Color='+this.value;">
<%
While not rs.EOF
if rs("Color_Name") = v_Color then
%>
<option selected value="<%=rs("Color_Name")%>"><%=rs("Color_Name")%></option>
<%
else
%>
<option value="<%=rs("Color_name")%>"><%=rs("Color_name")%></option>
<% End If
rs.MoveNext
Wend
rs.Close
%>
</select>
<p></p>
Size:
<select size="1" name="Option">
<%
'strSQL = "Select Distinct Garment_Size from ProductDetails where Products.Style='20074738003' AND Color_Name='" & v_Color & "' ORDER BY Garment_Size"
'set rs = conn.execute(strSQL)
Set rs = Server.CreateObject("ADODB.Recordset")
rs.Open "Select Distinct Garment_Size from ProductDetails where Products.Style='" & FP_FieldVal(fp_rs,"Style") & "' AND Color_Name='" & v_Color & "' ORDER BY Garment_Size ASC", fp_conn
do while not rs.eof
%>
<option value="<%=rs("Garment_Size")%>"><%=rs("Garment_Size")%></option>
<%
rs.movenext
loop
%>
</select>
</form>
| |
|
 New Messages |
 No New Messages |
 Hot Topic w/ New Messages |
 Hot Topic w/o New Messages |
 Locked w/ New Messages |
 Locked w/o New Messages |
|
Post New Thread
Reply to Message
Post New Poll
Submit Vote
Delete My Own Post
Delete My Own Thread
Rate Posts
|
|
|
Printable Version 
