Hubert,
If NEWRECORD is "YES", your code does only a CFSET. Your page is blank because
there's no HTML code in this case.
-David
On Sunday, May 06, 2001 6:36 AM, Hubert Earl [SMTP:[EMAIL PROTECTED]]
wrote:
> Hi,
>
> Thanks for the feedback. Strangely enough, the source shows *none* of my
> code. The only code I see is the source code for the debug info (I've
> enabled all the debug settings in CF Administrator), which doesn't help me,
> because there are no error messages in it. In case you have the time, the
> following is the code of the page (a form) I'm not being able to see:
>
> <!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
>
>
> ----- Original Message -----
> From: "Diana Nichols" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Sunday, May 06, 2001 9:52 AM
> Subject: RE: Problem with page showing blank
>
>
> > try looking at the source for the page....sometimes the page will blank
> when
> > it throws a CF error inside a table, but you will be able to see the error
> > in the source.
> >
> > HTH
> > D
> > *************
> > Diana Nichols
> > Webmistress
> > http://www.lavenderthreads.com
> > 770.434.7374
> >
> > "One man's magic is another man's engineering." ---Lazarus Long
> >
> > -----Original Message-----
> > From: Todd Ashworth [mailto:[EMAIL PROTECTED]]
> > Sent: Sunday, May 06, 2001 1:50 AM
> > To: CF-Talk
> > Subject: Re: Problem with page showing blank
> >
> >
> > No .. 2 dashes = HTML comment .. 3 dashes = CFML comment. As long as you
> > don't mix and match the 2, you should be OK in that respect.
> >
> > Todd
> >
> > ----- Original Message -----
> > From: "Hubert Earl" <[EMAIL PROTECTED]>
> > To: "CF-Talk" <[EMAIL PROTECTED]>
> > Sent: Saturday, May 05, 2001 11:42 PM
> > Subject: Re: Problem with page showing blank
> >
> >
> > > hi,
> > >
> > > thanks for the feedback. actually, all my comments use two dashes
> before
> > > and after the comment, not three. could that be the problem?
> > >
> > > 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
> > >
> > >
> > > ----- Original Message -----
> > > From: "Todd Ashworth" <[EMAIL PROTECTED]>
> > > To: "CF-Talk" <[EMAIL PROTECTED]>
> > > Sent: Sunday, May 06, 2001 12:25 AM
> > > Subject: Re: Problem with page showing blank
> > >
> > >
> > > > One possible problem .. check to see if you have something that looks
> > like
> > > > this:
> > > >
> > > > <!--- bunch of stuff goes here -->
> > > >
> > > > Note that the <!--- doesn't end with a --->, but a -->
> > > >
> > > > This tends to screw up your whole page and will cause blank displays.
> > > >
> > > > Todd
> > > >
> > > > ----- Original Message -----
> > > > From: "Hubert Earl" <[EMAIL PROTECTED]>
> > > > To: "CF-Talk" <[EMAIL PROTECTED]>
> > > > Sent: Saturday, May 05, 2001 11:10 PM
> > > > Subject: Problem with page showing blank
> > > >
> > > >
> > > > > 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.
> > > > >
> > > > > 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
