RE: [CFCDEV] Getting around IE blank page or no refresh on a survey

virtgrav Wed, 04 Oct 2006 06:30:38 -0700

Larry,

See below for code of application, insert page with the relocation to the thank you page.

Thanks in advance!

Eric

application.cfm

<CFSET DATASOURCE = "hwiSQL">
<CFSET REQUEST.CompanyName = "hwp">

<cfapplication name="hwp" sessionmanagement="Yes" SESSIONTIMEOUT="#CreateTimeSpan(0,0,10,0)#">

<cfif IsDefined("Cookie.CFID") AND IsDefined("Cookie.CFTOKEN")>
    <cfset Variables.cfid_local = Cookie.CFID>
    <cfset Variables.cftoken_local = Cookie.CFTOKEN>
    <cfcookie name="CFID" value="#Variables.cfid_local#">
    <cfcookie name="CFTOKEN" value="#Variables.cftoken_local#">
</cfif>

Insert_hwp.cfm
<cfparam name="txtHwpID" default="9999">

<cfparam name="txtuIP" default="999.999.999.999">

<cfquery datasource="hwiSQL" name="getLastID">
      SELECT MAX(txtHwpID) as HWP_SEQN_ID
      FROM tblHwpAll
    </cfquery>

<cfset HWP_SEQN_ID_AUTO_NUMBER = getLastID.HWP_SEQN_ID + 1>

<cflock name="#CreateUUID()#" timeout="10">
<cftransaction>
<cfquery datasource="hwiSQL" name="HWPin">
   INSERT INTO tblHwpAll(
         txtHwpID,numUID,txtuIP,optD1,optD2,grpD31,optD311,
       grpD32,optD321,txtD41,txtD42,txtD43,txtD44,txtD49,grpK51,
         grpK52,grpK53,grpK54,grpK55,grpK56,grpK57,grpK61,txtK6OTH,
       chkK71,chkK72,chkK73,chkK74,chkK75,chkK76,chkK77,chkK78,
       chkK79,chkK710,chkK711,chk K712,chkK713,chkK714,chkK715,chkK716,
       chkK717,chkK718,chkK81,chkK82,chkK83,chkK84,chkK85,chkK86,
       chkK87,chkK88,chkK89,chkK810,txtK8OTH,grpA91,grpA92,grpA93,
       grpA94,grpA95,grpA96,grpA97,chkA101,chkA102,chkA103,chkA104,
       chkA105,chkA106,chkA107,chkA108,chkA109,chkA1010,txtA10OTH,chkA111,chkA112,chkA113,
       chkA114,chkA115,chkA116,chkA117,chkA118,chkA119,chkA1110,chkA1111,chkA1112,
       txtA11OTH,grpC121,grpC122,grpC123,grpC124,
       grpCPB131S,grpCPB131N,grpCPB132S,grpCPB132N,grpCPB133S,grpCPB133N,grpCPB134S,
       grpCPB134N,grpCPB135S,grpCPB135N,grpCPB136S,grpCPB136N,txt13OTHS,
       txt13OTHN,grpCPB141O,grpCP B141R,grpCPB141W,grpCPB142O,grpCPB142R,grpCPB142W,grpCPB143O,
       grpCPB143R,grpCPB143W,grpCPB144O,grpCPB144R,grpCPB144W,grpCPB145O,grpCPB145R,
       grpCPB145W,grpCPB146O,grpCPB146R,grpCPB146W,grpCPB147O,grpCPB147R,
       grpCPB147W,grpCPB151,grpCPB152,grpCPB153,grpCPB154,grpCPB155,grpCPB156,grpCPB161,
       grpCPB162,grpCPB163,grpCPB164,grpCPB165,grpCPB166,grpCPB167,grpCPB168,
       chkPEM171,chkPEM172,chkPEM173,chkPEM174,chkPEM175,chkPEM176,chkPEM177,
       chkPEM178,chkPEM179,chkPEM1711,chkPEM1710,chkPEM1799,PEM17OTH,SryDone
       )
     VALUES(
       '#HWP_SEQN_ID_AUTO_NUMBER#','#SESSION.Auth.numUID#','#txtuIP#','#optD1#','#optD2#','#grpD31# ','#optD311#',
       '#grpD32#','#optD321#','#txtD41#','#txtD42#','#txtD43#','#txtD44#','#txtD49#','#grpK51#',
       '#grpK52#','#grpK53#','#grpK54#','#grpK55#','#grpK56#','#grpK57#','#grpK61#','#txtK6OTH#',
       '#chkK71#','#chkK72#','#chkK73#','#chkK74#','#chkK75#','#chkK76#','#chkK77#','#chkK78#',
       '#chkK79#','#chkK710#','#chkK711#','#chkK712#','#chkK713#','#chkK714#','#chkK715#','#chkK716#',
       '#chkK717#','#chkK718#','#chkK81#','#chkK82#','#chkK83#','#chkK84#','#chkK85#','#chkK86#',
       '#chkK87#','#chkK88#','#chkK89#','#chkK810#','#txtK8OTH#','#grpA91#','#grpA92#','#grpA93#',
       '#grpA94#','#grpA95#','#grpA96#','#grpA97#','#chkA101#','#chkA102#','#chkA103#','#chkA104#',
   &nb sp;   '#chkA105#','#chkA106#','#chkA107#','#chkA108#','#chkA109#','#chkA1010#','#txtA10OTH#','#chkA111#','#chkA112#','#chkA113#',
       '#chkA114#','#chkA115#','#chkA116#','#chkA117#','#chkA118#','#chkA119#','#chkA1110#','#chkA1111#','#chkA1112#',
       '#txtA11OTH#','#grpC121#','#grpC122#','#grpC123#','#grpC124#',
       '#grpCPB131S#','#grpCPB131N#','#grpCPB132S#','#grpCPB132N#','#grpCPB133S#','#grpCPB133N#','#grpCPB134S#',
       '#grpCPB134N#','#grpCPB135S#','#grpCPB135N#','#grpCPB136S#','#grpCPB136N#','#txt13OTHS#','#txt13OTHN#',
       '#grpCPB141O#','#grpCPB141R#','#grpCPB141W#','#grpCPB142O#','#grpCPB142R#','#grpCPB142W#','#grpCPB143O#',
       '#grpCPB143R#','#grpCPB143W#','#grpCPB144O#','#grpCPB144R#','#grpCPB144W#','#grpCPB145O#', '#grpCPB145R#',
       '#grpCPB145W#','#grpCPB146O#','#grpCPB146R#','#grpCPB146W#','#grpCPB147O#','#grpCPB147R#','#grpCPB147W#',
       '#grpCPB151#','#grpCPB152#','#grpCPB153#','#grpCPB154#','#grpCPB155#','#grpCPB156#','#grpCPB161#',
       '#grpCPB162#','#grpCPB163#','#grpCPB164#','#grpCPB165#','#grpCPB166#','#grpCPB167#','#grpCPB168#',
       '#chkPEM171#','#chkPEM172#','#chkPEM173#','#chkPEM174#','#chkPEM175#','#chkPEM176#','#chkPEM177#',
       '#chkPEM178#','#chkPEM179#','#chkPEM1711#','#chkPEM1710#','#chkPEM1799#','#PEM17OTH#','#SryDone#'
       )
    </cfquery>
<cfquery datasource="hwiSQL" name="getLastID">
      SELECT MAX(txtHwpID) as HWP_SEQN_ID
    &n bsp; FROM tblHwpAll
    </cfquery>
</cftransaction>
</cflock>

<cflocation url = "">

-------------- Original message --------------
From: "Lyons, Larry" <[EMAIL PROTECTED]>

> Eric,
>
> It would help if you could post some code.
>
> thx,
> larry
>
> --
> Larry C. Lyons
> Web Analyst
> BEI Resources
> American Type Culture Collection
> http://www.beiresources.org
> email: llyons(at)atcc(dot)org
> tel: 703.365.2700.2678
> --
>
>
> -----Original Message-----
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
> Behalf Of [EMAIL PROTECTED]
> Sent: Wednesday, October 04, 2006 9:03 AM
> To: [email protected]
> Subject: [CFCDEV] Getting around IE blank page or no refresh on a survey
>
>
> Greeting Folks,
>
> Background info:
> I've developed a sin gle page survey (15 multiple choice questions with
> show/hide attributes) that the users logs in to take and are
> automatically logged out when they submit their survey. The following
> page is a thank you for taking the survey. I set the session for 10
> minutes of non-activity just in case they are interrupted while taking
> the survey.
>
> Problem:
> I had only two or three complaints about receiving a blank page,
> therefore, they used the back button and tried to resubmit thinking that
> their initial survey answers were not submitted. These users say that
> they only attempted to submit once, then use the back button when they
> had a blank screen (meaning their screen didn't refresh). I was only
> under the impression that this IE issue only occurred when a user
> repeatedly re-entered or bookmarks a page to re-enter at the same page.
>
> Any thoughts or remedies are greatly appreciated.
>
> Thanks,
>
> Eric
>
> You are subscribed to cfcdev. To unsubscribe, please follow the
> instructions at http://www.cfczone.org/listserv.cfm
>
> CFCDev is supported by:
> Katapult Media, Inc.
> We are cool code geeks looking for fun projects to rock!
> www.katapultmedia.com
>
> An archive of the CFCDev list is available at
> www.mail-archive.com/[email protected]
>
>
> You are subscribed to cfcdev. To unsubscribe, please follow the instructions at
> http://www.cfczone.org/listserv.cfm
>
> CFCDev is supported by:
> Katapult Media, Inc.
> We are cool code geeks looking for fun projects to rock!
> www.katapultmedia.com
>
> An archive of the CFCDev list is available at
> www.mail-archive.com/[email protected]
>

You are subscribed to cfcdev. To unsubscribe, please follow the instructions at http://www.cfczone.org/listserv.cfm

CFCDev is supported by:
Katapult Media, Inc.
We are cool code geeks looking for fun projects to rock!
www.katapultmedia.com

An archive of the CFCDev list is available at www.mail-archive.com/[email protected]

RE: [CFCDEV] Getting around IE blank page or no refresh on a survey

Reply via email to