if the company that the person entered in the combo box doesnt exist in the
database...
how would the insert statement look to insert the new company in tblCompany?
because the value="#CompanyID#" works for my passthru table if the company
already exists. but if it doesnt, i need to insert the name in tblCompany
and then the new CompanyID in tblCompEquip.
<cf_combobox name="CompanyNM" value="">
<cfoutput query="qryComp" group="CompanyNM">
<option value="#CompanyID#" class="BIOS">#CompanyNM#</cfoutput>
</cf_combobox>
*************************************************
This e-mail, including any attachments, is intended for the
receipt and use by the intended addressee(s), and may contain
confidential and privileged information. If you are not an intended
recipient of this e-mail, you are hereby notified that any unauthorized
use or distribution of this e-mail is strictly prohibited.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
