On 3/14/01, Brian Horn penned:
>Here is the code for the form:
>http://www.financialpro.org/JobBank/enterjobs/jobaddupform.txt
Look at this:
<SELECT name="JobLocation">
<CFIF #NewRecord# IS "No">
<CFOUTPUT QUERY="GetJobLocation">
<option VALUE="#CategoryID#">#LocationName#</option>
</CFOUTPUT>
</CFIF>
Looks like if newrecord is "yes", then joblocation is not being
passed (no <option> tag, not even an empty one). You'll either need
to pass something or create a default parameter where the insert
statement is.
--
Bud Schneehagen - Tropical Web Creations
_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/
ColdFusion Solutions / eCommerce Development
[EMAIL PROTECTED]
http://www.twcreations.com/
954.721.3452
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
