On 24-Mar-10, at 12:49 PM, Matthew Woodward wrote:

On Wed, Mar 24, 2010 at 12:46 PM, Jason Allen <[email protected]> wrote:
Example, if the max position found is 11, but there are only 5
records, then it's obvious things aren't ordered correctly.


Well that doesn't necessarily mean things aren't ordered correctly, it just means you don't have the same number of photos as the max position.

I think you'll have to explain more what you're trying to accomplish, how you're getting the data, and how you're working with it. Short code samples are very helpful. I'm just having trouble visualizing how you get the data and ultimately what you're trying to do with it.

--
Matthew Woodward


True, the actual sort order would result in the same ordering if queried. I was imagining he wanted to have an ordering that went from 1 to the total number of photos.

If it is only for display purposes, then its not technically necessary to renumber the sort order in this way, because when looping over the query to render it, you can use #CurrentRow#...which will always display from 1 to the number of photos.

(This is assuming you don't actually have to drive other processes off that sort order value.)

Allen


[email protected]
http://blog.mattwoodward.com
identi.ca/Twitter: @mpwoodward

Please do not send me proprietary file formats such as Word, PowerPoint, etc. as attachments.
http://www.gnu.org/philosophy/no-word-attachments.html

--
Open BlueDragon Public Mailing List
http://www.openbluedragon.org/ http://twitter.com/OpenBlueDragon
mailing list - http://groups.google.com/group/openbd?hl=en

!! save a network - please trim replies before posting !!

To unsubscribe from this group, send email to openbd +unsubscribegooglegroups.com or reply to this email with the words "REMOVE ME" as the subject.

--
Open BlueDragon Public Mailing List
http://www.openbluedragon.org/   http://twitter.com/OpenBlueDragon
mailing list - http://groups.google.com/group/openbd?hl=en

!! save a network - please trim replies before posting !!

To unsubscribe from this group, send email to openbd+unsubscribegooglegroups.com or reply 
to this email with the words "REMOVE ME" as the subject.

Reply via email to