Question
CFLOOP and OPTION selected
Hi, can anyone help.
Here is the basic idea, working on a shop which displays 9 tshirts, 3x3. Want the admin of the shop to be able to select which 9 shirts will be shown to the user.
I have a loop which puts all the items in order, and i know I could use individual cfqueries for every cell in the table, but thought Id try something better.
It seems to put 'selected' at most of the options in each drop down menu! not just the one currently chosen by the shop person the last time!
I want the loop to populate the drop down menus, and if the item is the current selection, then it is selected. not the others.
Can someone help.
This is the admin, very basic! The site
Many Thanks
code:
<cfif IsDefined("form.submit")>
<cfset loop = 1>
<cfloop index="i" from="1" to="9">
<cfset images = 'form.image' & #loop#>
<cfquery name="idshirt" ...
SELECT ShirtID, title, image
FROM proart
WHERE image = "#Evaluate("form.image" & loop)#"
</cfquery>
<cfquery name="update" ...
UPDATE proartmenu
SET image = "#idshirt.image#", ShirtID = "#idshirt.ShirtID#", title = "#idshirt.title#"
WHERE PicID = #loop#;
</cfquery>
<cfset loop = loop + 1>
</cfloop>
</cfif>
<cfquery name="shirts" ...
select * from proart;
</CFQUERY>
<CFSET max_seq = #shirts.recordcount#>
<CFSET max_rows = INT((#max_seq# +2)/3)>
<CFSET x = 0>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" " http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns=" http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>Untitled Document</title>
<style type="text/css">
.selected { background-color:#CCCCCC;}
</style>
</head>
<body><form id="form" name="form" method="post" action="pop.cfm">
<table width="90%" height="90" border="1" align="center">
<CFLOOP INDEX="seq_no" FROM="1" TO="#max_rows#">
<TR>
<CFLOOP INDEX="sequence" FROM="1" TO="3">
<CFSET x = x + 1>
<TD>
<select name="image<cfoutput>#x#</cfoutput>">
<cfoutput query="shirts">
<CFQUERY NAME="themenu" ...
SELECT * FROM proartmenu
WHERE PicID = #x#;
</CFQUERY>
<CFQUERY NAME="theshirts" ...">
SELECT * FROM proart;
</CFQUERY>
<cfif themenu.image IS NOT theshirts.image>
<option value="#Image#">#Title#</option>
<cfelse>
<option value="#Image#" selected="selected" class="selected">#Title#</option>
</cfif>
</cfoutput>
</select>
</TD>
</CFLOOP>
</TR>
</CFLOOP>
</table>
<input name="submit" type="submit" />
</form>
</body>
</html>
Here is the basic idea, working on a shop which displays 9 tshirts, 3x3. Want the admin of the shop to be able to select which 9 shirts will be shown to the user.
I have a loop which puts all the items in order, and i know I could use individual cfqueries for every cell in the table, but thought Id try something better.
It seems to put 'selected' at most of the options in each drop down menu! not just the one currently chosen by the shop person the last time!
I want the loop to populate the drop down menus, and if the item is the current selection, then it is selected. not the others.
Can someone help.
This is the admin, very basic! The site
Many Thanks
code:
<cfif IsDefined("form.submit")>
<cfset loop = 1>
<cfloop index="i" from="1" to="9">
<cfset images = 'form.image' & #loop#>
<cfquery name="idshirt" ...
SELECT ShirtID, title, image
FROM proart
WHERE image = "#Evaluate("form.image" & loop)#"
</cfquery>
<cfquery name="update" ...
UPDATE proartmenu
SET image = "#idshirt.image#", ShirtID = "#idshirt.ShirtID#", title = "#idshirt.title#"
WHERE PicID = #loop#;
</cfquery>
<cfset loop = loop + 1>
</cfloop>
</cfif>
<cfquery name="shirts" ...
select * from proart;
</CFQUERY>
<CFSET max_seq = #shirts.recordcount#>
<CFSET max_rows = INT((#max_seq# +2)/3)>
<CFSET x = 0>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" " http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns=" http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>Untitled Document</title>
<style type="text/css">
.selected { background-color:#CCCCCC;}
</style>
</head>
<body><form id="form" name="form" method="post" action="pop.cfm">
<table width="90%" height="90" border="1" align="center">
<CFLOOP INDEX="seq_no" FROM="1" TO="#max_rows#">
<TR>
<CFLOOP INDEX="sequence" FROM="1" TO="3">
<CFSET x = x + 1>
<TD>
<select name="image<cfoutput>#x#</cfoutput>">
<cfoutput query="shirts">
<CFQUERY NAME="themenu" ...
SELECT * FROM proartmenu
WHERE PicID = #x#;
</CFQUERY>
<CFQUERY NAME="theshirts" ...">
SELECT * FROM proart;
</CFQUERY>
<cfif themenu.image IS NOT theshirts.image>
<option value="#Image#">#Title#</option>
<cfelse>
<option value="#Image#" selected="selected" class="selected">#Title#</option>
</cfif>
</cfoutput>
</select>
</TD>
</CFLOOP>
</TR>
</CFLOOP>
</table>
<input name="submit" type="submit" />
</form>
</body>
</html>
AdChoices