Re: next and previous records

2005-05-24 Thread J Elder
You're not passing your variables. On 5/20/05, WebStop Internet Services wrote: > Help! This keeps failing after the first 25 records are displayed and it > shows all records in the database 25 at a time not just the ones queried > originally by say company_name. Anyone

RE: next and previous records

2005-05-20 Thread Andrew Scott
Your problem is your query. Every time this page is called it is calling the query every time. So you need to either push the query into session var, and pull the records out 25 at a time or re write the query to pull 25 records out at a time. Both have their pitfalls, session if any new records

RE: Next and previous records

2001-08-21 Thread Michael Wilson
alk >Subject: Re: Next and previous records > > >If this was based on the next x script here (I think it may have been) then >the "cacheing" was simply missed in the copy paste. > >http://cfhub.com/discussion/viewmessages.cfm?Forum=11&Topic=422 > >Simply add

Re: Next and previous records

2001-08-20 Thread Joseph Thompson
--- Original Message - > From: "Don Vawter" <[EMAIL PROTECTED]> > To: "CF-Talk" <[EMAIL PROTECTED]> > Sent: Monday, August 20, 2001 9:19 AM > Subject: Re: Next and previous records > > > > Just a couple of notes: > > 1. Why not use a

Re: Next and previous records

2001-08-20 Thread Brandon Wood
Does anyone have a good query cache idea that would work with the example included? Thanks, Brandon - Original Message - From: "Don Vawter" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Monday, August 20, 2001 9:19 AM Subject: Re: Next

Re: Next and previous records

2001-08-20 Thread Don Vawter
ot;Michael Wilson" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Monday, August 20, 2001 7:59 AM Subject: RE: Next and previous records > Thanks > > This is what I wound up going with. Seems to be working fine so far. > > ...thanks, Joseph.

RE: Next and previous records

2001-08-20 Thread Michael Wilson
Thanks This is what I wound up going with. Seems to be working fine so far. ...thanks, Joseph. SELECT portfolio.*, media.*, clients.Client, portfolio.Description AS PortDesc FROMportfolio, media, clients WHERE portfolio.TypeID = #URL.ID# And portfolio.ID = media.Por

Re: Next and previous records

2001-08-19 Thread sanathr
one thing I can suggest is make use of the maxrecords option in the tag. and then in the query say portfolio.TypeID> then page number etc etc. I hope U understand. just in case U have sorting stuff also then this kinda thing gets a bit complicated. --

RE: Next and previous records

2001-08-19 Thread Tilbrook, Peter
Try something like this (this template is called "users_list.cfm"): NOTE: pass the #URL# to this template and the use code here error trapping SELECT DISTINCT UserID, UserName, UserFirstName, UserMiddleName, UserLastName, UserEmailAddress, UserLevel FROM Users ORDER BY UserLastName ASC