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_TopicIcon
rowNum: -1 display all records in the grid
15/11/2010
11:29
Avatar
amalia
Member
Members
Forum Posts: 3
Member Since:
15/11/2010
sp_UserOfflineSmall Offline

Hello,

I have noticed that rowNum documentation description has changed: " Set this parameter to -1 (unlimited) to disable this checking." Is there a replacement for this functionality?

A solution will be to set the rowNum as a big number, but it is not very "elegant".

Please let me know what would be the right solution to view all records in the grid?

Thank you,

Amalia

15/11/2010
16:31
Avatar
OlegK
Germany
Member
Members
Forum Posts: 1255
Member Since:
10/08/2009
sp_UserOfflineSmall Offline

Hello Amalia,

the usage of rowNum:-1 depend not only from the jqGrid but also from the server part which you use. The usage of negative numbers could follow to errors on the server side. The usage of "SELECT TOP(-1) ..." are wrong for example. If your server works fine with the value -1 for the rowNum you can continue to use it. Nevertheless the usage of rowNum:10000 seems me absolutely OK. If because of some reasons servers results will be less then 10000 rows they will be not send and displayed at once in a grid.

Regards
Oleg 

Forum Timezone: Europe/Sofia

Most Users Ever Online: 715

Currently Online:
48 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