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