<!--- sample query ONLY for testing ---->
<cfset getFlyerInfo = queryNew("")>
<cfset queryAddColumn(getFlyerInfo, "product_category", listToArray("CatA,CatB,CatC"))>
<cfset queryAddColumn(getFlyerInfo, "page_size", listToArray("Size10,Size20,Size30"))>
<cfset queryAddColumn(getFlyerInfo, "max_products", listToArray("Prod18,Prod22,Prod62"))>
<cfset queryAddColumn(getFlyerInfo, "max_images", listToArray("Img3,Img5,Img9"))>
<cfset queryAddColumn(getFlyerInfo, "price", listToArray("Price50,Price80,Price72"))>
<script type="text/javascript">
function categorySelected(list) {
var maxProducts = list.options[list.selectedIndex].getAttribute("max_products");
var maxImages = list.options[list.selectedIndex].getAttribute("max_images");
var price = list.options[list.selectedIndex].getAttribute("price");
document.getElementById('max_products').value = maxProducts;
document.getElementById('max_images').value = maxImages;
document.getElementById('price').value = price;
}
</script>
<cfoutput>
<cfform method="post" action="flyer_step3.cfm" name="flyer">
<cfselect name="page_size" id="page_size" onchange="javascript:categorySelected(this)">
<option value="" page_size=""
max_products=""
max_images=""
price="">-- Select Ad Size --</option>
<cfloop query="getFlyerInfo">
<option value="#getFlyerInfo.product_category#"
page_size="#getFlyerInfo.page_size#"
max_products="#getFlyerInfo.max_products#"
max_images="#getFlyerInfo.max_images#"
price="#getFlyerInfo.price#">
#getFlyerInfo.product_category#
</option>
</cfloop>
</cfselect>
<input type="text" name="max_products" size="30" readonly class="readonly">
<input type="text" name="max_images" size="30" readonly class="readonly">
<input type="text" name="price" size="30" readonly class="readonly">
</cfform>
</cfoutput>
select * from flyer_cost where product_category = '#product_category#'
</cfquery>
<cfquery name="getFlyerCat" datasource="#datasource#">
select DISTINCT(product_category)
</cfquery>
<cfoutput>
<script language="JavaScript">
function PopulateMe()
{
document.flyer.product_cat
document.flyer.page_size.v
document.flyer.max_product
document.flyer.max_images.
document.flyer.price.value
}
</script>
<cfform method="post" action="flyer_step3.cfm" name="flyer">
<table width="60%" border="0" align="center" cellpadding="2" cellspacing="5">
<tr>
<td>Product Category</td>
<td><cfselect name="product_category" id="product_category" onchange="javascript:Popul
<option value="">-- Select Product Category --</option>
<cfloop query="getFlyerCat">
<option value="#getFlyerCat.produc
</cfloop>
</cfselect></td>
</tr><tr>
<td>Ad Size</td>
<td><cfselect name="page_size" id="page_size" onchange="javascript:Popul
<option value="">-- Select Ad Size --</option>
<cfloop query="getFlyerInfo">
<option value="#getFlyerInfo.page_
</cfloop>
</cfselect></td>
</tr>
<tr>
<td>Max Products</td>
<td><input type="text" name="max_products" value="#getFlyerInfo.max_p
</tr>
<tr>
<td>Max Graphics</td>
<td><input type="text" name="max_images" value="#getFlyerInfo.max_i
</tr>
<tr>
<td>Price</td>
<td><input type="text" name="price" value="#getFlyerInfo.price
</tr>
<tr>
<td colspan="2" align="center"><cfinput type="submit" name="submit" value="Next ->>" /></td>
</tr>
</table>
</cfform>