[ cf-dev ] Re:PROBLEMS WITH CONNECTION TO DB

Wed, 31 Mar 2004 03:44:15 -0800


hi guys,

ive created a form using html, and an action page called action.cfm, the problem is that im having problems when inserting information into my form, it doesnt seem to being entered into my database, below i have both codes of the form and the action page, pleaseee help, ive been riping my hair out, any help would be appreciated as you will be able to see im a complete novice at using cf

form.html

HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<title>Untitled Document</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>
<body bgcolor="#0000">
<body><HTML>
<HEAD>
<title></title>


<table border="0" width="500">
<FORM ACTION="action.cfm", METHOD="post">
<tr>
<td height="21" colspan="2" class="body"><font size="3"><a class="caption" href="file:///C|/Inetpub/wwwroot/default.asp?page=40"></A></font>
</td>
</tr>


<td height="3"></tr>
<tr>
<td class="body" align="Right" width="189"><font color="#FFFFFF"><b>Employee
Name :&nbsp;</b></font></td>
<td class="body" align="left" valign="Top" width="301"> <input type="text" value="" name="employee_name' size="25" maxlength="100">
</td>
</tr>
<tr>
<td class="body" align="Right" width="189"><div align="right"><font color="#FFFFFF">
<strong>Company Name</strong>:&nbsp;<b></font></div></td>
<td class="body" > <div align="left">
<input type="text" value="" name="company_name" size="25" maxlength="100">
</div></td>
</tr>
<tr>
<td class="body" align="Right" width="189"><font color="#FFFFFF"><b>Or
By Country:&nbsp;</b></font></td>
<td class="body" width="301"> <select name="country">
<option value= "">N/A</option>
<option value="2">Albania</option>
<option value="3">Algeria</option>
<option value="4">Andorra</option>
<option value="5">Angola</option>
<option value="6">Anguilla</option>
<option value="8">Argentina</option>
<option value="9">Armenia</option>
<option value="10">Aruba</option>
<option value="11">Australia</option>
<option value="12">Austria</option>
<option value="13">Azerbaijan</option>
<option value="14">Bahamas, The</option>
<option value="15">Bahrain</option>
<option value="16">Bangladesh</option>
<option value="17">Barbados</option>
<option value="18">Belarus</option>
<option value="19">Belgium</option>
<option value="20">Belize</option>
<option value="21">Benin</option>
<option value="22">Bermuda</option>
<option value="24">Bolivia</option>
<option value="25">Bosnia-Herzegovina</option>
<option value="26">Botswana</option>
<option value="27">Brazil</option>
<option value="28">British Virgin Islands</option>
<option value="30">Bulgaria</option>
<option value="31">Burkina Faso</option>
<option value="32">Burundi</option>
<option value="33">Cambodia, Kingdom of</option>
<option value="34">Cameroon</option>
<option value="35">Canada</option>
<option value="36">Cape Verde Islands</option>
<option value="37">Cayman Islands</option>
<option value="38">Central African Republic</option>
<option value="39">Chad</option>
<option value="40">Channel Islands</option>
<option value="41">Chile</option>
<option value="42">China</option>
<option value="43">Colombia</option>
<option value="44">Comoros</option>
<option value="45">Congo</option>
<option value="47">Cook Islands</option>
<option value="48">Costa Rica</option>
<option value="49">Cote D'Ivoire</option>
<option value="50">Croatia</option>
<option value="51">Cuba</option>
<option value="52">Cyprus</option>
<option value="53">Czech Republic</option>
<option value="54">Denmark</option>
<option value="55">Djibouti</option>
<option value="57">Dominican Republic</option>
<option value="58">East Timor</option>
<option value="59">Ecuador</option>
<option value="60">Egypt</option>
<option value="61">El Salvador</option>
<option value="62">Eritrea</option>
<option value="63">Estonia</option>
<option value="64">Ethiopia</option>
<option value="65">Fiji</option>
<option value="66">Finland</option>
<option value="67">France</option>
<option value="70">Gabon</option>
<option value="71">Gambia</option>
<option value="72">Georgia</option>
<option value="73">Germany</option>
<option value="74">Ghana</option>
<option value="75">Gibraltar</option>
<option value="76">Greece</option>
<option value="81">Guatemala</option>
<option value="82">Guinea</option>
<option value="83">Guinea-Bissau</option>
<option value="84">Guyana</option>
<option value="85">Haiti</option>
<option value="86">Honduras</option>
<option value="87">Hong Kong, SAR</option>
<option value="88">Hungary</option>
<option value="89">Iceland</option>
<option value="90">India</option>
<option value="91">Indonesia</option>
<option value="92">Iran (Islamic Republic Of)</option>
<option value="94">Ireland</option>
<option value="95">Israel</option>
<option value="96">Italy</option>
<option value="97">Jamaica</option>
<option value="98">Japan</option>
<option value="99">Jordan</option>
<option value="100">Kazakhstan</option>
<option value="101">Kenya</option>
<option value="102">Kiribati</option>
<option value="104">Korea, South</option>
<option value="105">Kuwait</option>
<option value="106">Kyrgyz Republic</option>
<option value="107">Lao People's Democratic Republic </option>
<option value="108">Latvia</option>
<option value="109">Lebanon</option>
<option value="110">Lesotho</option>
<option value="112">Libya</option>
<option value="113">Liechtenstein, Principality of</option>
<option value="114">Lithuania</option>
<option value="115">Luxembourg, Grand Duchy of</option>
<option value="116">Macau</option>
<option value="117">Macedonia</option>
<option value="118">Madagascar</option>
<option value="119">Malawi</option>
<option value="120">Malaysia</option>
<option value="121">Maldives</option>
<option value="122">Mali</option>
<option value="123">Malta</option>
<option value="126">Mauritania</option>
<option value="127">Mauritius</option>
<option value="129">Mexico</option>
<option value="131">Moldova, Republic Of</option>
<option value="132">Monaco</option>
<option value="133">Mongolia</option>
<option value="135">Morocco</option>
<option value="136">Mozambique</option>
<option value="137">Myanmar</option>
<option value="138">Namibia</option>
<option value="139">Nauru</option>
<option value="140">Nepal</option>
<option value="141">Netherlands</option>
<option value="142">Netherlands Antilles</option>
<option value="144">New Zealand</option>
<option value="145">Nicaragua</option>
<option value="146">Niger</option>
<option value="147">Nigeria</option>
<option value="151">Norway</option>
<option value="152">Oman</option>
<option value="153">Pakistan</option>
<option value="154">Palau</option>
<option value="155">Panama</option>
<option value="156">Papua New Guinea</option>
<option value="157">Paraguay</option>
<option value="158">Peru</option>
<option value="159">Philippines</option>
<option value="160">Poland</option>
<option value="161">Portugal</option>
<option value="162">Puerto Rico</option>
<option value="163">Qatar</option>
<option value="164">Romania</option>
<option value="165">Russian Federation</option>
<option value="166">Rwanda</option>
<option value="167">Saint Kitts and Nevis</option>
<option value="171">Samoa (Western)</option>
<option value="172">San Marino</option>
<option value="174">Saudi Arabia</option>
<option value="175">Senegal</option>
<option value="217">Serbia and Montenegro</option>
<option value="176">Seychelles</option>
<option value="177">Sierra Leone</option>
<option value="178">Singapore</option>
<option value="179">Slovak Republic</option>
<option value="180">Slovenia</option>
<option value="181">Solomon Islands</option>
<option value="183">South Africa</option>
<option value="184">Spain</option>
<option value="185">Sri Lanka</option>
<option value="188">Sudan</option>
<option value="189">Suriname</option>
<option value="191">Swaziland</option>
<option value="192">Sweden</option>
<option value="193">Switzerland</option>
<option value="194">Syrian Arab Republic</option>
<option value="195">Taiwan, Republic of China</option>
<option value="196">Tajikistan</option>
<option value="197">Tanzania, United Republic Of</option>
<option value="198">Thailand</option>
<option value="199">Togo</option>
<option value="200">Tonga</option>
<option value="201">Trinidad and Tobago</option>
<option value="202">Tunisia</option>
<option value="203">Turkey</option>
<option value="204">Turkmenistan</option>
<option value="206">Uganda</option>
<option value="207">Ukraine</option>
<option value="208">United Arab Emirates</option>
<option value="209">United Kingdom</option>
<option value="210">United States</option>
<option value="211">Uruguay</option>
<option value="212">Uzbekistan</option>
<option value="213">Vanuatu</option>
<option value="214">Venezuela</option>
<option value="215">Vietnam</option>
<option value="216">Yemen</option>
<option value="218">Zambia</option>
<option value="219">Zimbabwe</option>
</select></td>
</tr>
<tr>
<td class="body" align="Right" width="189"><font color="#FFFFFF"><b>Or
By Region:&nbsp;</b></font></td>
<td class="body" width="301"> <SELECT name="region">
<option Value="">N/A</Option>
<option Value="1">Africa</Option>
<option Value="2">Asia</Option>
<option Value="3">Caribbean</Option>
<option Value="4">Eastern Europe</Option>
<option Value="5">Europe</Option>
<option Value="6">FSU</Option>
<option Value="7">Islands</Option>
<option Value="8">Middle East</Option>
<option Value="9">North America</Option>
<option Value="10">South America</Option>
</SELECT> </td>
</tr>
<tr>
<td class="body" align="Right" width="189"><font color="#FFFFFF"><b>By
Position:&nbsp;</b></font></td>
<td class="body" width="301"> <SELECT name="position">
<option Value="">N/A</Option>
<option Value="304">Accounts</Option>
<option Value="2">Accounts / Audit</Option>
<option Value="4">Acquisition Finance</Option>
<option Value="5">Acting Governor</Option>
<option Value="6">Aircraft / Aerospace Finance</Option>
<option Value="7">Analyst</Option>
<option Value="9">Asset Swaps (Sales)</Option>
<option Value="10">Assistant Governor</Option>
<option Value="13">Chairman</Option>
<option Value="14">Chief Cashier</Option>
<option Value="15">Chief Credit Officer</Option>
<option Value="17">Chief Executive Officer</Option>
<option Value="20">Chief Operating Officer</Option>
<option Value="21">Chief Representative</Option>
<option Value="23">Collateral Management</Option>
<option Value="26">Commodities Financing</Option>
<option Value="27">Company Secretary</Option>
<option Value="30">Corporate Sales (Head)</Option>
<option Value="31">Correspondent Banking</Option>
<option Value="32">Country Head</Option>
<option Value="256">Country Manager</Option>
<option Value="34">Cross-Currency Swaps, S / M</Option>
<option Value="35">Cross-Currency Swaps, Trading</Option>
<option Value="38">Debt Recovery / Restructuring</Option>
<option Value="255">Deputy Chairman</Option>
<option Value="39">Deputy Governor</Option>
<option Value="42">Director</Option>
<option Value="43">Director of Commercial Banking</Option>
<option Value="46">Economic Research</Option>
<option Value="53">Executive Director</Option>
<option Value="55">Finance Director/CFO</Option>
<option Value="60">FRN Origination (Head)</Option>
<option Value="61">Fund Administration</Option>
<option Value="63">FX Futures</Option>
<option Value="64">FX Options</Option>
<option Value="65">General Manager</Option>
<option Value="67">Global Head</Option>
<option Value="69">Global Trust</Option>
<option Value="70">Governor</Option>
<option Value="71">Head</Option>
<option Value="72">Head of Accountancy</Option>
<option Value="73">Head of Administration</Option>
<option Value="76">Head of Asset Management</Option>
<option Value="77">Head of Asset Swaps</Option>
<option Value="303">Head of Audit</Option>
<option Value="293">Head of Back Office</Option>
<option Value="78">Head of Bank Licensing</Option>
<option Value="79">Head of Banking Supervision</Option>
<option Value="286">Head of Capital Markets</Option>
<option Value="81">Head of Cash Management</Option>
<option Value="25">Head of Commodities / Bullion</Option>
<option Value="28">Head of Compliance</Option>
<option Value="84">Head of Corporate Banking</Option>
<option Value="29">Head of Corporate Comms</Option>
<option Value="85">Head of Corporate Finance</Option>
<option Value="86">Head of Credit Committee</Option>
<option Value="87">Head of Credit Research</Option>
<option Value="92">Head of Debt Capital Markets</Option>
<option Value="287">Head of Desk</Option>
<option Value="93">Head of E-Commerce</Option>
<option Value="94">Head of Economics & Statistics</Option>
<option Value="95">Head of Emerging Markets</Option>
<option Value="97">Head of Equities</Option>
<option Value="98">Head of Equity Capital Markets</Option>
<option Value="99">Head of Equity Derivatives</Option>
<option Value="100">Head of Equity E-Commerce</Option>
<option Value="101">Head of Equity Research</Option>
<option Value="102">Head of Equity Settlement</Option>
<option Value="103">Head of F Income Derivatives</Option>
<option Value="109">Head of F Income Settlement</Option>
<option Value="104">Head of Fixed Income</Option>
<option Value="105">Head of Fixed Income E-Com</Option>
<option Value="106">Head of Fixed Income Research</Option>
<option Value="107">Head of Fixed Income Sales</Option>
<option Value="108">Head of Fixed Income Trading</Option>
<option Value="110">Head of Foreign Exchange</Option>
<option Value="291">Head of Forfaiting</Option>
<option Value="112">Head of FRN Sales</Option>
<option Value="113">Head of FRN Trading</Option>
<option Value="115">Head of FX Derivatives</Option>
<option Value="116">Head of Global Custody</Option>
<option Value="118">Head of Human Resources</Option>
<option Value="120">Head of Institutional Sales</Option>
<option Value="122">Head of Investment</Option>
<option Value="305">Head of Investment Banking</Option>
<option Value="290">Head of Leasing & Asset Fin</Option>
<option Value="126">Head of Loan Origination</Option>
<option Value="127">Head of Loan Syndication</Option>
<option Value="128">Head of Loans/Lending</Option>
<option Value="130">Head of Marketing</Option>
<option Value="132">Head of Mergers & Acquisition</Option>
<option Value="295">Head of Middle Office</Option>
<option Value="134">Head of Money Markets</Option>
<option Value="137">Head of Operations</Option>
<option Value="300">Head of Options</Option>
<option Value="138">Head of Origination</Option>
<option Value="139">Head of Payment Systems</Option>
<option Value="143">Head of Prime Brokerage</Option>
<option Value="144">Head of Private Banking</Option>
<option Value="289">Head of Project Finance</Option>
<option Value="149">Head of Public Debt</Option>
<option Value="208">Head of Public Relations</Option>
<option Value="151">Head of Repo</Option>
<option Value="152">Head of Research</Option>
<option Value="153">Head of Reserve Management</Option>
<option Value="156">Head of Risk Management</Option>
<option Value="157">Head of Sales</Option>
<option Value="258">Head of Securities</Option>
<option Value="296">Head of Securities Lending</Option>
<option Value="158">Head of Settlement & Clearing</Option>
<option Value="234">Head of Structured Finance</Option>
<option Value="288">Head of Structured Trade Fin</Option>
<option Value="159">Head of Structuring</Option>
<option Value="160">Head of Syndicated Lending</Option>
<option Value="161">Head of Syndication</Option>
<option Value="162">Head of Technology/Systems</Option>
<option Value="294">Head of Trade Finance</Option>
<option Value="164">Head of Trading</Option>
<option Value="166">Head of Treasury</Option>
<option Value="301">Head of Wholesale Deposits</Option>
<option Value="172">International Division (Head)</Option>
<option Value="302">Investment Banker</Option>
<option Value="176">IR Futures</Option>
<option Value="177">IR Options</Option>
<option Value="178">IR Options Sales / Marketing</Option>
<option Value="179">IR Options Trading</Option>
<option Value="180">IR Swaps Sales / Marketing</Option>
<option Value="181">IR Swaps Trading</Option>
<option Value="185">Leasing & Asset Finance (GH)</Option>
<option Value="186">Leasing & Asset Finance (LH)</Option>
<option Value="187">Legal/In-House Counsel</Option>
<option Value="189">Liquidity Management</Option>
<option Value="191">Managing Dir / General Manager</Option>
<option Value="192">Managing Director</Option>
<option Value="194">Marketing & Product Developmt</Option>
<option Value="193">Marketing (Head)</Option>
<option Value="195">Matched Book Manager</Option>
<option Value="285">Member of the Board</Option>
<option Value="202">President</Option>
<option Value="203">Private Banker</Option>
<option Value="204">Private Equity</Option>
<option Value="297">Project Finance</Option>
<option Value="205">Project Finance (GH)</Option>
<option Value="206">Project Finance (LH)</Option>
<option Value="207">Proprietary Trading</Option>
<option Value="216">Recovery (Head)</Option>
<option Value="217">Regional Head</Option>
<option Value="218">Relationship Manager</Option>
<option Value="219">Representative</Option>
<option Value="220">Research</Option>
<option Value="221">Research (Head)</Option>
<option Value="222">Retail Banking</Option>
<option Value="224">Sales</Option>
<option Value="261">Secretary General</Option>
<option Value="230">Shipping Finance</Option>
<option Value="232">Spot / Forwards Sales</Option>
<option Value="233">Spot / Forwards Trading</Option>
<option Value="299">Structured Trade Finance</Option>
<option Value="235">Structured Trade Finance (GH)</Option>
<option Value="236">Structured Trade Finance (LH)</Option>
<option Value="298">Trade Finance</Option>
<option Value="240">Trade Finance (GH)</Option>
<option Value="241">Trade Finance (LH)</Option>
<option Value="242">Trading</Option>
<option Value="243">Trading (Corporates)</Option>
<option Value="244">Trading (High-yield)</Option>
<option Value="245">Trading (Sovereigns)</Option>
<option Value="246">Treasurer</Option>
<option Value="251">Vanilla FX Option Sales</Option>
<option Value="252">Vanilla FX Option Trading</Option>
<option Value="253">Vice Governor</Option>
<option Value="254">Vice President</Option>
</SELECT> </td>
</tr>
<tr>
<td class="body" align="Right" width="189"><font color="#FFFFFF"><b>By
Department:&nbsp;</b></font></td>
<td class="body" width="301"><SELECT name="department" >
<option Value="">N/A</Option>
<option Value="6">Asset-Backed/Structured Finance/Securitization</Option>
<option Value="188">Board of Directors</Option>
<option Value="11">Bonds - General</Option>
<option Value="87">Commodity Derivatives</Option>
<option Value="21">Convertibles</Option>
<option Value="198">Credit Derivatives</Option>
<option Value="25">Domestic Commercial Paper</Option>
<option Value="26">Domestic Equities</Option>
<option Value="27">Domestic Government Bonds</Option>
<option Value="31">Emerging Market Bonds</Option>
<option Value="197">Equity Derivatives</Option>
<option Value="34">Equity Repo/Securities Lending</Option>
<option Value="35">Equity Research</Option>
<option Value="38">Euro Commercial Paper</Option>
<option Value="37">Eurobonds</Option>
<option Value="39">Exchange-Traded Derivatives</Option>
<option Value="40">Exotic Options</Option>
<option Value="44">Fixed Income (Trading)</Option>
<option Value="47">Fixed Income Derivatives</Option>
<option Value="48">Fixed Income Repo</Option>
<option Value="49">Fixed Income Research</Option>
<option Value="195">Floating Rate Notes</Option>
<option Value="53">Foreign Exchange Derivatives</Option>
<option Value="55">FX Traders / Sales People</Option>
<option Value="57">General - Investment</Option>
<option Value="58">General - Lending</Option>
<option Value="59">General - Treasury</Option>
<option Value="60">Government Bonds</Option>
<option Value="194">High Yield - Corporate</Option>
<option Value="193">High Yield - Government/Emerging Markets</Option>
<option Value="62">High Yield / Junk Bonds</Option>
<option Value="201">Interest Rate Derivatives</Option>
<option Value="68">International Equities</Option>
<option Value="192">Investment Grade - Corporate</Option>
<option Value="191">Investment Grade - Government</Option>
<option Value="74">Libor-Based/Floating-Rate Products</Option>
<option Value="75">Loan-Related Activities</Option>
<option Value="80">Medium-Term Notes</Option>
<option Value="83">Money Markets - General</Option>
<option Value="84">Mortgage-Backed Securities</Option>
<option Value="86">Operations</Option>
<option Value="88">OTC Credit Derivatives</Option>
<option Value="89">OTC Equity Derivatives</Option>
<option Value="200">Private Banking</Option>
<option Value="161">Private Placements</Option>
<option Value="166">Relationship Managers</Option>
<option Value="167">Research</Option>
<option Value="190">Senior Managers</Option>
<option Value="189">Supervisory Board</Option>
<option Value="199">Trade Finance</Option>
<option Value="183">Warrants</Option>
<option Value="184">Wholesale Deposits</Option>
</SELECT> </td>
</tr>
<tr>
<td class="body" align="Right" width="189"><font color="#FFFFFF"><strong>By
Section</strong><b>:&nbsp;</b></font></td>
<td class="body" width="301"><SELECT name="section">
<option Value="">N/A</Option>
<option Value="3">Asset Management</Option>
<option Value="235">Capital Markets</Option>
<option Value="11">Cash Management</Option>
<option Value="12">Central Bank Senior Executives</Option>
<option Value="14">Commercial Banking</Option>
<option Value="17">Corporate Banking</Option>
<option Value="20">Debt Capital Markets/Fixed Income</Option>
<option Value="27">Equities</Option>
<option Value="32">Foreign Exchange</Option>
<option Value="34">Global Custody</Option>
<option Value="18">Investment Banking/Corporate Finance/M&A Advisory</Option>
<option Value="53">Money Markets</Option>
<option Value="236">Operations</Option>
<option Value="55">Other Departments</Option>
<option Value="59">Private Banking</Option>
<option Value="64">Risk Management</Option>
<option Value="66">Senior Executive Officers</Option>
<option Value="74">Syndicated Lending</Option>
<option Value="82">Treasury</Option>
</SELECT> </td>
</tr>
<tr>
<td class="body" align="Right" width="189" ><font color="#FFFFFF"><strong>Other
Information</strong><b> :&nbsp;</b></font></td>
<td class="body" align="left" valign="Top" width="301"><input type="text" value="" name="random" size="25" maxlength=100>
</td>
</tr>

 </form>
</table>


<form name="form1" method="post" action="action.cfm">
 <p>
   <input type="submit" name="Submit" value="Submit">
 </p>
 <p>
   <input type="reset" name="Submit2" value="reset">
 </p>
</form>
<br>
                </td>
        </tr>
        <tr>
                <td valign="top" align="center" colspan="3" class="body">
        <center>
   </center></td>
</tr>
<tr>
 <td valign="top" align="center" colspan="3" class="body">&nbsp;</td>
        </tr>


</body>
</html>

</body>
</html>


here is the action.cfm page

<HTML>
<HEAD>
<CFOUTPUT>
<TITLE>Thank you #company_name# #country# for your submission!</TITLE>
</CFOUTPUT>
</HEAD>

<BODY>

<!--- First let's insert this data into our database for safe keeping and later usage. --->
<CFINSERT DATASOURCE="sanjay_1" TABLENAME="TableName" FORMFIELDS="employee_name, company_name, country, region, position, department, section, random, ">



</body>
</html>

_________________________________________________________________
It's fast, it's easy and it's free. Get MSN Messenger today! http://www.msn.co.uk/messenger


--
These lists are syncronised with the CFDeveloper forum at 
http://forum.cfdeveloper.co.uk/
Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/

CFDeveloper Sponsors and contributors:-
*Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by 
activepdf.com*
     *Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com*
          *Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com*

To unsubscribe, e-mail: [EMAIL PROTECTED]

Reply via email to