This will add a blank row at the beginning of the query. You can also use QuerySetCell to give the row specific values.
<cfset temp = queryaddrow(GetDivision,1)> - j -----Original Message----- From: Clark, Aimee [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 27, 2002 12:00 PM To: CF-Talk Subject: Have a question about a cfselect....Was(RE: Need help with update on two different tables) 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 ______________________________________________________________________ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm 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
