Do you manage the database? Can you put some data in the NULL field. That is what I did for mine. I inserted N/A in all NULL fields which for me is BOX 3. I always have a value for BOX 1&2 for what I am doing? My question is how can you have a value in BOX 3 that is related to a NULL value in BOX 2? If its the case where you do have NULL data in BOX 2, you may want to consider merging BOX 2&3 and use CF_TwoSelectsRelated custom tag instead.
Just a thought. Let me know. -----Original Message----- From: JAIME HOI [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 13, 2002 7:50 PM To: CF-Talk Subject: RE: CF_ThreeSelectsRelated but the values are generated from DB...so sometimes the value is a null field (The first field, Box 1, can never be an empty field, most of the time its the second field, Box 2, that is a null field) and so it cannot be related to the third drop down select, Box 3. A null field contains a value too isn't it? Thought its an empty string? > -----Original Message----- > From: James Taavon [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, March 13, 2002 10:13 PM > To: CF-Talk > Subject: RE: CF_ThreeSelectsRelated > > > Can you be more specific? Are you saying that sometimes have > blanks in your > select boxes? You need a value for each one so the next box > can realte to > the previous one. Does that make sense? > > Ex. (is your data ike this?) > > BOX 1 BOX 2 BOX 3 > aaa bbb ccc > ddd fff > hhh iii > > > > -----Original Message----- > From: JAIME HOI [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, March 13, 2002 2:32 AM > To: CF-Talk > Subject: CF_ThreeSelectsRelated > > > hi > I am trying to use this tag...but there's a problem. My > Query is like > this > Grp Div Dept > GF ATC > MIS IT2 > MIS IT3 > GR 1 DIV 1 > GR 2 AC > Since some of the field values could be empty...esp for > the second field > "DIV", it seems that the custom tag is not able to retrieve > the correct Dept > code out. Anybody know of this workaround? > > > Jaime Hoi > > Don't try so hard, the best things come when you least expect them to. > > > > > ______________________________________________________________________ Why Share? Dedicated Win 2000 Server � PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation � $99/Month � Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
