Hi Seona, is your query returning any results? An empty query can cause this kind of behaviour, as anything within the cfloop qill not be executed...
Toby Thursday, February 13, 2003, 4:15:56 PM, you wrote: SB> I believe that it is. All of my other selects have this option, and they all SB> work fine. In fact, if I take all the CF stuff from around the <option> tag, SB> the select works fine. So I'm guessing that what ever the problem is, it's SB> with the CF bits. SB> Thanks for the suggestion though. :) >> -----Original Message----- >> From: [EMAIL PROTECTED] >> [mailto:[EMAIL PROTECTED]]On Behalf Of Taco Fleur >> Sent: Thursday, 13 February 2003 3:48 PM >> To: CFAussie Mailing List >> Subject: [cfaussie] Re: Trying to figure out the syntax of a <cfif> >> statement >> >> >> Is the name="" a valid HTML attribute in a <option> tag? >> I believe not.. >> >> Try it without.. >> >> ----- Original Message ----- >> From: "Seona Bellamy" <[EMAIL PROTECTED]> >> To: "CFAussie Mailing List" <[EMAIL PROTECTED]> >> Sent: Thursday, February 13, 2003 2:15 PM >> Subject: [cfaussie] Trying to figure out the syntax of a <cfif> statement >> >> >> > Hi all! >> > >> > I have a table which lists the feats a character has taken. >> Some of these >> > feats have a focus associated with them. The table has a simple >> structure: >> > >> > ID >> > CharacterName >> > FeatName >> > FeatFocus >> > >> > FeatFocus my be empty, or take a value if the feat has a focus. >> > >> > In the page where users select a feat to add to their list, I >> want to make >> > sure that they don't add something they already have. I've managed the >> > filtering for the feats where the focus comes from another table (i.e., >> the >> > focus is on a skill, so the values they can select from are >> drawn from the >> > Skills table). Now I have a problem with one where I give a >> defined set of >> > values created by me. >> > >> > I have a query which selects all instances of the relevant feat and gets >> the >> > FeatFocus value. >> > >> > <cfquery name="q_SpellFocus" datasource="#request.dsn#"> >> > SELECT FeatFocus >> > FROM FeatsByCharacter >> > WHERE (CharacterName = '#request.session.CharacterName#') AND >> (FeatName = >> > 'Spell Focus') >> > </cfquery> >> > >> > Then I'm trying to check and see if each option appears in the query >> > results. I tried to do a "contains" in the <cfif> statement, >> but it didn't >> > seem to like that. So now I'm playing with loops, but this seems to wipe >> all >> > the results. This is what I have so far: >> > >> > <select name="SpF_Focus"> >> > <cfloop query="q_SpellFocus"> >> > <cfif q_SpellFocus.FeatFocus IS NOT "Abjuration"> >> > <option name="Abjuration" value="Abjuration">Abjuration</option> >> > </cfif> >> > <option name="Conjuration" value="Conjuration">Conjuration</option> >> > <option name="Divination" value="Divination">Divination</option> >> > (more options in here but I haven't played with them yet) >> > </cfloop> >> > </select> >> > >> > What this returns, is an empty select box. :( >> > >> > Can someone suggest a way to make this work? Should I be looking at the >> > query or the loop, or the if statement? I'm really not sure. >> > >> > Thanks in advance. >> > >> > Seona. >> > >> > Email: [EMAIL PROTECTED] >> > Mobile: 0414 842 795 >> > --- >> > Outgoing mail is certified Virus Free. >> > Checked by AVG anti-virus system (http://www.grisoft.com). >> > Version: 6.0.449 / Virus Database: 251 - Release Date: 27/01/2003 >> > >> > >> > --- >> > You are currently subscribed to cfaussie as: [EMAIL PROTECTED] >> > To unsubscribe send a blank email to >> [EMAIL PROTECTED] >> > >> > MX Downunder AsiaPac DevCon - http://mxdu.com/ >> > >> >> >> >> --- >> You are currently subscribed to cfaussie as: [EMAIL PROTECTED] >> To unsubscribe send a blank email to >> [EMAIL PROTECTED] >> >> MX Downunder AsiaPac DevCon - http://mxdu.com/ >> >> --- >> Incoming mail is certified Virus Free. >> Checked by AVG anti-virus system (http://www.grisoft.com). >> Version: 6.0.449 / Virus Database: 251 - Release Date: 27/01/2003 >> SB> --- SB> Outgoing mail is certified Virus Free. SB> Checked by AVG anti-virus system (http://www.grisoft.com). SB> Version: 6.0.449 / Virus Database: 251 - Release Date: 27/01/2003 SB> --- SB> You are currently subscribed to cfaussie as: [EMAIL PROTECTED] SB> To unsubscribe send a blank email to [EMAIL PROTECTED] SB> MX Downunder AsiaPac DevCon - http://mxdu.com/ --------------------------------------- Life is poetry - write it in your own words. --------------------------------------- Toby Tremayne Technical Team Lead Code Poet and Zen Master of the Heavy Sleep Toll Solutions 154 Moray St Sth Melbourne VIC 3205 +61 3 9697 2317 0416 048 090 ICQ: 13107913 --- You are currently subscribed to cfaussie as: [email protected] To unsubscribe send a blank email to [EMAIL PROTECTED] MX Downunder AsiaPac DevCon - http://mxdu.com/
