Welcome to Dream.In.Code
Become an Expert!

Join 149,984 Programmers for FREE! Get instant access to thousands of experts, tutorials, code snippets, and more! There are 1,385 people online right now. Registration is fast and FREE... Join Now!




Coldfusion recordsetpaging advanced

 
Reply to this topicStart new topic

Coldfusion recordsetpaging advanced, recordset paging user identification

xxxxxikke
10 Dec, 2006 - 05:06 PM
Post #1

New D.I.C Head
*

Joined: 10 Dec, 2006
Posts: 1


My Contributions
I try to explain my problem as follows:
I adopt standard recordset paging from macromedia to select all kinds of different breeds in my database (cfquerybreed). So, then I can navigate through my database seeing all my breeds and the users that have these breeds. No problem at all. I can see all the fields etc, works perfectly.

However, I also want to display user images which are in another table, (connected by IDnumbers).

However, the standard paging only gives ?PageNum_cfquerybreeds=3&breedid=10 as URL parameters. So, I know the breedid and the pagenum, but how do I know which userid is listed on which page? (need this for my user images)

So, rephrased as follows: How can I couple userid as url variable to the standard recordsetpaging, giving me information about which userid is shown when I navigate through my breed query. If I can show this as a url variable; i can display the images for that user.

This post has been edited by xxxxxikke: 10 Dec, 2006 - 05:12 PM
User is offlineProfile CardPM
+Quote Post

psykoprogrammer
RE: Coldfusion Recordsetpaging Advanced
13 Dec, 2006 - 07:09 AM
Post #2

D.I.C Head
Group Icon

Joined: 9 Oct, 2006
Posts: 68


Dream Kudos: 50
My Contributions
Well, pass the userId along with the URL variable (i.e. modify your code to include the userID in the paging code), or, if this site is the type that requires login, store your logged in user in the SESSION scope, and you won't need to pass it along the URL.
User is offlineProfile CardPM
+Quote Post

Fast ReplyReply to this topicStart new topic
Time is now: 1/8/09 07:22PM

Be Social

Dream.In.Code RSS Feed Dream.In.Code LinkedIn Group Follow Us On Twitter

Live Help!

Tutorials

Programming

Web Development

Reference Sheets

Code Snippets

DIC Chatroom

Bye Bye Ads

Monthly Drawing

Thumb Drive

Top Contributors

Top 10 Kudos This Month