jQuery Grid Plugin - jqGrid

Hi Tony,

Yes i am using sorttype: 'int'

Maybe my post was too long winded...simply put....

If you have a column that in MySQL is defined as varchar(10) and it holds some data say 5 records  1,2,10,2000,300. Then sorting this as text (its natural datatype varchar) you get 1,10,2,2000,300 which is correct.

But without changing the datatype in the MySQL table, i want to sort it has if it was an integer, resulting in: 1,2,10,300,2000 which i thought i could do by setting sorttype: 'int' on the column. I tried that but I still get 1,10,2,2000,300 (as if it was still text).

As i mentioned it's like casting text data to integer data (presuming the text data is valid and contains 0-9 characters)

Regards

MarkC

My colModel is fine, {name:'col1', index:'index1', align:'right', sorttype:'int', sortable:true, width:80}

Simply...what is sorttype? maybe it's not what i thought it was, as in take any data and sort it like it was an integer?

The reason i get a sorted column like

1
10
2
2000
300

is that the SQL has already sorted the data based on it's datatype (VARCHAR) This is then parsed into the XML cells. EWhixh is then displayed in the grid. I thought the sorttype might do something with teh xml ordering, by saying now define it as an integer even though it is a varchar. Basically, sort a VARCHAR as if it was an integer to get 1,2,10,300,2000, hence my first question why use sorttype if it has already been sorted as a varcgar,data,integer,float by the SQL:

strSQL = "SELECT DOCID,INDEX1,INDEX2 FROM DOCUMENTS " &strWhere
strSQL = strSQL & " ORDER BY "&strIdx&" "&strOrd&" LIMIT "&strStart&" , "&strLimit&" "

and parsed into XML in that order.

Regards

MarkC

I can do it at SQL level:

strSQL = "SELECT DOCID,CAST(INDEX1 AS SIGNED) as index1,INDEX2 FROM DOCUMENTS " &strWhere
strSQL = strSQL & " ORDER BY "&strIdx&" "&strOrd&" LIMIT "&strStart&" , "&strLimit&" "

this takes VARCHAR(20) INDEX1 and casts it into an signed integer, so when ordering it will be corectly sorted like an integer.

Works fine. BUt i thought the grid would do it using sorttype!!!

Thanks Tony,

I will have a look.

I am using scrolling not paging as we are talkng about 200,000 records and i am allowing the user to auto incremtn search on keypressing. (like your bigset.php demo)

But i'll have a look into the local setting.

regards

MarkC