For your second problem: your next-n is working on individual records, not groups, so it works as intended. Show first three (3 ben), then next three (1 ben, 2 john). You will have to find an alternative to make the next-n work on accounts. You could make 2 queries instead of one. A query to get accounts (use that for your next-n interface) and one to get customers.
Pascal
> -----Original Message-----
> From: Ben Densmore [mailto:[EMAIL PROTECTED]
> Sent: woensdag 26 mei 2004 3:35
> To: CF-Talk
> Subject: Weird problem with Next X records
>
> I have an application that I am using Next and Previous
> records links to sort through data.
>
> The I'm using the group attribute in the <cfoutput> tag to
> group by the customerID. My page will look like:
>
> Ben's Accounts
> CustomerID1
> CustomerID2
> CustomerID3
> CustomerID4
>
> Johns Accounts
> CustomerID1
> CustomerID2
>
> This will output a maximum of 3 accounts per page but with
> any number of customerID's. The odd thing is if there are say
> 4 accounts, when I click the next link to diaplay the 4th
> record it duplicated the first 3 records to me and if I click
> next again I then get the 4th record.
>
> One other strange thing is say in my example Ben's Accounts
> is the first record displayed and it has 4 customerIDs, when
> I click the next link and it show's me the duplicate of Ben's
> accounts on the next page it only has the 4th customerID.
>
> Has anyone run into something like this before? I'm thinking
> the group attribute might be causing this but I'm not sure.
>
> Thanks,
> Ben
>
> **************************************************************
> ******************************************************
> �
> This e-mail and any files transmitted with it are
> confidential and intended solely for the use of the
> individual or entity to which they are addressed.�If you have
> received this e-mail in error please notify the system manager.
> �
> This e-mail message has been swept for the presence of
> computer viruses.
> �
> WARNING: All e-mail sent to this address will be received by
> the HMC network and is subject to archival and review by
> someone other than the recipient.
>
> **************************************************************
> ******************************************************
> �
>
>
>
>
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
