Re: Next/Previous Records with UUID
Anyone got any ideas on next records when using UUID's? ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:260101 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Next/Previous Records with UUID
Sure you can go up down and all over the place without a primary key. The cfquery object comes packed with a host of features and is the most feature rich object of the whole coldfusion arsenal. Mastery of this object is fundamental to understanding coldfusion. You can get record position using any data inside a row or jump relative to that row. goto this link http://tech.groups.yahoo.com/group/java_coldfusion_hacks/ search for 1.next() or 2.cfquery ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:260111 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Next/Previous Records with UUID
I am wanting to do a next and previous link so I can look through my records, the problem I have is that Primary Key is not a autonumber, it is a UUID. Is there an easy way to return the next and previous UUID in a table easily. Flew ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:259954 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Suggestions for grouped query and next/previous paging
Sorry to bump this one up again, but I wanted to see if anyone had any post-Christmas thoughts on this one. Thanks! Jake I'm with you, and that's basically what I'm doing. I do a query, group in the Group items shown below. Not a problem there. It's getting the data to a) break in the right spot (only breaking between groups, not in the middle of a single group), and b) to get the ordering right. For example... this is the right way, what I'm trying to do: Group 1 - Item 1a - Item 2a - Item 3a Group 2 - Item 1b === next page === Group 3 - Item 1c - Item 2c Group 4 - Item 1d - Item 2d But I end up getting weird things like: Group 1 - Item 1a - Item 2a Group 4 - Item 1d - Item 2d Group 2 - Item 1b - Item 2c === next page === Group 3 - Item 3a - Item 1c This is using the grouped query approach: CFOUTPUT query=myQueryName group=mygroupfield #Title# CFOUTPUT group=someotherfield #Entry# /CFOUTPUT /CFOUTPUT Does that makes sense? Thanks! Jake I think I would try breaking on the Group. If you can, determine the number of groups you have and treat each group as if it were its own record. Then you can page by each group, with a set number of groups on each page. I'd guess you could select distinct on the column that Group derives from, then use that number to determine the number of pages you would have. Does this make any sense? - Matt Small -Original Message- From: Jake [mailto:[EMAIL PROTECTED] Sent: Friday, December 17, 2004 9:23 AM To: CF-Talk Subject: Suggestions for grouped query and next/previous paging All, I'm outputting a grouped query: Group 1 - Item 1a - Item 2a - Item 3a Group 2 - Item 1b Group 3 - Item 1c - Item 2c and so on... but the query results in a large number of records, so I want to add next/previous paging. The grouping I have no trouble setting up, but how to I break the results up? If you add the standard next/previous to the grouped query, it tends to break up in really odd ways. Thanks! Jake ~| Special thanks to the CF Community Suite Silver Sponsor - CFDynamics http://www.cfdynamics.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:189112 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Suggestions for grouped query and next/previous paging
I'm with you, and that's basically what I'm doing. I do a query, group in the Group items shown below. Not a problem there. It's getting the data to a) break in the right spot (only breaking between groups, not in the middle of a single group), and b) to get the ordering right. For example... this is the right way, what I'm trying to do: Group 1 - Item 1a - Item 2a - Item 3a Group 2 - Item 1b === next page === Group 3 - Item 1c - Item 2c Group 4 - Item 1d - Item 2d But I end up getting weird things like: Group 1 - Item 1a - Item 2a Group 4 - Item 1d - Item 2d Group 2 - Item 1b - Item 2c === next page === Group 3 - Item 3a - Item 1c This is using the grouped query approach: CFOUTPUT query=myQueryName group=mygroupfield #Title# CFOUTPUT group=someotherfield #Entry# /CFOUTPUT /CFOUTPUT Does that makes sense? Thanks! Jake I think I would try breaking on the Group. If you can, determine the number of groups you have and treat each group as if it were its own record. Then you can page by each group, with a set number of groups on each page. I'd guess you could select distinct on the column that Group derives from, then use that number to determine the number of pages you would have. Does this make any sense? - Matt Small -Original Message- From: Jake [mailto:[EMAIL PROTECTED] Sent: Friday, December 17, 2004 9:23 AM To: CF-Talk Subject: Suggestions for grouped query and next/previous paging All, I'm outputting a grouped query: Group 1 - Item 1a - Item 2a - Item 3a Group 2 - Item 1b Group 3 - Item 1c - Item 2c and so on... but the query results in a large number of records, so I want to add next/previous paging. The grouping I have no trouble setting up, but how to I break the results up? If you add the standard next/previous to the grouped query, it tends to break up in really odd ways. Thanks! Jake ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188739 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Suggestions for grouped query and next/previous paging
http://www.twcreations.com/recordcount/ All, I'm outputting a grouped query: Group 1 - Item 1a - Item 2a - Item 3a Group 2 - Item 1b Group 3 - Item 1c - Item 2c and so on... but the query results in a large number of records, so I want to add next/previous paging. The grouping I have no trouble setting up, but how to I break the results up? If you add the standard next/previous to the grouped query, it tends to break up in really odd ways. Thanks! Jake ~| Special thanks to the CF Community Suite Silver Sponsor - New Atlanta http://www.newatlanta.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188756 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Suggestions for grouped query and next/previous paging
All, I'm outputting a grouped query: Group 1 - Item 1a - Item 2a - Item 3a Group 2 - Item 1b Group 3 - Item 1c - Item 2c and so on... but the query results in a large number of records, so I want to add next/previous paging. The grouping I have no trouble setting up, but how to I break the results up? If you add the standard next/previous to the grouped query, it tends to break up in really odd ways. Thanks! Jake ~| Special thanks to the CF Community Suite Silver Sponsor - CFDynamics http://www.cfdynamics.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:187993 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Suggestions for grouped query and next/previous paging
Hi Jake, I think I would try breaking on the Group. If you can, determine the number of groups you have and treat each group as if it were its own record. Then you can page by each group, with a set number of groups on each page. I'd guess you could select distinct on the column that Group derives from, then use that number to determine the number of pages you would have. Does this make any sense? - Matt Small -Original Message- From: Jake [mailto:[EMAIL PROTECTED] Sent: Friday, December 17, 2004 9:23 AM To: CF-Talk Subject: Suggestions for grouped query and next/previous paging All, I'm outputting a grouped query: Group 1 - Item 1a - Item 2a - Item 3a Group 2 - Item 1b Group 3 - Item 1c - Item 2c and so on... but the query results in a large number of records, so I want to add next/previous paging. The grouping I have no trouble setting up, but how to I break the results up? If you add the standard next/previous to the grouped query, it tends to break up in really odd ways. Thanks! Jake ~| Special thanks to the CF Community Suite Silver Sponsor - New Atlanta http://www.newatlanta.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:187999 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: select next/previous *record*?
Don't you need to know something else if you use Last Name as the index? What if there are multiple John Smith's? I haven't actually done this, but what if you pulled all records with the last name they selected, then used array notation to pull the ID from the record before and after the current record? Too bad databases don't generally have a numeric, sequential record number like ColdFusion's query object (currentRow variable). -Original Message- From: Matt Robertson [mailto:[EMAIL PROTECTED] Sent: Sunday, December 12, 2004 1:41 PM To: CF-Talk Subject: Re: select next/previous *record*? Quick question...are ya using DreamweaverMX? Nope. Another complication I didn't mentuion before is the user has the ability to select which index is current, so they might be indexing on ID, and cycling up and down thru the numbers, or one of several other fields, such as Last Name. I'm working thru that now. Don't see how it would work in the ID-based example. -- --Matt Robertson-- President, Janitor MSB Designs, Inc. mysecretbase.com ~| Special thanks to the CF Community Suite Silver Sponsor - New Atlanta http://www.newatlanta.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:187409 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: select next/previous *record*?
Yes, I was thinking along the same lines, but I can't think of a way to do it that would be even remotely efficient across about 10 key fields they want to page thru display on. I may revisit the issue when I have some more time but these guys have signed off on foregoing this feature for now. -- --Matt Robertson-- President, Janitor MSB Designs, Inc. mysecretbase.com ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:187460 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: select next/previous *record*?
I have an application where the user selects a record via a key lookup, and then that record is displayed individually. From there I want to be able to click a '' button to go to the previous record in the sequence, or a '' to go to the next record, and continue to select records via this method as an alternative to the key lookup. I did this in an entirely different environment where I was able to use native controls that allowed straight up SELECT NEXT and SELECT PREVIOUS commands, where I was also able to throw those commands into a loop for fast forward and rewind as well. Don't expect to get that in the web world, but I need the next/previous. I think I can come up with something, but the convolutions necessary to make it work are making my head hurt. Is there something simple and obvious I have missed on this (for me) Sunday morning?. Quick question...are ya using DreamweaverMX? ~| Special thanks to the CF Community Suite Silver Sponsor - CFDynamics http://www.cfdynamics.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:187284 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: select next/previous *record*?
Thanks Barney, thats *exactly* what I was looking for! -- --Matt Robertson-- President, Janitor MSB Designs, Inc. mysecretbase.com On Sun, 12 Dec 2004 11:12:27 -0800, Barney Boisvert [EMAIL PROTECTED] wrote: I'm not sure exactly what you're looking for, but if it's SQL, I've done this in the past: SELECT * FROM table WHERE id #currentId# ORDER BY id DESC LIMIT 1 for getting the previous item. Just flipt the to and make the order ASC to get next record. The LIMIT clause is MySQL's version of MS products' TOP clause. If you want to fast forward, the LIMIT clause also specifies an offset, so you can do LIMIT 19, 1 to pull the 20th item in the list. With MS's TOP clause, you have to pull all 20, and then just look at the last one, I believe. cheers, barneyb On Sun, 12 Dec 2004 10:58:50 -0800, Matt Robertson [EMAIL PROTECTED] wrote: I have an application where the user selects a record via a key lookup, and then that record is displayed individually. From there I want to be able to click a '' button to go to the previous record in the sequence, or a '' to go to the next record, and continue to select records via this method as an alternative to the key lookup. I did this in an entirely different environment where I was able to use native controls that allowed straight up SELECT NEXT and SELECT PREVIOUS commands, where I was also able to throw those commands into a loop for fast forward and rewind as well. Don't expect to get that in the web world, but I need the next/previous. I think I can come up with something, but the convolutions necessary to make it work are making my head hurt. Is there something simple and obvious I have missed on this (for me) Sunday morning?. -- --Matt Robertson-- President, Janitor MSB Designs, Inc. mysecretbase.com -- Barney Boisvert [EMAIL PROTECTED] 360.319.6145 http://www.barneyb.com/blog/ ~| Special thanks to the CF Community Suite Silver Sponsor - CFDynamics http://www.cfdynamics.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:187285 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: select next/previous *record*?
Quick question...are ya using DreamweaverMX? Nope. Another complication I didn't mentuion before is the user has the ability to select which index is current, so they might be indexing on ID, and cycling up and down thru the numbers, or one of several other fields, such as Last Name. I'm working thru that now. Don't see how it would work in the ID-based example. -- --Matt Robertson-- President, Janitor MSB Designs, Inc. mysecretbase.com ~| Special thanks to the CF Community Suite Silver Sponsor - CFDynamics http://www.cfdynamics.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:187288 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
select next/previous *record*?
I have an application where the user selects a record via a key lookup, and then that record is displayed individually. From there I want to be able to click a '' button to go to the previous record in the sequence, or a '' to go to the next record, and continue to select records via this method as an alternative to the key lookup. I did this in an entirely different environment where I was able to use native controls that allowed straight up SELECT NEXT and SELECT PREVIOUS commands, where I was also able to throw those commands into a loop for fast forward and rewind as well. Don't expect to get that in the web world, but I need the next/previous. I think I can come up with something, but the convolutions necessary to make it work are making my head hurt. Is there something simple and obvious I have missed on this (for me) Sunday morning?. -- --Matt Robertson-- President, Janitor MSB Designs, Inc. mysecretbase.com ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:187281 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: select next/previous *record*?
I'm not sure exactly what you're looking for, but if it's SQL, I've done this in the past: SELECT * FROM table WHERE id #currentId# ORDER BY id DESC LIMIT 1 for getting the previous item. Just flipt the to and make the order ASC to get next record. The LIMIT clause is MySQL's version of MS products' TOP clause. If you want to fast forward, the LIMIT clause also specifies an offset, so you can do LIMIT 19, 1 to pull the 20th item in the list. With MS's TOP clause, you have to pull all 20, and then just look at the last one, I believe. cheers, barneyb On Sun, 12 Dec 2004 10:58:50 -0800, Matt Robertson [EMAIL PROTECTED] wrote: I have an application where the user selects a record via a key lookup, and then that record is displayed individually. From there I want to be able to click a '' button to go to the previous record in the sequence, or a '' to go to the next record, and continue to select records via this method as an alternative to the key lookup. I did this in an entirely different environment where I was able to use native controls that allowed straight up SELECT NEXT and SELECT PREVIOUS commands, where I was also able to throw those commands into a loop for fast forward and rewind as well. Don't expect to get that in the web world, but I need the next/previous. I think I can come up with something, but the convolutions necessary to make it work are making my head hurt. Is there something simple and obvious I have missed on this (for me) Sunday morning?. -- --Matt Robertson-- President, Janitor MSB Designs, Inc. mysecretbase.com -- Barney Boisvert [EMAIL PROTECTED] 360.319.6145 http://www.barneyb.com/blog/ ~| Special thanks to the CF Community Suite Silver Sponsor - CFDynamics http://www.cfdynamics.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:187283 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Using CF for Next/Previous record script ??
I am using the following script to display next/previous records script based on Selene's at Webtricks script shown at the link below. http://www.webtricks.com/sourcecode/code.cfm?CodeID=7 However in my code below I am stating that there should be only 2 results shown on each page, however all results are being returned?/ Any ideas on why this is occuring from the script below??? - !DOCTYPE HTML PUBLIC -//W3C//DTD HTML 4.0 Transitional//EN html CFQUERY name=list datasource=intranetv8 SELECT * FROM itlinks WHERE linkarea='#URL.area#' /CFQUERY !--- Set the number of records to display on each page. --- cfset OnEachPage=2 !--- Set the default startrow to 1 if a value was not passed. --- !--- Determine whether or not to show the previous or next links. --- cfparam name=StartRow default=1 !--- Set the value of endrow to the maxrows + startrow - 1 --- cfset EndRow=StartRow + OnEachPage - 1 !--- If the end row is greater than the recordcount, determine how many records are left. --- cfif EndRow GTE list.RecordCount cfset EndRow=list.RecordCount cfset Next=false !--- Othereise, set Next to true and determine the next set of records. --- cfelse cfset Next=true cfif EndRow + OnEachPage GT list.RecordCount cfset NextNum=list.RecordCount - EndRow cfelse cfset NextNum= OnEachPage /cfif cfset NextStart=EndRow + 1 /cfif !--- If StartRow is 1, set Previous to false. --- cfif StartRow IS 1 cfset Previous=false !--- Othewise, determine the previous set of records. --- cfelse cfset Previous=true cfset PreviousStart=StartRow - OnEachPage /cfif !--- Determine how many pages will be displayed. --- cfset NumPages=Ceiling(list.RecordCount / OnEachPage) cfparam name=PageNum default=1 cfif list.recordcount neq 0 TITLELinks -/TITLE /head body cfoutput span class=bodytextThere are currently #list.RecordCount# links available to you. br Displaying links #StartRow# to #EndRow# /spanp /cfoutput cfoutput query=list table border=0 style=border-collapse: collapse bordercolor=##11 width=100% id=AutoNumber3 cellspacing=0 cellpadding=0 tr td width=6% p align=center img border=0 src=http://intranet.neath-porttalbot.gov.uk/testpages/itnet/images/linkicon.gif; width=15 height=17/td td width=94% colspan=2Ba class=homeaa href=#linkurl##linktitle#/a/B/td /tr tr td width=6%nbsp;/td td width=100% table border=0 cellpadding=0 cellspacing=0 style=border-collapse: collapse bordercolor=##11 width=100% id=AutoNumber4 tr td width=100% pspan class=bodytext#linkdesc#br /span img border=0 src=http://intranet.neath-porttalbot.gov.uk/testpages/itnet/images/bluesq.gif; align=absmiddle width=3 height=3 span class=item1Added by :/spanspan class=item2nbsp;#linkauthor#/span/p /td /tr /table /td /tr tr td width=100% colspan=3 p align=center img border=0 src=http://intranet.neath-porttalbot.gov.uk/testpages/itnet/images/itdldivider.gif; width=566 height=12/td /tr /table /CFOUTPUT table border=0 tr td valign=top !--- If Previous is true, display the previous link. --- cfif Previous cfoutput a href=previousnext.cfm?StartRow=#PreviousStart#PageNum=#DecrementValue(PageNum)#cfif IsDefined(Keyword)Keyword=#URLEncodedFormat(Keyword)#/cfiflt;lt;nbsp;Previous/a /cfoutput cfelse nbsp; /cfif /td cfloop from=1 to=#NumPages# index=ThisPage cfoutput cfif ThisPage IS PageNum td#ThisPage#/td cfelse cfset PageNumStart=(((ThisPage - 1) * OnEachPage) + 1) tda href=linksdetail.cfm?StartRow=#PageNumStart#PageNum=#ThisPage#cfif IsDefined(Keyword)Keyword=#URLEncodedFormat(Keyword)#/cfif#ThisPage#/a/td /cfif /cfoutput /cfloop td valign=top !--- If Next is true, display the previous link. --- cfif Next cfoutput a href=linksdetail.cfm?StartRow=#NextStart#PageNum=#IncrementValue(PageNum)#cfif IsDefined(Keyword)Keyword=#URLEncodedFormat(Keyword)#/cfifNextnbsp;gt;gt;/a /cfoutput cfelse nbsp; /cfif /td /tr /tablep cfelse No results returned /cfif Pnbsp;/P Pnbsp;/P Pnbsp;/P /table /body /html ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
next previous with grouped output
Hello all, I'm having a hard time wrapping my brain around doing a next page type output where the query output is grouped. Basically, the table has products made up of three records (each) that are output as one. I wish the differences were simply attributes to I could normalize the product table, but unfortunately, they need to be treated as seperate products. The number of records returned is NOT always going to be three times the number of products listed. Sometimes each product will only have one record, and sometimes up to three. Any ideas?? Jeff Beer Director of Application Development Digital Stormfront, Inc http://www.digitalstormfront.com http://www.digitalstormfront.com __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: next previous with grouped output
use a DISTINCT clause in your SELECT statement. That way each product will only have one record and the rest of the problem solves itself... +---+ Bryan Love Macromedia Certified Professional Internet Application Developer Database Analyst Telecommunication Systems [EMAIL PROTECTED] +---+ ...'If there must be trouble, let it be in my day, that my child may have peace'... - Thomas Paine, The American Crisis -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Monday, May 13, 2002 9:27 AM To: CF-Talk Subject: next previous with grouped output Hello all, I'm having a hard time wrapping my brain around doing a next page type output where the query output is grouped. Basically, the table has products made up of three records (each) that are output as one. I wish the differences were simply attributes to I could normalize the product table, but unfortunately, they need to be treated as seperate products. The number of records returned is NOT always going to be three times the number of products listed. Sometimes each product will only have one record, and sometimes up to three. Any ideas?? Jeff Beer Director of Application Development Digital Stormfront, Inc http://www.digitalstormfront.com http://www.digitalstormfront.com __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Next/Previous???
Does anyone know of an unencrypted tag that will do next/previous start/end type navigation. The type that outputs like Anyone? -Kelly ~~ Kelly Matthews Senior Programmer [EMAIL PROTECTED] http://www.allsoldout.net 703.387.4000 x 35 ~~ __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Next/Previous???
Give qdnext a try: http://www.quilldesign.com It allows you to set next/previous pages as well as series of pages ... and it's open source.. Paul Giesenhagen QuillDesign http://www.quilldesign.com SiteDirector - Commerce Builder Does anyone know of an unencrypted tag that will do next/previous start/end type navigation. The type that outputs like Anyone? -Kelly ~~ Kelly Matthews Senior Programmer [EMAIL PROTECTED] http://www.allsoldout.net 703.387.4000 x 35 ~~ __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Next/Previous???
search dev-exchange for CF_recordcount it is very nice and unencrypted. Success is a journey, not a destination!! Doug Brown - Original Message - From: Kelly Matthews [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, March 04, 2002 8:48 AM Subject: Next/Previous??? Does anyone know of an unencrypted tag that will do next/previous start/end type navigation. The type that outputs like Anyone? -Kelly ~~ Kelly Matthews Senior Programmer [EMAIL PROTECTED] http://www.allsoldout.net 703.387.4000 x 35 ~~ __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Next/Previous???
Maybe I am missing something but the help on this is SERIOUSLY lacking [EMAIL PROTECTED] writes: search dev-exchange for CF_recordcount it is very nice and unencrypted. ~~ Kelly Matthews Senior Programmer [EMAIL PROTECTED] http://www.allsoldout.net 703.387.4000 x 35 ~~ __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Next/Previous???
It would probably just be easier to write it yourself, its pretty basic.. Quick dirty example below.. - cfparam name=MyStartRow default=1 cfset MyMaxRows = 10 cfif MyStartRow is 0 PROBLEMS! cfabort /cfif cfquery name=MyQuery datasource=MyDataSource SomeQuery /cfquery cfoutput query=MyQuery StartRow=#MyStartRow# MaxRows=#MyMaxRows# Some output /cfoutput cfif MyStartRow - MyMaxRows gt 0 cfoutput a href=MyPage.cfm?MyStartRow=#Evaluate(MyStartRow - MyMaxRows)#Previous #MyMaxRows#/a /cfoutput /cfif cfif MyStartRow + MyMaxRows lt MyQuery.RecordCount cfoutput a href=MyPage.cfm?MyStartRow=#Evaluate(MyStartRow + MyMaxRows)#Next #MyMaxRows#/a /cfoutput /cfif -Original Message- From: Kelly Matthews [mailto:[EMAIL PROTECTED]] Sent: Monday, March 04, 2002 12:25 PM To: CF-Talk Subject: Re: Next/Previous??? Maybe I am missing something but the help on this is SERIOUSLY lacking [EMAIL PROTECTED] writes: search dev-exchange for CF_recordcount it is very nice and unencrypted. ~~ Kelly Matthews Senior Programmer [EMAIL PROTECTED] http://www.allsoldout.net 703.387.4000 x 35 ~~ __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: RE: Next/Previous???
Probably and I have a normal next previous module I have been using for years but as I mentioned in my first message they want it like this which is a tad different then Next/Previous... don't worry about it i will figure it out eventually... [EMAIL PROTECTED] writes: It would probably just be easier to write it yourself, its pretty basic.. Quick dirty example below.. - cfparam name=MyStartRow default=1 cfset MyMaxRows = 10 cfif MyStartRow is 0 PROBLEMS! cfabort /cfif cfquery name=MyQuery datasource=MyDataSource SomeQuery /cfquery cfoutput query=MyQuery StartRow=#MyStartRow# MaxRows=#MyMaxRows# Some output /cfoutput cfif MyStartRow - MyMaxRows gt 0 cfoutput a href=MyPage.cfm?MyStartRow=#Evaluate(MyStartRow - MyMaxRows)#Previous #MyMaxRows#/a /cfoutput /cfif cfif MyStartRow + MyMaxRows lt MyQuery.RecordCount cfoutput a href=MyPage.cfm?MyStartRow=#Evaluate(MyStartRow + MyMaxRows)#Next #MyMaxRows#/a /cfoutput /cfif ~~ Kelly Matthews Senior Programmer [EMAIL PROTECTED] http://www.allsoldout.net 703.387.4000 x 35 ~~ __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Next/Previous???
Kelly, Take a look at my custom tag and let me know if this is what you are looking for. http://www.cfxtras.com/SalesComponentDetail.cfx?componentid=221 If it is, hit me up off list for a copy. Thank you, Joseph DeVore VeloxWeb Technologies -Original Message- From: Kelly Matthews [mailto:[EMAIL PROTECTED]] Sent: Monday, March 04, 2002 8:49 AM To: CF-Talk Subject: Next/Previous??? Does anyone know of an unencrypted tag that will do next/previous start/end type navigation. The type that outputs like Anyone? -Kelly ~~ Kelly Matthews Senior Programmer [EMAIL PROTECTED] http://www.allsoldout.net 703.387.4000 x 35 ~~ __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Next/Previous???
On 3/4/02, Kelly Matthews penned: Does anyone know of an unencrypted tag that will do next/previous start/end type navigation. The type that outputs like cf_recordcount http://www.twcreations.com/recordcount/ Look at the Links method. Works on grouped output from joined queries also. Freebie. :) -- Bud Schneehagen - Tropical Web Creations _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ ColdFusion Solutions / eCommerce Development [EMAIL PROTECTED] http://www.twcreations.com/ __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Next/Previous???
Does anyone know of an unencrypted tag that will do next/previous start/end type navigation. You can also check out CF_QueryBrowse at http://www.cfdev.com/products its free. + Pete Freitag ([EMAIL PROTECTED]) CTO, CFDEV.COM ColdFusion Developer Resources http://www.cfdev.com/ __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Need a good next/previous tag
Trying to search through the allaire exchange (way too slow). Anyone have a link to an excellent and easy to implement next/previous tag for database records. thanks. daniel ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Link to good Next/Previous Tag
http://www.johnstons.org/wdc/pub/cfusion/customtags/CF_PageThru/CF_PageT hru.html This is one I've used before, and it is pretty spiffy :) Try it out. -Gel ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Need a good next/previous tag
this might work for you http://www.johnstons.org/wdc/pub/cfusion/customtags/CF_PageThru/CF_PageThru. html - Original Message - From: Daniel [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Wednesday, November 21, 2001 8:26 AM Subject: Need a good next/previous tag Trying to search through the allaire exchange (way too slow). Anyone have a link to an excellent and easy to implement next/previous tag for database records. thanks. daniel ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Need a good next/previous tag
On 11/21/01, Daniel penned: Trying to search through the allaire exchange (way too slow). Anyone have a link to an excellent and easy to implement next/previous tag for database records. Try my free cf_recordcount. Works on grouped output also. :) http://www.twcreations.com/cf.html -- Bud Schneehagen - Tropical Web Creations _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ ColdFusion Solutions / eCommerce Development [EMAIL PROTECTED] http://www.twcreations.com/ ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Need a good next/previous tag
On 11/21/01, Troy Montour penned: this might work for you http://www.johnstons.org/wdc/pub/cfusion/customtags/CF_PageThru/CF_PageThru. html The demo's broken: http://www.johnstons.org/products/search/search-t.cfm?CurrentPage=6 HTTP/1.0 404 Object Not Found -- Bud Schneehagen - Tropical Web Creations _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ ColdFusion Solutions / eCommerce Development [EMAIL PROTECTED] http://www.twcreations.com/ ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Next/Previous
=#currentrowbgcolor# valign=topfont face=#session.fontface# size=#session.tablefontsize##currentrow#nbsp;/td td bgcolor=#currentrowbgcolor# align=topfont face=#session.fontface# size=#session.tablefontsize# a href=#session.web_root_path#/companies/index.cfm?fuseaction=companies_detai leregnum=#eregnum#reset_search=1#ename#/abr #estreet1# cfif Trim(estreet2) neq br #estreet2#br /cfif cfif Trim(ophone) neq br #ophone# /cfif nbsp;/td td bgcolor=#currentrowbgcolor# valign=topfont face=#session.fontface# size=#session.tablefontsize##ecity#nbsp;/td td bgcolor=#currentrowbgcolor# valign=topfont face=#session.fontface# size=#session.tablefontsize##estate#nbsp;/td td bgcolor=#currentrowbgcolor# valign=topfont face=#session.fontface# size=#session.tablefontsize##ezip#cfif Trim(ezipext) neq -#ezipext#/cfifnbsp;/td td bgcolor=#currentrowbgcolor# valign=topfont face=#session.fontface# size=#session.tablefontsize##ecounty#nbsp;/td td bgcolor=#currentrowbgcolor# valign=topfont face=#session.fontface# size=#session.tablefontsize##ecountry#nbsp;/td cfif session.groups contains 1 td bgcolor=#currentrowbgcolor# valign=topfont face=#session.fontface# size=#session.tablefontsize#a href=#session.web_root_path#/admin/companies/index.cfm?fuseaction=admin_com panies_editid_registration=#id_registration#Edit/a/td /cfif /tr /cfoutput cfoutput tr td colspan=3font face=#session.fontface# size=#session.fontsize#a href=#script_name#?fuseaction=#fuseaction#start=1ename=#URLEncodedFormat( ename)#county=#URLEncodedFormat(county)#state=#URLEncodedFormat(state)#so rtby=enamesearch_option=#URLEncodedFormat(search_option)#Original Device Companies Search Results/anbsp;/td td colspan=5 align=rightfont face=#session.fontface# size=#session.fontsize# cfif get_companies.recordcount gt 10 a href=#script_name#?fuseaction=#fuseaction#start=#PrevStart#ename=#URLEnco dedFormat(ename)#county=#URLEncodedFormat(county)#state=#URLEncodedFormat( state)#sortby=#sortby#search_option=#URLEncodedFormat(search_option)#Pre vious #maxrows#/a nbsp; a href=#script_name#?fuseaction=#fuseaction#start=#NextStart#ename=#URLEnco dedFormat(ename)#county=#URLEncodedFormat(county)#state=#URLEncodedFormat( state)#sortby=#sortby#search_option=#URLEncodedFormat(search_option)#Nex t #maxrows#/a /cfif nbsp;/td /tr /cfoutput /table /cfif /cfif = Mark Warrick - Fusioneers.com Personal Email: [EMAIL PROTECTED] Business Email: [EMAIL PROTECTED] Phone: 714-547-5386 Efax: 801-730-7289 Personal URL: http://www.warrick.net Business URL: http://www.fusioneers.com ICQ: 125160 / AIM: markwarric = -Original Message- From: Joshua Tipton [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 31, 2001 11:09 AM To: CF-Talk Subject: Next/Previous Anyone have code for a good previous and next record display. I can write one but I am feeling lazy. TIA, Joshua Tipton ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Next/Previous
Anyone have code for a good previous and next record display. I can write one but I am feeling lazy. TIA, Joshua Tipton ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Next/Previous
Joshua, I like CF_QueryBrowse from the CF Developer's Exchange. It's extremely customizable. It also provides the actual result page numbers at the bottom (1, 2, 3, 4...etc., though I could not get that to work with this tag). The only weird thing I found is that for some reason, I cannot get the Next/Previous links to move over to the right side of my page--weird! But other than that, it works great. I ended up using this tag because I absolutely HAD to be able to use 2 queries in my Next/Previous result set, and this tag allowed me to customize it to do just that. Terri Original Message Follows From: Joshua Tipton [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Subject: Next/Previous Date: Tue, 31 Jul 2001 14:09:15 -0400 Anyone have code for a good previous and next record display. I can write one but I am feeling lazy. TIA, Joshua Tipton ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Next/Previous
The direct link for QueryBrowse is: http://www.cfdev.com/products/productdetail.cfm?id=1004ref=126 -Original Message- From: Terri Stocke [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 31, 2001 2:15 PM To: CF-Talk Subject: Re: Next/Previous Joshua, I like CF_QueryBrowse from the CF Developer's Exchange. It's extremely customizable. It also provides the actual result page numbers at the bottom (1, 2, 3, 4...etc., though I could not get that to work with this tag). The only weird thing I found is that for some reason, I cannot get the Next/Previous links to move over to the right side of my page--weird! But other than that, it works great. I ended up using this tag because I absolutely HAD to be able to use 2 queries in my Next/Previous result set, and this tag allowed me to customize it to do just that. Terri Original Message Follows From: Joshua Tipton [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Subject: Next/Previous Date: Tue, 31 Jul 2001 14:09:15 -0400 Anyone have code for a good previous and next record display. I can write one but I am feeling lazy. TIA, Joshua Tipton ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Next-Previous Record Display
Hi, Checkout the following if this helps.. http://www.cfvault.com/index.cfm/mode/DisplayTutorial/TuUUID/CA3C99A0-EC34-11D3-85030050DABEAE1B/Tutorial_Page/1 Shally --- Steve Reich [EMAIL PROTECTED] wrote: Does anyone know of a good, robust tag to do the Previous 10 - Next 10 routine on displaying recordsets? I need it to output the number of pages in the return as well. There is cf_nextrecords in the tag gallery, but it is too thin for my needs. I know I've seen a couple of good one's out there, but I can never find anything when I need it. I'm hoping I won't have to write my own anyone? Thanks, Steve ~~ 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
Next-Previous Record Display
Does anyone know of a good, robust tag to do the Previous 10 - Next 10 routine on displaying recordsets? I need it to output the number of pages in the return as well. There is cf_nextrecords in the tag gallery, but it is too thin for my needs. I know I've seen a couple of good one's out there, but I can never find anything when I need it. I'm hoping I won't have to write my own anyone? Thanks, Steve ~~ 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
Re: Next-Previous Record Display
There is a great tutorial here: http://www.cfvault.com/index.cfm/mode/DisplayTutorial/TuUUID/CA3C99A0-EC34-1 1D3-85030050DABEAE1B Pablo http://www.cfm-resources.com - Original Message - From: Steve Reich [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, May 08, 2001 12:13 AM Subject: Next-Previous Record Display Does anyone know of a good, robust tag to do the Previous 10 - Next 10 routine on displaying recordsets? I need it to output the number of pages in the return as well. There is cf_nextrecords in the tag gallery, but it is too thin for my needs. I know I've seen a couple of good one's out there, but I can never find anything when I need it. I'm hoping I won't have to write my own anyone? Thanks, Steve ~~ 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
Re: Next-Previous Record Display
Try the below link. This custom tag does an excellent job and it is easy to customize. http://www.fruir.net/web/JustApp/customTags/CF_RESULTPAGES/ Gary Groomer - Original Message - From: Steve Reich [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Monday, May 07, 2001 9:13 PM Subject: Next-Previous Record Display Does anyone know of a good, robust tag to do the Previous 10 - Next 10 routine on displaying recordsets? I need it to output the number of pages in the return as well. There is cf_nextrecords in the tag gallery, but it is too thin for my needs. I know I've seen a couple of good one's out there, but I can never find anything when I need it. I'm hoping I won't have to write my own anyone? Thanks, Steve ~~ 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
next/previous with CFGRID?
Anyway to do a next / previous using CFGRID ? I know there is a MAXROWS but no STARTROWS available so Im not sure how to do it... Thanks,Adrian ~~ 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
RE: navigation of records, ie first last next previous
There's a great custom tag for this in the tag gallery - called cf_prior_next. It's at: http://devex.allaire.com/developer/gallery/info.cfm?ID=CA347445-2830-11D4-AA 9700508B94F380method=Full HTH, Evan -Original Message- From: Michael [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 13, 2001 7:03 PM To: CF-Talk Subject: navigation of records, ie first last next previous Having a problem figuring this out on record's, I would appreciate anything that anybody has on the proper way of doing the codeing for record selection, like in the subject line, first record, last record, and so on and so forth TIA Mike ~~ 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
Re: navigation of records, ie first last next previous
Thanks I will give it a try... Michael "Evan Lavidor" [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... There's a great custom tag for this in the tag gallery - called cf_prior_next. It's at: http://devex.allaire.com/developer/gallery/info.cfm?ID=CA347445-2830-11D4-AA 9700508B94F380method=Full HTH, Evan -Original Message- From: Michael [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 13, 2001 7:03 PM To: CF-Talk Subject: navigation of records, ie first last next previous Having a problem figuring this out on record's, I would appreciate anything that anybody has on the proper way of doing the codeing for record selection, like in the subject line, first record, last record, and so on and so forth TIA Mike ~~ 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
navigation of records, ie first last next previous
Having a problem figuring this out on record's, I would appreciate anything that anybody has on the proper way of doing the codeing for record selection, like in the subject line, first record, last record, and so on and so forth TIA Mike ~~ 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
Looping Next Previous Buttons
Hi: I'm building a scheduler that only shows a week at a glance (horizontally) and time slots (vertically). When a user presses the Next button, I can only get it to go to the next week and no further. Same thing with the Previous button. Here's some code snipplets. My brain is fried at the moment. Any help on this is greatly appreciated. !--- set some variables --- CFPARAM NAME="CurrentDate" DEFAULT="#now()#" CFPARAM NAME="CurrentYear" DEFAULT="#Year(CurrentDate)#" CFPARAM NAME="CurrentMonth" DEFAULT="#Month(CurrentDate)#" CFPARAM NAME="CurrentDay" DEFAULT="#Day(CurrentDate)#" CFPARAM NAME="Form.WeekChange" DEFAULT="" !--- sets the start, end and maximum number of weeks --- CFSET STARTWEEK = CURRENTDATE CFSET ENDWEEK = CURRENTDATE + 6 CFSET MAXWEEK = CREATEODBCDATE(DATEADD('WW', 4, NOW())) !--- stuff to handle the form --- (Problem Area I think) CFIF ISDEFINED("Form.WeekChange") CFIF FORM.WEEKCHANGE IS 'NEXT' CFSET STARTWEEK = ENDWEEK + 1 CFSET ENDWEEK = STARTWEEK + 6 /CFIF /CFIF !--- output --- !--- Week At A Glance --- TR CFOUTPUT CFLOOP INDEX="current_week" FROM="#startweek#" TO="#endweek#" #DateFormat(current_week, ',DD,')# /TD /CFLOOP /CFOUTPUT /TR Yvette Ingram Email: ingramrecruiting@erols or [EMAIL PROTECTED] ICQ: 21200397 ~~ 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
RE: Looping Next Previous Buttons
Blueberry muffins and cammomile tea works wonders for fried brains. *nod* Alternately fried brains and oyster sauce is an interesting combination. ^_^ -Gel www.carigamer.com -Original Message- From: Yvette Ingram [mailto:[EMAIL PROTECTED]] Hi: I'm building a scheduler that only shows a week at a glance (horizontally) and time slots (vertically). When a user presses the Next button, I can only get it to go to the next week and no further. Same thing with the Previous button. Here's some code snipplets. My brain is fried at the moment. Any help on this is greatly appreciated. ~~ 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
RE: Looping Next Previous Buttons
Might want to look into formatting all of your date variables with the CREATEODBCDATE function. I ran into a similar problem with dates. Worth a try... -Original Message- From: Yvette Ingram [mailto:[EMAIL PROTECTED]] Sent: Sunday, March 11, 2001 6:09 PM To: CF-Talk Subject: Looping Next Previous Buttons Hi: I'm building a scheduler that only shows a week at a glance (horizontally) and time slots (vertically). When a user presses the Next button, I can only get it to go to the next week and no further. Same thing with the Previous button. Here's some code snipplets. My brain is fried at the moment. Any help on this is greatly appreciated. !--- set some variables --- CFPARAM NAME="CurrentDate" DEFAULT="#now()#" CFPARAM NAME="CurrentYear" DEFAULT="#Year(CurrentDate)#" CFPARAM NAME="CurrentMonth" DEFAULT="#Month(CurrentDate)#" CFPARAM NAME="CurrentDay" DEFAULT="#Day(CurrentDate)#" CFPARAM NAME="Form.WeekChange" DEFAULT="" !--- sets the start, end and maximum number of weeks --- CFSET STARTWEEK = CURRENTDATE CFSET ENDWEEK = CURRENTDATE + 6 CFSET MAXWEEK = CREATEODBCDATE(DATEADD('WW', 4, NOW())) !--- stuff to handle the form --- (Problem Area I think) CFIF ISDEFINED("Form.WeekChange") CFIF FORM.WEEKCHANGE IS 'NEXT' CFSET STARTWEEK = ENDWEEK + 1 CFSET ENDWEEK = STARTWEEK + 6 /CFIF /CFIF !--- output --- !--- Week At A Glance --- TR CFOUTPUT CFLOOP INDEX="current_week" FROM="#startweek#" TO="#endweek#" #DateFormat(current_week, ',DD,')# /TD /CFLOOP /CFOUTPUT /TR Yvette Ingram Email: ingramrecruiting@erols or [EMAIL PROTECTED] ICQ: 21200397 ~~ 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