Turns out that there was nothing wrong with this cfselect, but something
else was wrong with the data that was being saved to the multiple tables I
was inserting into. All is well, however I have a question. How can I
emulate the blank line before a cfselect in a drop down box? Here's a sample
cfselect I have:
<tr>
<td>Division:</td>
<td><cfselect name="Division" query="GetDivision" value="Division"
display="Division"></cfselect></td>
</tr>
Currently this defaults to the 1st value that the query returns. I tried to
insert a blank line in the DB, but that is not working.
Thanks,
Aimee' Clark
-----Original Message-----
From: S. Isaac Dealey [mailto:[EMAIL PROTECTED]]
Sent: Friday, August 23, 2002 7:37 PM
To: CF-Talk
Subject: RE: Need help with update on two different tables
> Here's the code for the cfselect.
> <tr>
> <td>Gender:</td>
> <td><cfselect name="Gender" message="Gender"
> query="GetPersonnelInfo"
> value="Gender" selected="Gender">
> <option value="M">M
> <option value="F">F</cfselect></td>
> </tr>
My first instinct is to close the option tags... so <option
value="M">M</option> ... If that doesn't work, I'd start to think it's a bug
because I don't see any other problems with the <cfselect> tag syntax... I'm
not sure why there's a query attribute tho, since your only options are both
provided manually and not by the query ( as is normal for cfselect ), so you
might want to remove that also... and if you want to make sure the people
entering the data don't make some women men, you might also want to add
<option value=""></option> above the M option...
hth
Isaac
Certified Advanced ColdFusion 5 Developer
www.turnkey.to
954-776-0046
______________________________________________________________________
Your ad could be here. Monies from ads go to support these lists and provide more
resources for the community. http://www.fusionauthority.com/ads.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
