RE: get values from dynamic dropdown (Full Version)

All Forums >> [Web Development] >> Microsoft FrontPage Help



Message

Spooky -> RE: get values from dynamic dropdown (8/15/2005 1:08:59)

Is that from the browser?
If so its not working as the asp is still visible - it should be an .asp page. Is it?



BerylSmall -> 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>



Spooky -> RE: get values from dynamic dropdown (8/15/2005 1:30:01)

As in this post - http://www.frontpagewebmaster.com/m-282727/mpage-2/key-/tm.htm#

Could you post ALL the code from that page?
If I get a chance, Ill have a look in the morning
Are you able to post a URL of the current page?



BerylSmall -> 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?



Spooky -> RE: get values from dynamic dropdown (8/15/2005 1:51:36)

You didnt quite post all of the code.
Tahts the one above that starts with 

<table width="898" border="1">
  <thead>
    <tr>


Can you post the full code from frontpage for that?



BerylSmall -> 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>



Spooky -> RE: get values from dynamic dropdown (8/15/2005 2:30:26)

No, in frontpage (not the browser!) open the page in code view and paste that code here



BerylSmall -> 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>



Spooky -> 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



BerylSmall -> 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 -> 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>



BerylSmall -> 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>



Page: <<   < prev  1 [2]

Valid CSS!




Forum Software © ASPPlayground.NET Advanced Edition 2.4.5 ANSI
0.1425781