dragSortOrder has strange value

4 posts by 4 authors in: Forums > CMS Builder
Last Post: September 22, 2010   (RSS)

By MisterJim - September 22, 2010

I have a table called cd_tracks that has about 30 records.

There are only two custom fields in the table, 'media' and 'track'.

The search type is set to dragSortOrder.

Both fields are list type. Each reference data in another table.

For some reason, when I look at the database, I notice that the column, dragSortOrder has normal looking number: 10, 20, 30, etc. for all records where that reference one particular media number and 10-digit numbers: ex. 1285020429, 1285020439, 1285020447, etc. for all records that reference another particular media number.

This looks kind of strange, so I thought I'd report it. Any reason why this might be happening?

Jim
WebCamp One, LLC



Websites That Work

Re: [Mr Jim] dragSortOrder has strange value

By Jason - September 22, 2010

Hi Jim,

That's actually working fine. If there isn't already a value for dragSortOrder, it is assigned a value based on a time stamp, that's why the numbers are so long.

Hope this helps.
---------------------------------------------------
Jason Sauchuk - Project Manager
interactivetools.com

Hire me! Save time by getting our experts to help with your project.
http://www.interactivetools.com/consulting/

Re: [Jason] dragSortOrder has strange value

By rconring - September 22, 2010

I noticed the same thing today and was just about to post a question about stuffing the drag sort order field with my own imported values from a driver routing file that is already sequenced, but could possibly need re-sequenced for one reason or another. My sort sequence field is incremented by 10 so I assume that importing the sequence into the drag sort order field would work fine ... correct?
Ron Conring
Conring Automation Services
----------------------------------------
Software for Business and Industry Since 1987