hi,
i'm working on a form which will either add to or update the columns of an Access
database. in order that the fields be filled with data already submitted if an update
is to be done, i'm using the 'value' attribute for text input fields. however, i
also have as input fields the 'select', 'textarea' and 'checkbox' data fields. how do
i ensure that those fields are filled with data from the database, in the case of an
update situation? the update will be performed when the form is passed to an action
file which will use sql to perform the update.
Below is the code i'm dealing with:
<CFOUTPUT>
<HTML>
<HEAD>
<TITLE>PROPOSAL FOR INSURANCE OF MONEY</TITLE>
</HEAD>
<BODY>
<CFINCLUDE TEMPLATE="clicoheader.cfm">
<CENTER>
<H1><U>CLICO</U></H1>
<H3>INTERNATIONAL<BR>
GENERAL INSURANCE<BR>
LIMITED</H3>
<H2>PROPOSAL FOR INSURANCE OF MONEY</H2>
<B>i.e. Cash, Bank and Currency Notes, Cheques, Money Orders, Postal
Orders, and Current Postage Stamps all belonging to the insured or
for which he has accepted responsability</B>
</CENTER>
<FORM ACTION="clicomoninsformaction.cfm" METHOD="POST">
<TABLE BORDER=1 CELLSPACING=0 CELLPADDING=4>
<TR>
<TH COLSPAN=4>
<U><H3>Name & Contact Information of Applicants</H3></U>
</TH>
</TR>
<P>
<TR>
<TD>
<B>First name:</B>
</TD>
<TD>
<INPUT TYPE="text" NAME="CustFirstName" SIZE="30"
MAXLENGTH="30" VALUE="#CustFirstName#">
</TD>
<TD>
<B>Middle Initial(s):</B>
</TD>
<TD>
<INPUT TYPE="text" NAME="CustMiddleInit" SIZE="2"
MAXLENGTH="1" VALUE="#CustMiddleInit#">
</TD>
</TR>
<TR>
<TD>
<B>Last name:</B>
</TD>
<TD>
<INPUT TYPE="text" NAME="CustLastName" SIZE="30"
MAXLENGTH="30" VALUE="#CustLastName#">
</TD>
</TR>
<TR>
<TD>
<B>Address1:</B>
</TD>
<TD>
<INPUT TYPE="text" NAME="CustAddress1" SIZE="30"
MAXLENGTH="50" VALUE="#CustAddress1#">
</TD>
<TD>
<B>Address2:</B>
</TD>
<TD>
<INPUT TYPE="text" NAME="CustAddress2" SIZE="30"
MAXLENGTH="50" VALUE="#CustAddress2#">
</TD>
</TR>
<TR>
<TD>
<B>City:</B>
</TD>
<TD>
<INPUT TYPE="text" NAME="CustCity" SIZE="30"
MAXLENGTH="40" VALUE="#CustCity#">
</TD>
<TD>
<B>Parish:</B>
</TD>
<TD>
<INPUT TYPE="text" NAME="CustParish" SIZE="30"
MAXLENGTH="50" VALUE="#CustParish#">
</TD>
</TR>
<TR>
<TD>
<B>Country:</B>
</TD>
<TD>
<SELECT
NAME="Country"><OPTION>Afghanistan<OPTION>Albania<OPTION>Algeria<OPTION>American
Samoa<OPTION>Andorra<OPTION>Angola<OPTION>Anguilla<OPTION>Antarctica<OPTION>Antigua
and
Barbuda<OPTION>Argentina<OPTION>Armenia<OPTION>Aruba<OPTION>Australia<OPTION>Austria<OPTION>Azerbaijan<OPTION>Bahamas<OPTION>Bahrain<OPTION>Bangladesh<OPTION
SELECTED>Barbados<OPTION>Belarus<OPTION>Belgium<OPTION>Belize<OPTION>Benin<OPTION>Bermuda<OPTION>Bhutan<OPTION>Bolivia<OPTION>Bosnia
and Herzegovina<OPTION>Botswana<OPTION>Bouvet Island<OPTION>Brazil<OPTION>British
Indian Ocean Territory<OPTION>Brunei Darussalam<OPTION>Bulgaria<OPTION>Burkina
Faso<OPTION>Burundi<OPTION>Cambodia<OPTION>Cameroon<OPTION>Canada<OPTION>Cape
Verde<OPTION>Cayman Islands<OPTION>Central African
Republic<OPTION>Chad<OPTION>Chile<OPTION>China<OPTION>Christmas Island<OPTION>Cocos
(Keeling Islands)<OPTION>Colombia<OPTION>Comoros<OPTION>Congo<OPTION>Cook
Islands<OPTION>Costa Rica<OPTION>Cote D'Ivoire (Ivory Coast)<OPTION>Croatia
(Hrvatska)<OPTION>Cuba<OPTION>Cyprus<OPTION>Czech
Republic<OPTION>Denmark<OPTION>Djibouti<OPTION>Dominica<OPTION>Dominican
Republic<OPTION>East Timor<OPTION>Ecuador<OPTION>Egypt<OPTION>El
Salvador<OPTION>Equatorial
Guinea<OPTION>Eritrea<OPTION>Estonia<OPTION>Ethiopia<OPTION>Falkland Islands
(Malvinas)<OPTION>Faroe
Islands<OPTION>Fiji<OPTION>Finland<OPTION>France<OPTION>France,
Metropolitan<OPTION>French Guiana<OPTION>French Polynesia<OPTION>French Southern
Territories<OPTION>Gabon<OPTION>Gambia<OPTION>Georgia<OPTION>Germany<OPTION>Ghana<OPTION>Gibraltar<OPTION>Greece<OPTION>Greenland<OPTION>Grenada<OPTION>Guadeloupe<OPTION>Guam<OPTION>Guatemala<OPTION>Guinea<OPTION>Guinea-Bissau<OPTION>Guyana<OPTION>Haiti<OPTION>Heard
and McDonald Islands<OPTION>Honduras<OPTION>Hong
Kong<OPTION>Hungary<OPTION>Iceland<OPTION>India<OPTION>Indonesia<OPTION>Iran<OPTION>Iraq<OPTION>Ireland<OPTION>Israel<OPTION>Italy<OPTION>Jamaica<OPTION>Japan<OPTION>Jordan<OPTION>Kazakhstan<OPTION>Kenya<OPTION>Kiribati<OPTION>Korea
(North)<OPTION>Korea
(South)<OPTION>Kuwait<OPTION>Kyrgyzstan<OPTION>Laos<OPTION>Latvia<OPTION>Lebanon<OPTION>Lesotho<OPTION>Liberia<OPTION>Libya<OPTION>Liechtenstein<OPTION>Lithuania<OPTION>Luxembourg<OPTION>Macau<OPTION>Macedonia<OPTION>Madagascar<OPTION>Malawi<OPTION>Malaysia<OPTION>Maldives<OPTION>Mali<OPTION>Malta<OPTION>Marshall
Islands<OPTION>Martinique<OPTION>Mauritania<OPTION>Mauritius<OPTION>Mayotte<OPTION>Mexico<OPTION>Micronesia<OPTION>Moldova<OPTION>Monaco<OPTION>Mongolia<OPTION>Montserrat<OPTION>Morocco<OPTION>Mozambique<OPTION>Myanmar<OPTION>Namibia<OPTION>Nauru<OPTION>Nepal<OPTION>Netherlands<OPTION>Netherlands
Antilles<OPTION>New Caledonia<OPTION>New
Zealand<OPTION>Nicaragua<OPTION>Niger<OPTION>Nigeria<OPTION>Niue<OPTION>Norfolk
Island<OPTION>Northern Mariana
Islands<OPTION>Norway<OPTION>Oman<OPTION>Pakistan<OPTION>Palau<OPTION>Panama<OPTION>Papua
New
Guinea<OPTION>Paraguay<OPTION>Peru<OPTION>Philippines<OPTION>Pitcairn<OPTION>Poland<OPTION>Portugal<OPTION>Puerto
Rico<OPTION>Qatar<OPTION>Reunion<OPTION>Romania<OPTION>Russian
Federation<OPTION>Rwanda<OPTION>S. Georgia and S. Sandwich Isls.<OPTION>Saint Kitts
and Nevis<OPTION>Saint Lucia<OPTION>Saint Vincent and The
Grenadines<OPTION>Samoa<OPTION>San Marino<OPTION>Sao Tome and Principe<OPTION>Saudi
Arabia<OPTION>Senegal<OPTION>Seychelles<OPTION>Sierra
Leone<OPTION>Singapore<OPTION>Slovak Republic<OPTION>Slovenia<OPTION>Solomon
Islands<OPTION>Somalia<OPTION>South Africa<OPTION>Spain<OPTION>Sri Lanka<OPTION>St.
Helena<OPTION>St. Pierre and Miquelon<OPTION>Sudan<OPTION>Suriname<OPTION>Svalbard and
Jan Mayen
Islands<OPTION>Swaziland<OPTION>Sweden<OPTION>Switzerland<OPTION>Syria<OPTION>Taiwan<OPTION>Tajikistan<OPTION>Tanzania<OPTION>Thailand<OPTION>Togo<OPTION>Tokelau<OPTION>Tonga<OPTION>Trinidad
and Tobago<OPTION>Tunisia<OPTION>Turkey<OPTION>Turkmenistan<OPTION>Turks and Caicos
Islands<OPTION>Tuvalu<OPTION>US Minor Outlying
Islands<OPTION>Uganda<OPTION>Ukraine<OPTION>United Arab Emirates<OPTION>United
Kingdom<OPTION>United
States<OPTION>Uruguay<OPTION>Uzbekistan<OPTION>Vanuatu<OPTION>Vatican City State (Holy
See)<OPTION>Venezuela<OPTION>Viet Nam<OPTION>Virgin Islands (British)<OPTION>Virgin
Islands (US)<OPTION>Wallis and Futuna Islands<OPTION>Western
Sahara<OPTION>Yemen<OPTION>Yugoslavia<OPTION>Zaire<OPTION>Zambia<OPTION>Zimbabwe</SELECT>
</TD>
</TR>
<TR>
<TD>
<B>Home Phone Number:</B>
</TD>
<TD>
<INPUT TYPE="text" NAME="CustHomePhone" SIZE="20"
MAXLENGTH="20" VALUE="#CustHomePhone#">
</TD>
<TD>
<B>Work Phone Number:</B>
</TD>
<TD>
<INPUT TYPE="text" NAME="CustWorkPhone" SIZE="20"
MAXLENGTH="20" VALUE="#CustWorkPhone#">
</TD>
</TR>
<TR>
<TD>
<B>Home Phone Number:</B>
</TD>
<TD>
<INPUT TYPE="text" NAME="CustEmail" SIZE="30"
MAXLENGTH="30" VALUE="#CustEmail#">
</TD>
</TR>
<TR>
<TD>
<B>Trade or Business:</B>
</TD>
<TD>
<TEXTAREA NAME="CustBusiness" ROWS=5 COLS=10></TEXTAREA>
</TD>
</TR>
</TABLE>
<P>
<TABLE BORDER=1 CELLSPACING=0 CELLPADDING=4>
<TR>
<TH COLSPAN=4>
<U><H3>Details of Premises</H3></U>
</TH>
</TR>
<TR>
<TH COLSPAN=4>
<H4>Address(es) where money is to be insured</H4>
</TH>
</TR>
<TR>
<TD>
<B>Premises 1:</B>
</TD>
<TD>
<INPUT TYPE="text" NAME="PremAddress1" SIZE="30"
MAXLENGTH="50" VALUE="#PremAddress1#">
</TD>
<TD>
<B>Premises 2:</B>
</TD>
<TD>
<INPUT TYPE="text" NAME="PremAddress2" SIZE="30"
MAXLENGTH="50" VALUE="#PremAddress2#">
</TD>
</TR>
<TR>
<TD>
<B>City:</B>
</TD>
<TD>
<INPUT TYPE="text" NAME="PremCity" SIZE="30"
MAXLENGTH="40" VALUE="#PremCity#">
</TD>
<TD>
<B>Parish:</B>
</TD>
<TD>
<INPUT TYPE="text" NAME="PremParish" SIZE="30"
MAXLENGTH="50" VALUE="#PremParish#">
</TD>
</TR>
<TR>
<TD>
<B>Are the premises occupied at night?:</B>
</TD>
<TD>
<INPUT TYPE="checkbox" NAME="PremNight" VALUE="Yes">
</TD>
<TD>
<B>If so, by whom?:</B>
</TD>
<TD>
<TEXTAREA NAME="PremNightName"
COLS="22"
ROWS="5">"PremNightName"</TEXTAREA>
</TD>
</TR>
<TR>
<TH COLSPAN=4>
<H4>Details of transits to and from the bank or post office to the
premises</H4>
</TH>
</TR>
<TR>
<TD>
<B>How far is the bank or post office from the premises?</B>
</TD>
<TD>
<INPUT TYPE="text" NAME="PremDist" SIZE="10"
MAXLENGTH="10" VALUE="#PremDist#">miles
</TD>
<TD>
<B>How is the journey made, e.g. on foot or by public or
private conveyance?</B>
</TD>
<TD>
<INPUT TYPE="text" NAME="PremHowJourney" SIZE="30"
MAXLENGTH="30" VALUE="#PremHowJourney#">
</TD>
</TR>
<TR>
<TD>
<B>What is the number of adult males in charge of
each journey?</B>
</TD>
<TD>
<INPUT TYPE="text" NAME="PremMaleNumber" SIZE="2"
MAXLENGTH="2" VALUE="#PremMaleNumber#">
</TD>
<TD>
<B>What special precautions are taken?</B>
</TD>
<TD>
<TEXTAREA NAME="PremPrecaution"
COLS="22"
ROWS="5">#PremPrecaution#</TEXTAREA>
</TD>
</TR>
<TR>
<TH COLSPAN=4>
<U><H3>Miscellaneous information concerning the premises and
the monies to be insured</H3></U>
</TH>
</TR>
<TABLE BORDER=1 CELLSPACING=0 CELLPADDING=4>
<TR>
<TH COLSPAN=4>
<U><H3>Name & Contact Information of Applicants</H3></U>
</TH>
</TR>
<P>
<!---Please ignore this
<TR>
<TD>
<B>Sum to be insured any one loss in respect of crossed cheques,
crossed money orders and crossed postal orders:</B>
</TD>
<TD>
<INPUT TYPE="text" NAME="CustFirstName" SIZE="20"
MAXLENGTH="20" VALUE="#CustFirstName#">
</TD>
<TD>
<B>Middle Initial(s):</B>
</TD>
<TD>
<INPUT TYPE="text" NAME="CustMiddleInit" SIZE="2"
MAXLENGTH="1" VALUE="#CustMiddleInit#">
</TD>
</TR>--->
</TABLE>
<!---Please ignore this
<P>
<TR>
<TD>
<B>Username:</B>
</TD>
<TD>
<INPUT TYPE="text" NAME="CustUserName" SIZE="30"
MAXLENGTH="30" VALUE="#CustUserName#">
</TD>
<TD>
<B>Password:</B>
</TD>
<TD>
<INPUT TYPE="password" NAME="CustPassword" SIZE="30"
MAXLENGTH="20" VALUE="#CustPassword#">
</TD>
</TR>
--->
</FORM>
</BODY>
</HTML>
</CFOUTPUT>
---
Hubert Earl
ICQ#: 16199853
AIM: hubertfme
My Jamaican Art, Craft & More Online Store:
http://www.angelfire.com/ny/hearl/link_page_on_angelfire.html
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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
