Forum

November 2nd, 2014
A A A
Avatar

Lost password?
Advanced Search

— Forum Scope —




— Match —





— Forum Options —





Minimum search word length is 3 characters - maximum search word length is 84 characters

The forums are currently locked and only available for read only access
sp_Feed Topic RSS sp_Related Related Topics sp_TopicIcon
Local Data: Rows disappear when users sort
23/07/2010
00:06
Avatar
cjm19682
Member
Members
Forum Posts: 9
Member Since:
28/03/2010
sp_UserOfflineSmall Offline

 I have just upgraded from 3.6.4 to 3.7.2 and noticed that when I now sort rows many of the rows simply disappear. This is shown in the example code below. There are 27 data rows. When the user sorts on either column, only 20 rows are displayed. In 3.6.4 this worked OK. I am creating local jqGrids using tableToGrid. Does anyone have any ideas? I can't revert to 3.6.4 coz I want to use a jqGrid feature not available in that version.

Here is the code:

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/html4/strict.dtd">

<html>

<head>

<title>Table Testbed</title>

<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">

<link rel="stylesheet" type="text/css" href="http://ajax.googleapis.com/ajax/libs/jqueryui/1.8/themes/south-street/jquery-ui.css">

<script type="text/javascript" src="http://ajax.googleapis.com/ajax/libs/jquery/1.4.2/jquery.min.js"></script>

<script type="text/javascript" src="http://ajax.googleapis.com/ajax/libs/jqueryui/1.8/jquery-ui.min.js"></script>

<link rel="stylesheet" type="text/css" href="/thirdParty/jqGrid/ui.jqgrid.css" >

<script type="text/javascript" src="/thirdParty/jqGrid/grid.locale-en.js"></script>

<script type="text/javascript" src="/thirdParty/jqGrid/jquery.jqGrid.min.js"></script>

<style type="text/css">

body {font-size: 62.5%; }

</style>

<script type="text/javascript">

$().ready(function()

{

tableToGrid("#playerTable",

{

datatype: "local",

sortable: true,

hidegrid: false,

multiselect: false,

altRows: true,

height: "100%", 

width: "155px",

shrinkToFit: true,

colNames: ['Posn','Name'],

colModel: [

{name:'Posn', index:'Posn', width:100, sorttype:"text"},

{name:'Name', index:'Name', width:200, sorttype:"text"}

]

});

});

</script>

</head>

<body>

<table id="playerTable"> 

<thead> 

<tr><th>Posn</th><th>Name</th></tr> 

</thead> 

<tbody> 

<tr><td>GK</td><td>Almunia</td></tr> 

<tr><td>GK</td><td>Fabianski</td></tr> 

<tr><td>GK</td><td>Mannone</td></tr> 

<tr><td>DEF</td><td>Campbell</td></tr> 

<tr><td>DEF</td><td>Clichy</td></tr> 

<tr><td>DEF</td><td>Djourou</td></tr> 

<tr><td>DEF</td><td>Gallas</td></tr> 

<tr><td>DEF</td><td>Gibbs</td></tr> 

<tr><td>DEF</td><td>Sagna</td></tr> 

<tr><td>DEF</td><td>Silvestre</td></tr> 

<tr><td>DEF</td><td>Traore</td></tr> 

<tr><td>DEF</td><td>Vermaelen</td></tr> 

<tr><td>MID</td><td>Denilson</td></tr> 

<tr><td>MID</td><td>Diaby</td></tr> 

<tr><td>MID</td><td>Eboue</td></tr> 

<tr><td>MID</td><td>Fabregas</td></tr> 

<tr><td>MID</td><td>Merida</td></tr> 

<tr><td>MID</td><td>Nasri</td></tr> 

<tr><td>MID</td><td>Ramsey</td></tr> 

<tr><td>MID</td><td>Rosicky</td></tr> 

<tr><td>MID</td><td>Song</td></tr> 

<tr><td>STR</td><td>Arshavin</td></tr> 

<tr><td>STR</td><td>Bendtner</td></tr> 

<tr><td>STR</td><td>Eduardo</td></tr> 

<tr><td>STR</td><td>van Persie</td></tr> 

<tr><td>STR</td><td>Vela</td></tr> 

<tr><td>STR</td><td>Walcott</td></tr> 

</tbody> 

</table> 

</body>

</html>

24/07/2010
11:57
Avatar
cjm19682
Member
Members
Forum Posts: 9
Member Since:
28/03/2010
sp_UserOfflineSmall Offline

I got this to work by adding a

rowNum: 100

into the colModel. This wasn't required in 3.6.4, but seems to be needed in 3.7.2 even though I'm not using a pager.

Forum Timezone: Europe/Sofia

Most Users Ever Online: 715

Currently Online:
33 Guest(s)

Currently Browsing this Page:
1 Guest(s)

Top Posters:

OlegK: 1255

markw65: 179

kobruleht: 144

phicarre: 132

YamilBracho: 124

Renso: 118

Member Stats:

Guest Posters: 447

Members: 11373

Moderators: 2

Admins: 1

Forum Stats:

Groups: 1

Forums: 8

Topics: 10592

Posts: 31289

Newest Members:

, razia, Prankie, psky, praveen neelam, greg.valainis@pa-tech.com

Moderators: tony: 7721, Rumen[Trirand]: 81

Administrators: admin: 66

Comments are closed.
Privacy Policy   Terms and Conditions   Contact Information