• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 236
  • Last Modified:

Two Part Question Probably Real Easy.

this is my question.

I have a log in script that ends the session at 25 min of inactivity within the application. at that time if the user attemps to do something they get a page that tells them to login at that time once they restablish the identity then I would like them to be able to return to the page that they had requested with out loosing any information or having to renavigate thru the application.

secondly.
I need to create a page that displays the result set of the query in colums.  ie.

                       my header
recid          name          recid         name
1               a              4             d
2               b              5             e
3               c              6             f

the amount of records returned could be up to 1300.

I would like to have a page count like page 1 of ?? at the bottom of the page.

how feasable is this.

I thank you in advance....:)
0
jriver12
Asked:
jriver12
  • 39
  • 30
1 Solution
 
cheekycjCommented:
As for remembering where they were going do this...

where you check if the user is logged in...
do this..

<cfif notloggedin condition>
  <cfset currentURL = "#CGI.Script_Name#?#CGI.Query_String#">
  <cflocation url="/path/to/login.cfm?requestedURL=" & URLEncodedFormat(currentURL)>
</cfif>

Now login.cfm should use URL.requestedURL to redirect the user back to their original requested URL.

for pagination:
http://www.teratech.com/ColdCuts/cutdetail.cfm?cutid=163
http://www.planet-source-code.com/vb/scripts/ShowCode.asp?txtCodeId=14&lngWId=9

CJ
0
 
jriver12Author Commented:
cheekycj

I think I misspoke,
I am not looking for pagination.

what I am trying to achive is the following

I would like to have a table that would have a header
and then have 4 columns.

     my header
recid          name          recid         name
1               a              4             d
2               b              5             e
3               c              6             f

I would like for all the records returned be shown in the browser,
however after every 42-50 recordI would like the header to apear as if it was a nother table holding the information.

my intent is to print from the browser and force individual pages after the count has reached 42-??(undecided)
<style media="print">
BR.pageBreak { page-break-after: always }
</style>
i will try to post something to give you a better Idea in a lil.
0
 
cheekycjCommented:
try this:

<cfset numberOfRecordsBeforeHeaderDisplay = 50>
<cfoutput query="yourQuery">
<!--- Display header --->
  <cfif yourQuery.currentRow mod numberOfRecordsBeforeHeaderDisplay EQ 1>
     <table>
       <tr><td>... header html </td></tr>
  </cfif>
<!--- table cell display --->
display your data here.


<!--- Display close table --->
  <cfif yourQuery.currentRow mod numberOfRecordsBeforeHeaderDisplay EQ 0 OR yourQuery.currentRow EQ yourQuery.recordCount>
     </table>
  </cfif>

</cfoutput>
0
Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
jriver12Author Commented:
CJ your code worked great with the exception that it does not wrap.

i mean,

when the page hits the recordcount desired in that column

I would like it to populate a nother column with the next  recordcount

kind of like a newspaper column that once it reaches its limit it wraps to another colum
0
 
cheekycjCommented:
you want it to wrap column wise too..
ok..

<cfset numberOfRecordsBeforeHeaderDisplay = 50>
<!-- start newspaper table -->
<table>
<tr>
<cfoutput query="yourQuery">
<!--- Display header --->
 <cfif yourQuery.currentRow mod numberOfRecordsBeforeHeaderDisplay EQ 1>
    <td>
    <table>
      <tr><td>... header html </td></tr>
 </cfif>
<!--- table cell display --->
display your data here.


<!--- Display close table --->
 <cfif yourQuery.currentRow mod numberOfRecordsBeforeHeaderDisplay EQ 0 OR yourQuery.currentRow EQ
yourQuery.recordCount>
    </table>
    </td>
 </cfif>
</cfoutput>
<!-- end newspaper table -->
</tr></table>
0
 
jriver12Author Commented:
CJ,

this is what I have but it is still not wrapping the original 2 colums to another 2 colums. for a total of 4 colums (5 if you include the spacer.

what it is doing is just continuosly doing the newspaperwrap indefinately.

I am just not understanding how to make it go from 2 columns of data
each 1 record will fill 2 colums name and number

if the recordcount for that column is exceeded then make another 2 colums and populate them until filled.


<cfset numberOfRecordsBeforeHeaderDisplay = 38>
<!-- start newspaper table -->
<table width="725" height="100%">
  <tr>
<cfoutput query="alphalist">
<!--- Display header --->
<cfif alphalist.currentRow mod numberOfRecordsBeforeHeaderDisplay EQ 1>
   <td>
        <table width="693">
          <tr valign="top" align="center">
            <td colspan="4"><font size="+2">Alpha list by Companies</font> </td>
      </tr>
            <td></cfif>
         
<!--- table cell display --->

<tr>
     <td width="45%">#co_name#</td>
             <td width="5%">#conumber#</td>
     
</tr>




<!--- Display close table --->
            <td width="25%"><cfif alphalist.currentRow mod numberOfRecordsBeforeHeaderDisplay EQ 0 OR alphalist.currentRow EQ
alphalist.recordCount>
         
   </table>
   </td>
</cfif>
</cfoutput>
<!-- end newspaper table -->
</tr></table>
0
 
cheekycjCommented:
so you want the newspaper to have a two column effect..
and then keep going down in rows?
0
 
jriver12Author Commented:
actualy 4 colums

example:
if numberOfRecordsBeforeHeaderDisplay = 3
                    my header
recid          name          recid         name
1               a              4             d
2               b              5             e
3               c              6             f
if numberOfRecordsBeforeHeaderDisplay <=3
my header
recid          name          
1               a              
2               b              
3               c
0
 
cheekycjCommented:
I don't follow.. give me example using

10 records
12 records
15 records

Thanx,
CJ
0
 
jriver12Author Commented:
I know now by testing that an cfm page in the browser will print 39 records + 1-2 line header total lines per browser page = 40 to 41lines per page(font size depending)

so if lets say my query returns 42 records, the page should look something like

                    my header
recid          name          
1               a              
2               b              
3               c
.               .
.               .
42              aa

now if it returns lets say 84 then the page should now have 4 colums 1 header and 84 records onthe page.


                    my header
recid          name          recid          name
1               a             43             ab
2               b             44             ac
3               c             45             ad
.               .              .              .
.               .              .              .  
42              aa             84             bb

I hope this clarified it some more.

0
 
jriver12Author Commented:
cj, if your still interested in helping a lost soul.

this is what I have been able to come up with but I still need some help.

this is what is going wrong
it is not starting a new page after lets say 42 recordsin each colum  it is just continuing to flow.

again it should break at about 42 records and start a new page.

heres what I have got>
<style media="print">
BR.pageBreak { page-break-after: always }
</style>
</head>

<cfset totrec = #fprdue.RecordCount#>
  <!--- number of exhibitornumber - (used for maxrows) --->
  <cfset totrubr = #fprdue.RecordCount#>
  <!--- column 1: startrow is always 1, maxrows is number of exhibitornumber / 2 --->
  <cfset rmax1 = int(#totrubr# / 2)>
  <!--- created one table with two columns, in each column one table with a cfouput query with it's own startrow and maxrows --->
</p>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td valign="top" align="center"><font size="6" face="Arial, Helvetica, sans-serif">this
      is my page header</font></td>
  </tr>
</table>
<TABLE WIDTH="695" BORDER="0">
  <TR>
  <tr>
   
  </tr>
  <TD VALIGN="top">
    <TABLE WIDTH="195" BORDER="0" CELLSPACING="0" CELLPADDING="3">
      <TR> <CFOUTPUT QUERY="fprdue" GROUP="exhibitornumber" STARTROW="1" MAXROWS=#rmax1#>
        <TD WIDTH="195" ALIGN="center"> </TD>
      </TR>
      <cfoutput>
        <TR>
          <TD>#EX_Co_name# </TD>
          <td>#Exhibitornumber#</td>
        </TR>
        <!--- determine last record shown in this column --->
        <cfset count1 = #currentrow#>
      </CFOUTPUT> </CFOUTPUT>
    </TABLE>
    <!--- column 2 --->
  </TD>
  <TD VALIGN="top">
    <TABLE WIDTH="195" BORDER="0" CELLSPACING="0" CELLPADDING="3">
      <TR>
        <!--- <cfoutput>#count1# </CFOUTPUT> --->
        <!--- column 2: startrow is last record of column 1 (=count1) +- 1 --->
        <cfset srow2 = #count1# +- 1><cfoutput query="fprdue" GROUP="exhibitornumber" STARTROW=#srow2# MAXROWS=#rmax1#>
        <TD WIDTH="195"  ALIGN="center"> </TD>
      </TR>
      <cfoutput>
        <TR>
          <TD>
            <!--- #currentrow# --->
            #Ex_CO_name# </TD>
          <td>#Exhibitornumber#</td>
        </TR>
        <!--- determine last record shown in this column --->
        <cfset count2 = #currentrow#>
      </CFOUTPUT> </CFOUTPUT>
    </TABLE>
</TABLE>
 </TD>
</TR>
</TABLE>
 <br class="pageBreak">

</body>
</html>
0
 
cheekycjCommented:
I am still interested in helping.. just a little busy.. I will take a look at your code tonight.. if that is ok.

CJ
0
 
jriver12Author Commented:
thanks,
take a  look at it when ever youget a chance.  
I think I'm close but there is something missing.

take your time.

later

<listening>
0
 
cheekycjCommented:
so you want the total rows just split into two columns?

CJ
0
 
cheekycjCommented:
let say your query returns 200 rows.

How many columns and rows would you expect to see per
page.

CJ
0
 
jriver12Author Commented:
ok.
a page (by my testing) will hold anywhere from 42-46 lines of data(Printed).

so if I am quering 2 fields  id and name and the page will hold 42 -46 lines of data then if the recordset returned is total 200 then I would expect to see 84 - 92 records per page  at a total colums of 2 0r 4

ie
with less than 42 records returned
id      name              
1        test1
2        test2
.        .

42       test42

now with more than 42records returned.

id          name        id      name
1           test1       43       test43

2           test2       44       test44

3          test3       45       test45
.            .          .         .
42         test42      84        test84.

:)
0
 
cheekycjCommented:
try this:

<cfset numberOfRecordsBeforeHeaderDisplay = 42>
<cfset pageBreakCounter = 0>
<cfoutput query="yourQuery">
<!--- Display header --->
<cfif yourQuery.currentRow mod numberOfRecordsBeforeHeaderDisplay EQ 1>
  <cfif pageBreakCounter eq 0>
     <!-- start newspaper table -->
     <table>
     <tr>
  </cfif>
  <cfset pageBreakCounter = IncrementValue(pageBreakCounter)>
   <td>
   <table>
     <tr><td>... header html </td></tr>
</cfif>
<!--- table cell display --->
display your data here.


<!--- Display close table --->
<cfif yourQuery.currentRow mod numberOfRecordsBeforeHeaderDisplay EQ 0 OR yourQuery.currentRow EQ yourQuery.recordCount>
   </table>
   </td>
     <cfif pageBreakCounter mod 2 eq 0 OR yourQuery.currentRow EQ yourQuery.recordCount>
       <cfset pageBreakCounter = 0>
       <!--- close newspaper table --->
       </tr></table>
       <!--- Insert your page break code here --->
     </cfif>
</cfif>
</cfoutput>


I checked it out logically it seems to work.. but since I couldn't test it with real data.. I am not sure.

CJ
0
 
jriver12Author Commented:
thanks man I will let you know in the morn...
0
 
cheekycjCommented:
ok.. <waiting>
0
 
jriver12Author Commented:
cj,
sorry just been obe allof the day. Iwill let you know how it comes out shortly. (huff huff)
0
 
jriver12Author Commented:
cj it is working fairly well, it is putting some white space on the top of the first 2 colums that is what I am trying to solve.  

so far so good.
0
 
cheekycjCommented:
ok, keep me updated.

CJ
0
 
jriver12Author Commented:
what I have noticed is that no matter what I set the
"<cfset numberOfRecordsBeforeHeaderDisplay = 42>"
to I always have 2 records per each column cary over on to the second page leaving the remaider blank(second page) from then on all pages have the correct amount ofrecords and page breaks.

I'll keep you posted.
0
 
jriver12Author Commented:
it has taken more time than  anticipated.
0
 
cheekycjCommented:
can you explain your second last comment?

CJ
0
 
jriver12Author Commented:
not to fret,
I have resolved it, I am doing the last bit of testing (different amount of records returned) give me a lil I will let you know with in the next hour or so.
0
 
jriver12Author Commented:
on the last page if the records dont add up to be what "<cfset numberOfRecordsBeforeHeaderDisplay = ??>" is set
it makes the cells stretch both width and height wise, similar to it justifing the page, and puts a lot of white space between and in front of the records:
this is what I have:

<style media="print">
BR.pageBreak { page-break-after: always }
</style>
<cfquery name="alphalist" datasource="exhibition">
Select *
from View_alphaXconame
</cfquery>

<cfset numberOfRecordsBeforeHeaderDisplay = 32>
<cfset pageBreakCounter = 0>
<cfoutput query="alphalist">
<!--- Display header --->

<cfif alphalist.currentRow mod numberOfRecordsBeforeHeaderDisplay EQ 1>
 <cfif pageBreakCounter eq 0>
    <!-- start newspaper table -->
  <body leftmargin="0" topmargin="0" marginwidth="0" marginheight="0">
 
  <cfinclude template="alphaheader.cfm"> <table width="100%" height="100%"">
    <tr>
 </cfif>
 <cfset pageBreakCounter = IncrementValue(pageBreakCounter)>
  <td>
        <table width="100%" height="90%">
          <tr>          
            <td width="81%" valign="top" align="left">Name</td>
            <td width="2%">&nbsp;</td>
            <td align="left" width="17%">Number </td>
         
          </tr>
            <td width="81%">
</cfif>    
          <!--- table cell display --->
          <tr>
            <td width="81%"><font face="Arial, Helvetica, sans-serif" size="2">#CO_Name#</font></td>
            <td width="2%">&nbsp;</td>
            <td width="17%"><font face="Arial, Helvetica, sans-serif" size="2">#visitornumber#</font></td>
          </tr>
          <!--- Display close table --->
            <td width="81%">
               <cfif alphalist.currentRow mod numberOfRecordsBeforeHeaderDisplay EQ 0 OR alphalist.currentRow EQ alphalist.recordCount>
          </table>
  </td>
    <cfif pageBreakCounter mod 2 eq 0 OR alphalist.currentRow EQ alphalist.recordCount>
      <cfset pageBreakCounter = 0>
      <!--- close newspaper table --->
      </table>
      <br class="pageBreak">
    </cfif>
</cfif>
</cfoutput>
0
 
jriver12Author Commented:
the spacing was being caused by a table cell height?

doesnt matter.  I am appreciative of your help it looks like it worked wonderfully under stress.

it tested it by pulling 1500 records and agiain by pulling in increments of 35 +-1 and the pages held there formating and appearence.

I havent tested the loggin script yet?
do you mind if I try that out for a bit before I release the question.??
0
 
jriver12Author Commented:
this is what I have that checks the login stat

<cfset bLoggedIn = False>
<cfif IsDefined("Session.UserID")>
     <cfif Session.UserID neq "">
     <cfset bLoggedIn = True>    
     </cfif>
     <cfelse>
     <cfif IsDefined("Cookie.UserID")>
          <cfif Cookie.UserID neq "">
          <cfset Session.UserID = Cookie.UserID>
                    <cfset bLoggedIn = True>
          </cfif>
     </cfif>
</cfif>
<!--- not in system --->
<cfif bLoggedIn eq False>
<cfinclude template="myErrorFile.cfm">
     <cfexit>
</cfif>

however whan I try to implement your suggested solution i cant seem to get it to work can you let me know where to place this?
<cfif notloggedin condition>
 <cfset currentURL = "#CGI.Script_Name#?#CGI.Query_String#">
 <cflocation url="/path/to/login.cfm?requestedURL=" & URLEncodedFormat(currentURL)>
</cfif>
0
 
cheekycjCommented:
what is not working?

You place the :
<cfif notloggedin condition>
<cfset currentURL = "#CGI.Script_Name#?#CGI.Query_String#">
<cflocation url="/path/to/login.cfm?requestedURL=" & URLEncodedFormat(currentURL)>
</cfif>

at the top of each file.. ideally in a separate file as a cfinclude.

CJ
0
 
jriver12Author Commented:
that is what i am trying to accomplish.

I have placed this code in a seperate file and then included it on all my pages using cfinclude  and what I get is if the user is not logged in it shows the cfinclude page and the requested page:

<cfset bLoggedIn = False>
<cfif IsDefined("Session.UserID")>
    <cfif Session.UserID neq "">
    <cfset bLoggedIn = True>    
    </cfif>
    <cfelse>
    <cfif IsDefined("Cookie.UserID")>
         <cfif Cookie.UserID neq "">
         <cfset Session.UserID = Cookie.UserID>
                   <cfset bLoggedIn = True>
         </cfif>
    </cfif>
</cfif>
<cfif notloggedin condition>
<cfset currentURL = "#CGI.Script_Name#?#CGI.Query_String#">
<cflocation url="/path/to/login.cfm?requestedURL=" & URLEncodedFormat(currentURL)>
</cfif>

<!--- not in system --->
<cfif bLoggedIn eq False>
<cfinclude template="myErrorFile.cfm">
    <cfexit>
</cfif>
0
 
cheekycjCommented:
Make this your include file:

<cfset bLoggedIn = False>
<cfif IsDefined("Session.UserID")>
   <cfif Session.UserID neq "">
   <cfset bLoggedIn = True>    
   </cfif>
   <cfelse>
   <cfif IsDefined("Cookie.UserID")>
        <cfif Cookie.UserID neq "">
        <cfset Session.UserID = Cookie.UserID>
                  <cfset bLoggedIn = True>
        </cfif>
   </cfif>
</cfif>
<cfif bLoggedIn IS "False">
  <cfset currentURL = "#CGI.Script_Name#?#CGI.Query_String#">
  <cflocation url="/path/to/login.cfm?requestedURL=" & URLEncodedFormat(currentURL)>
</cfif>

CJ
0
 
jriver12Author Commented:
error received

Invalid token found on line 16 at position 53. ColdFusion was looking at the following text:

&

where "&" is in
 <cflocation url="default.cfm?requestedURL=" & URLEncodedFormat(currentURL)>
0
 
cheekycjCommented:
try this:
<cflocation url="default.cfm?requestedURL=#URLEncodedFormat(currentURL)#">

CJ
0
 
jriver12Author Commented:
cj when I try to jump into a page and the session has been ended I get a 404 object not found error. and this in the location bar:

default.cfm?requestedURL=%2FDevelopment%2F050202%2Fvisiotor%2Fprocess%2FVisit%5FIns%2Ecfm%3F&CFID=86&CFTOKEN=2997312.

0
 
cheekycjCommented:
is the login page called default.cfm?

Rename default.cfm to the page that handles your session ended/non logged in users.

CJ
0
 
jriver12Author Commented:
yes.
I have changed it to login2.cfm which checks for the session and nonlogged users with this:

<!--- Get user's details from the database --->
<cfquery name="GetUser" datasource="exhibition">
SELECT     *
FROM      Users
WHERE     UserName      = '#Form.UserName#'
AND      Password      = '#Form.Password#'
</cfquery>

<!--- Check if we have a winner! --->
<cfif GetUser.RecordCount gt 0>
     
     <!--- Store the user id in session variables and cookies. --->
     <cfset Session.userID = GetUser.UserID>
     <cfcookie name="UserID" value="#GetUser.UserID#" expires="NOW">
     
     
<!--- If user exists, update his or her profile information --->
<!--- First get the old info - you may wish to use this somehow.  Some of the login stats are --->
<!--- cumulative, so we add to the prior number, like TotalLogins--->
     <cfset oldIP = getUser.LastIP>
     <cfset oldBrowser = getUser.LastBrowser>
     <cfset oldLogin = getUser.LastLogin>
     <cfset TotLogins = getUser.TotalLogins>

<!--- Store the new info in variables --->
     <cfset newIP = CGI.REMOTE_ADDR>
     <cfset newBrowser = CGI.HTTP_USER_AGENT>
     <cfset TotLogins = TotLogins + 1>

     <cfquery Datasource="exhibition" name="UpdateUser">
          UPDATE      Users
          SET      TotalLogins = #TotLogins#,
                    LastIP           = '#newIP#',
                    LastBrowser = '#newBrowser#',
                    LastLogin      = #CreateODBCDateTime(Now())#
          WHERE      UserID           = #session.UserID#
     </cfquery>
     
 
     <cflocation url="index.cfm" addtoken="Yes">


<cfelse>
<!--- User does not exist --->
<!--- Pass the variables back in the URL - message and UserName --->
<cfset loginpage = "default.cfm?Message=" & URLEncodedFormat("Invalid User Name/Password Combination")>
<cfset loginpage = loginpage & "&UserName=" & URLEncodedFormat(#Form.UserName#)>
<cflocation url="#loginpage#">
</cfif>

once I have changed it to this page I now get a

 variable  not defined error.?
0
 
cheekycjCommented:
you should redirect to the form page not the form submission page?

CJ
0
 
jriver12Author Commented:
Cj,
that is what I had done originaly when I redirected it to the default.cfm.? :(
0
 
cheekycjCommented:
so you redirected to the login form page.. and then what?

You need to store the currentURL in a hidden form field so it gets passed to the form action page.

You should default the currentURL var to something in case it isn't passed in (like the default logged in main page)

CJ
0
 
jriver12Author Commented:
trying....
0
 
jriver12Author Commented:
CJ

Im lost...

could no figure it out, Im admiting defeat. :)

can you point me in the direction of an existing solution for this, because I am not comprehending.
0
 
cheekycjCommented:
could you outline what you want and your current code.

CJ
0
 
jriver12Author Commented:
CJ,

The code that I have now works fine for user login, the only thing that is missing is that when the session has expired and the user attemps to do something, they are taken to a screen that says that they must loggin once they loggin they are returned to the home page and have to go thru the same sequence of events to take them back to where they were.  I have been trying(unsuccessfuly) to have them return to the page where the session has timed out once they log back in.I have been using a loggin script that I had aquired from the net. let me find the link and I will post that vs posting the 3 pages of code.
0
 
jriver12Author Commented:
cj,
here is the link to where I have gotten the original code for the loggin script(tutorial)(still need to learn more)
http://hotwired.lycos.com/webmonkey/00/48/index2a.html?tw=programming.

however I had never gotten the check authority to work properly.(See the previous comments) you helped me get it to work on this thread. using this:

<cfset bLoggedIn = False>
<cfif IsDefined("Session.UserID")>
  <cfif Session.UserID neq "">
  <cfset bLoggedIn = True>    
  </cfif>
  <cfelse>
  <cfif IsDefined("Cookie.UserID")>
       <cfif Cookie.UserID neq "">
       <cfset Session.UserID = Cookie.UserID>
                 <cfset bLoggedIn = True>
       </cfif>
  </cfif>
</cfif>
<cfif bLoggedIn IS "False">
 <cfset currentURL = "#CGI.Script_Name#?#CGI.Query_String#">
 <cflocation url="/path/to/login.cfm?requestedURL=" & URLEncodedFormat(currentURL)>
</cfif>


now if you could help me out with the other functionality would just be peachy....

Thank a mil (again)
0
 
nathansCommented:
Wow... if you need help cj I can jump in but  you have put a LOT of work in this one.

Nathan
http://www.cftipsplus.com
0
 
cheekycjCommented:
thanx nathans.. you can chime in if you want..

jriver12: please post your login.cfm code and the code that authenticates the user (the page that the login form posts to)

CJ
0
 
cheekycjCommented:
BTW: I am on the road for business so my responses might be a little slow during the week :-)
0
 
jriver12Author Commented:
from the login form page form action goes here.

<!--- Get user's details from the database --->
<cfquery name="GetUser" datasource="login">
SELECT     *
FROM      Users
WHERE     UserName      = '#Form.UserName#'
AND      Password      = '#Form.Password#'
</cfquery>

<!--- Check if we have a winner! --->
<cfif GetUser.RecordCount gt 0>
     
     <!--- Store the user id in session variables and cookies. --->
     <cfset Session.userID = GetUser.UserID>
     <cfcookie name="UserID" value="#GetUser.UserID#" expires="NOW">
     
     
<!--- If user exists, update his or her profile information --->
<!--- First get the old info - you may wish to use this somehow.  Some of the login stats are --->
<!--- cumulative, so we add to the prior number, like TotalLogins--->
     <cfset oldIP = getUser.LastIP>
     <cfset oldBrowser = getUser.LastBrowser>
     <cfset oldLogin = getUser.LastLogin>
     <cfset TotLogins = getUser.TotalLogins>

<!--- Store the new info in variables --->
     <cfset newIP = CGI.REMOTE_ADDR>
     <cfset newBrowser = CGI.HTTP_USER_AGENT>
     <cfset TotLogins = TotLogins + 1>

     <cfquery Datasource="exhibition" name="UpdateUser">
          UPDATE      Users
          SET      TotalLogins = #TotLogins#,
                    LastIP           = '#newIP#',
                    LastBrowser = '#newBrowser#',
                    LastLogin      = #CreateODBCDateTime(Now())#
          WHERE      UserID           = #session.UserID#
     </cfquery>
     
 
     <cflocation url="index.cfm" addtoken="Yes">


<cfelse>
<!--- User does not exist --->
<!--- Pass the variables back in the URL - message and UserName --->
<cfset loginpage = "default.cfm?Message=" & URLEncodedFormat("Invalid User Name/Password Combination")>
<cfset loginpage = loginpage & "&UserName=" & URLEncodedFormat(#Form.UserName#)>
<cflocation url="#loginpage#">
</cfif>



then my include for all pages that checks to see if the user is logged in or sessionis still active is :


<cfset bLoggedIn = False>
<cfif IsDefined("Session.UserID")>
  <cfif Session.UserID neq "">
  <cfset bLoggedIn = True>    
  </cfif>
  <cfelse>
  <cfif IsDefined("Cookie.UserID")>
       <cfif Cookie.UserID neq "">
       <cfset Session.UserID = Cookie.UserID>
                 <cfset bLoggedIn = True>
       </cfif>
  </cfif>
</cfif>
<cfif bLoggedIn IS "False">
 <cfset currentURL = "#CGI.Script_Name#?#CGI.Query_String#">
 <cflocation url="login2.cfm?requestedURL=#URLEncodedFormat(currentURL)#">

 <!--- <cflocation url="default.cfm?requestedURL=" & URLEncodedFormat(currentURL)> --->
</cfif>
0
 
cheekycjCommented:
I also need the login form page code.

CJ
0
 
jriver12Author Commented:
Sorry,

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">

<html>
<head>
     <title>Login to Access Your Account</title>
</head>
<cfset pagecaption ="You must Login to Proceed!">
<cfinclude template="htmlheader.cfm">
<body bgcolor="#FFFFCC" text="#000000" link="#333333" vlink="#333333" alink="#333333">
<font face="Verdana, Arial, Helvetica">
<h4>Login to the U.S. Poultry &amp; Egg Association's Exhibitor Management System:</h4>
<p>
  <cfif IsDefined("URL.Message")>
  <cfoutput><b>#URL.Message#</b></cfoutput>
  </cfif>
<cfform action="login2.cfm" method="post">
  <cfif IsDefined("URL.UserName")>
  <b>User Name:</b>
  <cfinput type="Text" required="Yes" message="Please Enter a User Name" name="UserName" maxlength="10" value="#URL.UserName#">
  <cfelse>
  <b>User Name:</b>
  <cfinput type="Text" required="Yes" message="Please Enter a User Name" name="UserName" maxlength="10">
  </cfif>
  <p> <b>Password:</b>
    <cfinput type="Password" required="Yes" message="Please Enter a Password" name="Password" maxlength="8">
  <p>
    <input type="submit" value="Login!">
</cfform>
</font>
<cfinclude template="HtmlFooter.cfm">
</body>
</html>

0
 
cheekycjCommented:
Sorry it took so long.. try this out:

include file to check if user is logged in:
<cfset bLoggedIn = False>
<cfif IsDefined("Session.UserID")>
 <cfif Session.UserID neq "">
 <cfset bLoggedIn = True>    
 </cfif>
 <cfelse>
 <cfif IsDefined("Cookie.UserID")>
      <cfif Cookie.UserID neq "">
      <cfset Session.UserID = Cookie.UserID>
                <cfset bLoggedIn = True>
      </cfif>
 </cfif>
</cfif>
<cfif bLoggedIn IS "False">
<cfset currentURL = "#CGI.Script_Name#?#CGI.Query_String#">
<cflocation url="default.cfm?requestedURL=#URLEncodedFormat(currentURL)#">

<!--- <cflocation url="default.cfm?requestedURL=" & URLEncodedFormat(currentURL)> --->
</cfif>


default.cfm:

<html>
<head>
    <title>Login to Access Your Account</title>
</head>
<cfset pagecaption ="You must Login to Proceed!">
<cfinclude template="htmlheader.cfm">
<body bgcolor="#FFFFCC" text="#000000" link="#333333" vlink="#333333" alink="#333333">
<font face="Verdana, Arial, Helvetica">
<h4>Login to the U.S. Poultry &amp; Egg Association's Exhibitor Management System:</h4>
<p>
 <cfif IsDefined("URL.Message")>
 <cfoutput><b>#URL.Message#</b></cfoutput>
 </cfif>
<cfform action="login2.cfm" method="post">
 <cfif IsDefined("URL.UserName")>
 <b>User Name:</b>
 <cfinput type="Text" required="Yes" message="Please Enter a User Name" name="UserName" maxlength="10"
value="#URL.UserName#">
 <cfelse>
 <b>User Name:</b>
 <cfinput type="Text" required="Yes" message="Please Enter a User Name" name="UserName" maxlength="10">
 </cfif>
 <p> <b>Password:</b>
   <cfinput type="Password" required="Yes" message="Please Enter a Password" name="Password" maxlength="8">
 <p>
       <cfparam name="URL.requestedURL" default="">
       <input type="hidden" name="requestedURL" value="<cfoutput>#URL.requestedURL#</cfoutput>">
   <input type="submit" value="Login!">
</cfform>
</font>
<cfinclude template="HtmlFooter.cfm">
</body>
</html>


login2.cfm:
<cfif isDefined("FORM.requestedURL")>
      <cfset VARIABLES.requestedURL = FORM.requestedURL>
<cfelse>
      <cfset VARIABLES.requestedURL = "index.cfm">
</cfif>

<!--- Get user's details from the database --->
<cfquery name="GetUser" datasource="login">
SELECT     *
FROM      Users
WHERE     UserName      = '#Form.UserName#'
AND      Password      = '#Form.Password#'
</cfquery>

<!--- Check if we have a winner! --->
<cfif GetUser.RecordCount gt 0>
   
    <!--- Store the user id in session variables and cookies. --->
    <cfset Session.userID = GetUser.UserID>
    <cfcookie name="UserID" value="#GetUser.UserID#" expires="NOW">
   
   
<!--- If user exists, update his or her profile information --->
<!--- First get the old info - you may wish to use this somehow.  Some of the login stats are --->
<!--- cumulative, so we add to the prior number, like TotalLogins--->
    <cfset oldIP = getUser.LastIP>
    <cfset oldBrowser = getUser.LastBrowser>
    <cfset oldLogin = getUser.LastLogin>
    <cfset TotLogins = getUser.TotalLogins>

<!--- Store the new info in variables --->
    <cfset newIP = CGI.REMOTE_ADDR>
    <cfset newBrowser = CGI.HTTP_USER_AGENT>
    <cfset TotLogins = TotLogins + 1>

    <cfquery Datasource="exhibition" name="UpdateUser">
         UPDATE      Users
         SET      TotalLogins = #TotLogins#,
                   LastIP           = '#newIP#',
                   LastBrowser = '#newBrowser#',
                   LastLogin      = #CreateODBCDateTime(Now())#
         WHERE      UserID           = #session.UserID#
    </cfquery>
     

    <cflocation url="#VARIABLES.requestedURL#" addtoken="Yes">


<cfelse>
<!--- User does not exist --->
<!--- Pass the variables back in the URL - message and UserName --->
<cfset loginpage = "default.cfm?Message=" & URLEncodedFormat("Invalid User Name/Password Combination")>
<cfset loginpage = loginpage & "&UserName=" & URLEncodedFormat(#Form.UserName#)
                              & "&requestedURL=" & URLEncodedFormat(VARIABLES.requestedURL)>
<cflocation url="#loginpage#">
</cfif>


HTH,
CJ
0
 
jriver12Author Commented:
CJ,
when the session is expired and an action is taken that would take you to another page I get the following error.
Error Occurred While Processing Request
Error Diagnostic Information
An error has occurred.


HTTP/1.0 404 Object Not Found
now with in that looking at the debug info I see something that caught my eye.

1.  HTTP_REFERER=http://Development/052302/visitor/process/Ex_update.cfm?visitornumber=12&Ex_Comp_to=NA

2.  QUERY_STRING=requestedURL=%2FDevelopment%2F052302%2Fvisitor%2Fprocess%2FEx%5Fupdate%2Ecfm%3F&CFID=99&CFTOKEN=7591491

3.  this is the one that I think is causing the problem but I don't know how to resolve it.
SCRIPT_NAME=/Development/052302/Exhibitor/process/default.cfm

there is no file named default in that directory the only default.cfm in the entire app resides off the root.

thanks






0
 
cheekycjCommented:
I thought your login page was called default.cfm?

the page that has the login form.. where is that at?

0
 
jriver12Author Commented:
You are correct it is called defaut.cfm(contains the form),
login2.cfm does all the processign, and the include checks and redirects.

for what I am seeing I think that once the app sences that the session has ended. and sends you back to the default .cfm, and the user logs in. it is trying to send them back to the same directory but keeping the defaul.cfm as the page to look for.

the requested url at sessionclosing was "REQUESTEDURL=/Development/052302/Exhibitor/process/Ex_update.cfm?"

but the page that is being requested after logging in again is =/Development/052302/Exhibitor/process/default.cfm.

when there is no default.cfm in that directory it is at

Development/052302/
0
 
cheekycjCommented:
then change the code at two spots to wherever the correct login page is.. give an absolute url (since cflocation cannot take relative paths)

the first spot is in the included code.. where the cflocation tag is... change the default.cfm (that part only) there to the full path to default.cfm

the second spot is in login2.cfm: change the cflocation that is at the end of the <cfelse> portion of the code as the same as above.. so change the default.cfm (that part only) to the absolute path to default.cfm

CJ
0
 
jriver12Author Commented:
Cj I don't think that is the issue(in my newbie opinion).

I am going to try to out line what I have just discoverd  be patient.

1 user get to site and are not logged in so the have to be logged in.  they do so at default.cfm(submit)

2. during the submit process we go to login2.cfm which does a multiple of things 1 of which is to make sure that the user exist in the db.  in this case we have a winner (so we proceed to the index.cfm)

3.  at index.cfm the user elects to update a record, so they are taken to  somedir\someplace\inanotherfolder\update.cfm.(the record is now ready for update all changes made.)(submit)

4. (here is where I die) I have waited for the session to expire before hitting the submit, hence the scripts takeover and take me back to default.cfm, and in the location bar we see:

http://Development/052302/Exhibitor/process/default.cfm?requestedURL=%2FDevelopment%2F052302%2FExhibitor%2Fprocess%2FEx%5Fupdate%2Ecfm%3F&CFID=99&CFTOKEN=7591491

only one problem:
the above url is where I was but my url.varialble that I passed to get there has been striped.

so my actual url should be:

http://Development/052302/Exhibitor/process/default.cfm?requestedURL=%2FDevelopment%2F052302%2FExhibitor%2Fprocess%2FEx%5Fupdate%2Ecfm%3Fexhibitornumber%3D12%26Ex%5FComp%5Fto%3DNA&CFID=99&CFTOKEN=7591491

which upon successfuly loging in again I am taken back to the page to where I would have hit the submit button for the record to be updated.

How did I get this url.?

I hit the back button by accident and had realized that the url had change a bit.

now I think the bit of code that  controls this if I am not mistaken is
here in login2.cfm

<cfif isDefined("FORM.requestedURL")>
     <cfset VARIABLES.requestedURL = FORM.requestedURL>
<cfelse>
     <cfset VARIABLES.requestedURL = "index.cfm">
</cfif>

now on that submit button I had an action of :>#CGI.Script_Name# (notice the non exsitance of url variables) now this may be the issue but I am not sure so let me test it and I will let you know.

if you have any other sugestions let me know.
0
 
cheekycjCommented:
the include code should handle that.  It should append both the current URL and query string and make it a part of the requestedURL parameter.

I am not sure I follow how the code is behaving vs. the desired behavior.

could you paint out two scenarios.  Starting from the user trying to access a page with an expired session.
first scenario: what is actually going on.

second scenario: what should happen.

Thanx,
CJ
0
 
jriver12Author Commented:
thanks for bearing with me.

what I have done so far to by pass this issue is to copy the authenticate,default, and login2.cfm to each individual folder(temp fix) till either I figure out what I'm doing or till I learn to explain the cituation.

here we go:

1st scenario:
Path to edit.cfm = \recordedit\type\thisone\edit.cfm
Path to the login2,authenticate,and default.cfm = \
the user is at a record update screen(edit.cfm), now the session is timed out when they submit the record for update they should get a login screen that tell them to log back in.  it should take them back to \default.cfm, but it is not it is going to \recordedit\type\thisone\default.cfm

where the default.cfm does not exist.

2nd scenario:(using same structure as above)
what should happen is that once the session is ended and an action is attempted the user should be taken to the default.cfm page so they may log in, then once the login is successful it should continue with the processing of the update or action that was requested prior to the reestablishment of the session with the login.
0
 
cheekycjCommented:
try this:
include file to check if user is logged in:
<cfset bLoggedIn = False>
<cfif IsDefined("Session.UserID")>
<cfif Session.UserID neq "">
<cfset bLoggedIn = True>    
</cfif>
<cfelse>
<cfif IsDefined("Cookie.UserID")>
     <cfif Cookie.UserID neq "">
     <cfset Session.UserID = Cookie.UserID>
               <cfset bLoggedIn = True>
     </cfif>
</cfif>
</cfif>
<cfif bLoggedIn IS "False">
<cfset currentURL = "#CGI.Script_Name#?#CGI.Query_String#">
<cflocation url="/default.cfm?requestedURL=#URLEncodedFormat(currentURL)#">

<!--- <cflocation url="default.cfm?requestedURL=" & URLEncodedFormat(currentURL)> --->
</cfif>


default.cfm:

<html>
<head>
   <title>Login to Access Your Account</title>
</head>
<cfset pagecaption ="You must Login to Proceed!">
<cfinclude template="htmlheader.cfm">
<body bgcolor="#FFFFCC" text="#000000" link="#333333" vlink="#333333" alink="#333333">
<font face="Verdana, Arial, Helvetica">
<h4>Login to the U.S. Poultry &amp; Egg Association's Exhibitor Management System:</h4>
<p>
<cfif IsDefined("URL.Message")>
<cfoutput><b>#URL.Message#</b></cfoutput>
</cfif>
<cfform action="login2.cfm" method="post">
<cfif IsDefined("URL.UserName")>
<b>User Name:</b>
<cfinput type="Text" required="Yes" message="Please Enter a User Name" name="UserName" maxlength="10"

value="#URL.UserName#">
<cfelse>
<b>User Name:</b>
<cfinput type="Text" required="Yes" message="Please Enter a User Name" name="UserName" maxlength="10">
</cfif>
<p> <b>Password:</b>
  <cfinput type="Password" required="Yes" message="Please Enter a Password" name="Password" maxlength="8">
<p>
     <cfparam name="URL.requestedURL" default="">
     <input type="hidden" name="requestedURL" value="<cfoutput>#URL.requestedURL#</cfoutput>">
  <input type="submit" value="Login!">
</cfform>
</font>
<cfinclude template="HtmlFooter.cfm">
</body>
</html>


login2.cfm:
<cfif isDefined("FORM.requestedURL")>
     <cfset VARIABLES.requestedURL = FORM.requestedURL>
<cfelse>
     <cfset VARIABLES.requestedURL = "index.cfm">
</cfif>

<!--- Get user's details from the database --->
<cfquery name="GetUser" datasource="login">
SELECT     *
FROM      Users
WHERE     UserName      = '#Form.UserName#'
AND      Password      = '#Form.Password#'
</cfquery>

<!--- Check if we have a winner! --->
<cfif GetUser.RecordCount gt 0>
   
   <!--- Store the user id in session variables and cookies. --->
   <cfset Session.userID = GetUser.UserID>
   <cfcookie name="UserID" value="#GetUser.UserID#" expires="NOW">
   
   
<!--- If user exists, update his or her profile information --->
<!--- First get the old info - you may wish to use this somehow.  Some of the login stats are --->
<!--- cumulative, so we add to the prior number, like TotalLogins--->
   <cfset oldIP = getUser.LastIP>
   <cfset oldBrowser = getUser.LastBrowser>
   <cfset oldLogin = getUser.LastLogin>
   <cfset TotLogins = getUser.TotalLogins>

<!--- Store the new info in variables --->
   <cfset newIP = CGI.REMOTE_ADDR>
   <cfset newBrowser = CGI.HTTP_USER_AGENT>
   <cfset TotLogins = TotLogins + 1>

   <cfquery Datasource="exhibition" name="UpdateUser">
        UPDATE      Users
        SET      TotalLogins = #TotLogins#,
                  LastIP           = '#newIP#',
                  LastBrowser = '#newBrowser#',
                  LastLogin      = #CreateODBCDateTime(Now())#
        WHERE      UserID           = #session.UserID#
   </cfquery>
   

   <cflocation url="#VARIABLES.requestedURL#" addtoken="Yes">


<cfelse>
<!--- User does not exist --->
<!--- Pass the variables back in the URL - message and UserName --->
<cfset loginpage = "default.cfm?Message=" & URLEncodedFormat("Invalid User Name/Password Combination")>
<cfset loginpage = loginpage & "&UserName=" & URLEncodedFormat(#Form.UserName#)
                         & "&requestedURL=" & URLEncodedFormat(VARIABLES.requestedURL)>
<cflocation url="#loginpage#">
</cfif>


HTH,
CJ
0
 
jriver12Author Commented:
CJ, it looks like it is working. :)

would you mind if I apply it to all the pages that I need them in and I will release the question.?
0
 
cheekycjCommented:
its working?  great!

Do whatever you want with the code.. I am just glad you got it to work :-)

CJ
0
 
jriver12Author Commented:
I didn't you did
thanks a mil.

enjoy the long weekend (if you are like most of we don't get much of those)
0
 
cheekycjCommented:
tell me about it.. I have to travel for biz on Tuesday.. so I am going to really enjoy this rare time to relax :-)

CJ
0
 
jriver12Author Commented:
yup yup!
0
 
jriver12Author Commented:
CJ,
i have been running the script for a day and change now and all looks good.
thanks for bearing with me i realy do appreciate it.

I had in the past tried to follow nathans newsletters on logins but got lost in the translation.

however thanks you all who contributed to this thread.
0
 
jriver12Author Commented:
nathan thanks for listening in once I saw you where listening I went back into my newsletters and found some that where promising but to advanced for me to follow thanks for the offer of helping and please keep sending out the news letter people like me realy learn from and enjoy those newsletters.

thanks.
0
 
jriver12Author Commented:
works wonderfully,
I will let you know how it does under stress.
0
 
cheekycjCommented:
Glad it worked for ya.  Thanx for the "A".

Keep me updated on the perf side of things.

CJ
0
 
jriver12Author Commented:
I did have to make 1 modification.

why

when I put it on the server it was having a hard time finding the Default.cfm(it would time out)no matter what path i gave, so....

I forced my browser to look at another page index.cfm which in return had the include that checks for user and session and being that it was no there I then rediredted to default.

works like a charm so far.
0

Featured Post

New feature and membership benefit!

New feature! Upgrade and increase expert visibility of your issues with Priority Questions.

  • 39
  • 30
Tackle projects and never again get stuck behind a technical roadblock.
Join Now