hi,
i have a form, composed of both htm and cfm tags, which shows blank. if i rename it
with an htm extension, it appears. i guess that this indicates that the problem is in
the cfm code, but darned if i could see the problem! i'd appreciate any suggestions
as to what sort of things i should be checking for. this is the code:
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<!---Check to see if the client is new, in which case the client info
will be added, and if not, client info will be updated--->
<CFIF ISDEFINED("UserID")>
<CFSET NEWRECORD="No">
<CFELSE>
<CFSET NEWRECORD="Yes">
</CFIF>
<!---This section adds a new customer to the database--->
<CFIF NEWRECORD><!---LEVEL #1--->
<CFSET PAGETITLE = "Add a User">
<CFSET BUTTONTEXT = "Add User">
<CFSET CLIENTFIRSTNAME = "">
<CFSET CLIENTMIDDLEINIT = "">
<CFSET CLIENTLASTNAME = "">
<CFSET CLIENTADDRESS1 = "">
<CFSET CLIENTADDRESS2 = "">
<CFSET CLIENTCITY = "">
<CFSET CLIENTPARISH = "">
<CFSET CLIENTCOUNTRY = "">
<CFSET CLIENTHOMEPHONE = "">
<CFSET CLIENTWORKPHONE = "">
<CFSET CLIENTEMAIL = "">
<CFSET CLIENTBUSINESS = "">
<CFSET PREMADDRESS1 = "">
<CFSET PREMADDRESS2 = "">
<CFSET PREMCITY = "">
<CFSET PREMPARISH = "">
<CFSET PREMNIGHT = "">
<CFSET PREMNIGHTFIRSTNAME = "">
<CFSET PREMNIGHTMIDDLEINIT = "">
<CFSET PREMNIGHTLASTNAME = "">
<CFSET PREMDIST = "">
<CFSET PREMHOWJOURNEY = "">
<CFSET PREMMALENUMBER = "">
<CFSET PREMPRECAUTION = "">
<CFSET PREMCROSSINSURED = "">
<CFSET PREMSUMINSURED = "">
<CFSET SAFEMAKER = "">
<CFSET SAFEMAKERNUMBER = "">
<CFSET SAFEPURCHASEDATE = "">
<CFSET SAFENEW = "">
<CFSET SAFEPRICE = "">
<CFSET SAFEESTVALUE = "">
<CFSET SAFESIZE = "">
<CFSET SAFEWEIGHT = "">
<CFSET SAFEMARKED = "">
<CFSET SAFEHOWFIXED = "">
<CFSET SAFENUMBERKEYS = "">
<CFSET SAFEWHEREKEYS = "">
<CFSET SAFEMONEYINSURED = "">
<CFSET PREM8AI = "">
<CFSET PREM8AII = "">
<CFSET PREM8BI = "">
<CFSET PREM8BII = "">
<CFSET RECEPTACLENATURE = "">
<CFSET RECEPTACLEWHERE = "">
<CFSET RECEPTACLEWHOFSTNAME = "">
<CFSET RECEPTACLEWHOMIDINIT = "">
<CFSET RECEPTACLEWHOLSTNAME = "">
<CFSET RECEPTACLESUMINSURED = "">
<CFSET CLIENTLOSS = "">
<CFSET CLIENTLOSSINFO = "">
<CFSET CLIENTINSURERDECLINED = "">
<CFSET CLIENTINSURERCANCELLED = "">
<CFSET CLIENTINSURERREQUIRED = "">
<CFSET CLIENTINSURERNAME = "">
<CFELSE><!---LEVEL #1--->
<!---Check to see if the customer has logged in. If 'yes', continue,
if 'no', send to a warning page--->
<CFIF SESSION.AUTH IS "YES"><!---LEVEL #2--->
<!---This section queries the database get data from
the table 'Client' with which to populate the form --->
<CFQUERY DATASOURCE="#DB#" NAME="Client">
SELECT ClientFirstName,
ClientMiddleInit,
ClientLastName,
ClientUserName,
ClientPassword,
ClientAddress1,
ClientAddress2,
ClientCity,
ClientParish,
ClientCountry,
ClientHomePhone,
ClientWorkPhone,
ClientEmail,
ClientBusiness,
ClientLoss,
ClientLossInfo,
ClientInsurerDeclined,
ClientInsurerCancelled,
ClientInsurerRequired,
ClientInsurerName
FROM Client
WHERE ClientID = #ClientID#
</CFQUERY>
<!---This section does the actual populating--->
<CFSET PAGETITLE = "Update a Customer - " & CLIENT.LASTNAME
& ", " & CLIENT.FIRSTNAME>
<CFSET BUTTONTEXT = "Update Customer">
<CFSET CLIENTFIRSTNAME = TRIM(CLIENT.CLIENTFIRSTNAME)>
<CFSET CLIENTMIDDLEINIT = TRIM(CLIENT.CLIENTMIDDLEINIT)>
<CFSET CLIENTLASTNAME = TRIM(CLIENT.CLIENTLASTNAME)>
<CFSET CLIENTUSERNAME = TRIM(CLIENT.CLIENTUSERNAME)>
<CFSET CLIENTPASSWORD = TRIM(CLIENT.CLIENTPASSWORD)>
<CFSET CLIENTADDRESS1 = TRIM(CLIENT.CLIENTADDRESS1)>
<CFSET CLIENTADDRESS2 = TRIM(CLIENT.CLIENTADDRESS2)>
<CFSET CLIENTCITY = TRIM(CLIENT.CLIENTCITY)>
<CFSET CLIENTPARISH = TRIM(CLIENT.CLIENTPARISH)>
<CFSET CLIENTCOUNTRY = TRIM(CLIENT.CLIENTCOUNTRY)>
<CFSET CLIENTHOMEPHONE = TRIM(CLIENT.CLIENTHOMEPHONE)>
<CFSET CLIENTWORKPHONE = TRIM(CLIENT.CLIENTWORKPHONE)>
<CFSET CLIENTEMAIL = TRIM(CLIENT.CLIENTEMAIL)>
<CFSET CLIENTBUSINESS = TRIM(CLIENT.CLIENTBUSINESS)>
<CFSET CLIENTLOSS = TRIM(CLIENT.CLIENTLOSS)>
<CFSET CLIENTLOSSINFO = TRIM(CLIENT.CLIENTLOSSINFO)>
<CFSET CLIENTINSURERDECLINED= TRIM(CLIENT.CLIENTINSURERDECLINED)>
<CFSET CLIENTINSURERCANCELLED = TRIM(CLIENT.CLIENTINSURERCANCELLED)>
<CFSET CLIENTINSURERREQUIRED = TRIM(CLIENT.CLIENTINSURERREQUIRED)>
<CFSET CLIENTINSURERNAME = TRIM(CLIENT.CLIENTINSURERNAME)>
<!---This section queries the database get data from
the table 'Prem' with which to populate the form--->
<CFQUERY DATASOURCE="#DB#" NAME="Prem">
SELECT PremAddress1,
PremAddress2,
PremCity,
PremParish,
PremNight,
PremNightFirstName,
PremNightMiddleInit,
PremNightLastName,
PremDist,
PremHowJourney,
PremMaleNumber,
PremPrecaution,
PremCrossInsured,
PremSumInsured,
Prem8ai,
Prem8aii,
Prem8bi,
Prem8bii
FROM Prem
WHERE PremID = #PremID#
</CFQUERY>
<!---This section does the actual populating--->
<CFSET PAGETITLE = "Update Premises - " & PREM.PREMADDRESS1>
<CFSET BUTTONTEXT = "Update Premises">
<CFSET PREMADDRESS1 = TRIM(PREM.PREMADDRESS1)>
<CFSET PREMADDRESS2 = TRIM(PREM.PREMADDRESS2)>
<CFSET PREMCITY = TRIM(PREM.PREMCITY)>
<CFSET PREMPARISH = TRIM(PREM.PREMPARISH)>
<CFSET PREMNIGHT = TRIM(PREM.PREMNIGHT)>
<CFSET PREMNIGHTFIRSTNAME = TRIM(PREM.PREMNIGHTFIRSTNAME)>
<CFSET PREMNIGHTMIDDLEINIT = TRIM(PREM.PREMNIGHTMIDDLEINIT)>
<CFSET PREMNIGHTLASTNAME = TRIM(PREM.PREMNIGHTLASTNAME)>
<CFSET PREMDIST = TRIM(PREM.PREMDIST)>
<CFSET PREMHOWJOURNEY = TRIM(PREM.PREMHOWJOURNEY)>
<CFSET PREMMALENUMBER = TRIM(PREM.PREMMALENUMBER)>
<CFSET PREMPRECAUTION = TRIM(PREM.PREMPRECAUTION)>
<CFSET PREMCROSSINSURED = TRIM(PREM.PREMCROSSINSURED)>
<CFSET PREMSUMINSURED = TRIM(PREM.PREMSUMINSURED)>
<CFSET PREM8AI = TRIM(PREM.PREM8AI)>
<CFSET PREM8AII = TRIM(PREM.PREM8AII)>
<CFSET PREM8BI = TRIM(PREM.PREM8BI)>
<CFSET PREM8BII = TRIM(PREM.PREM8BII)>
<!---This section queries the database get data from
the table 'Receptacle' with which to populate the form--->
<CFQUERY DATASOURCE="#DB#" NAME="Receptacle">
SELECT ReceptacleNature,
ReceptacleWhere,
ReceptacleWhoFstName,
ReceptacleWhoMidInit,
ReceptacleWhoLstName,
ReceptacleSumInsured
FROM Receptacle
WHERE ReceptacleID = #ReceptacleID#
</CFQUERY>
<!---This section does the actual populating--->
<CFSET PAGETITLE = "Update a Receptacle - " &
RECEPTACLE.RECEPTACLENATURE>
<CFSET BUTTONTEXT = "Update Receptacle">
<CFSET RECEPTACLENATURE = TRIM(RECEPTACLE.RECEPTACLENATURE)>
<CFSET RECEPTACLEWHERE = TRIM(RECEPTACLE.RECEPTACLEWHERE)>
<CFSET RECEPTACLEWHOFSTNAME = TRIM(RECEPTACLE.RECEPTACLEWHOFSTNAME)>
<CFSET RECEPTACLEWHOMIDINIT = TRIM(RECEPTACLE.RECEPTACLEWHOMIDINIT)>
<CFSET RECEPTACLEWHOLSTNAME = TRIM(RECEPTACLE.RECEPTACLEWHOLSTNAME)>
<CFSET RECEPTACLESUMINSURED = TRIM(RECEPTACLE.RECEPTACLESUMINSURED)>
<!---This section queries the database get data from
the table 'Receptacle' with which to populate the form--->
<CFQUERY DATASOURCE="#DB#" NAME="Safe">
SELECT SafeMaker,
SafeMakerNumber,
SafePurchaseDate,
SafeNew,
SafePrice,
SafeEstValue,
SafeSize,
SafeWeight,
SafeMarked,
SafeHowFixed,
SafeNumberKeys,
SafeWhereKeys,
SafeMoneyInsured
FROM Safe
WHERE SafeID = #SafeID#
</CFQUERY>
<!---This section does the actual populating--->
<CFSET PAGETITLE = "Update a Safe - " &
SAFE.SAFEMAKER>
<CFSET BUTTONTEXT = "Update Safe">
<CFSET SAFEMAKER = TRIM(SAFE.SAFEMAKER)>
<CFSET SAFEMAKERNUMBER = TRIM(SAFE.SAFEMAKERNUMBER)>
<CFSET SAFEPURCHASEDATE = TRIM(SAFE.SAFEPURCHASEDATE)>
<CFSET SAFENEW = TRIM(SAFE.SAFENEW)>
<CFSET SAFEPRICE = TRIM(SAFE.SAFEPRICE)>
<CFSET SAFEESTVALUE = TRIM(SAFE.SAFEESTVALUE)>
<CFSET SAFESIZE = TRIM(SAFE.SAFESIZE)>
<CFSET SAFEWEIGHT = TRIM(SAFE.SAFEWEIGHT)>
<CFSET SAFEMARKED = TRIM(SAFE.SAFEMARKED)>
<CFSET SAFEHOWFIXED = TRIM(SAFE.SAFEHOWFIXED)>
<CFSET SAFENUMBERKEYS = TRIM(SAFE.SAFENUMBERKEYS)>
<CFSET SAFEWHEREKEYS = TRIM(SAFE.SAFEWHEREKEYS)>
<CFSET SAFEMONEYINSURED = TRIM(SAFE.SAFEMONEYINSURED)>
<CFOUTPUT>
<HTML>
<HEAD>
<TITLE>PROPOSAL FOR INSURANCE OF MONEY</TITLE>
</HEAD>
<BODY>
<CFINCLUDE TEMPLATE="clicoheader.cfm">
<FORM ACTION= "clicomoninsformaction.cfm" METHOD="POST">
<!---Hidden input lets
the action file know if to use add SQL or update SQL--->
<CFIF NEWRECORD IS "No">
<INPUT TYPE="hidden" NAME="ClientID" VALUE="#ClientID#">
</CFIF>
<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>
<TABLE BORDER=1 CELLSPACING=0 CELLPADDING=4>
<TR>
<TH COLSPAN=4>
<H3><U>Name & Contact Information of Applicants</U></H3>
</TH>
</TR>
<TR>
<TD>
First name:
</TD>
<TD>
<INPUT TYPE="text" NAME="ClientFirstName" SIZE="30"
MAXLENGTH="30" VALUE="#ClientFirstName#">
</TD>
<TD>
Middle Initial:
</TD>
<TD>
<INPUT TYPE="text" NAME="ClientMiddleInit" SIZE="2"
MAXLENGTH="1" VALUE="#ClientMiddleInit#">
</TD>
</TR>
<TR>
<TD>
Last name:
</TD>
<TD>
<INPUT TYPE="text" NAME="ClientLastName" SIZE="30"
MAXLENGTH="30" VALUE="#ClientLastName#">
</TD>
</TR>
<TR>
<TD>
Username:
</TD>
<TD>
<INPUT TYPE="text" NAME="ClientUserName" SIZE="30"
MAXLENGTH="30" VALUE="#ClientUserName#">
</TD>
<TD>
Password:
</TD>
<TD>
<INPUT TYPE="text" NAME="ClientPassword" SIZE="20"
MAXLENGTH="20" VALUE="#ClientPassword#">
</TD>
</TR>
<TR>
<TD>
Address1:
</TD>
<TD>
<INPUT TYPE="text" NAME="ClientAddress1" SIZE="50"
MAXLENGTH="50" VALUE="#ClientAddress1#">
</TD>
<TD>
Address2:
</TD>
<TD>
<INPUT TYPE="text" NAME="ClientAddress2" SIZE="50"
MAXLENGTH="50" VALUE="#ClientAddress2#">
</TD>
</TR>
<!---PLEASE IGNORE THIS CODE. I haven't finished with it yet.
<TR>
<TD>
Email:
</TD>
<TD>
<INPUT TYPE="text" NAME="UserEmail" SIZE="30"
MAXLENGTH="30" VALUE="#UserEmail#">
</TD>
</TR>
<TR>
<TD>
Home Phone Number:
</TD>
<TD>
<INPUT TYPE="text" NAME="PhoneHome" SIZE="20"
MAXLENGTH="20" VALUE="#PhoneHome#">
</TD>
</TR>
</TABLE>
<P>
<INPUT TYPE="submit" VALUE="#ButtonText#">
<INPUT TYPE="reset" VALUE="Clear">
--->
</TABLE>
</FORM>
</BODY>
</HTML>
</CFOUTPUT>
<CFELSE><!---LEVEL #2--->
<CFLOCATION URL='GOTOLOGIN.CFM'ADDTOKEN="No">
</CFIF><!---LEVEL #2--->
</CFIF><!---LEVEL #1--->
hubert
---
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/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
