Forum


12:20

19/07/2012

Hello,
So far jqGrid is working very well for me, but the search button isn't showing on the pager bar.
Here's my HTML:
<h1>XML test</h1><body></head></script>
}); }); rowList:[100,200,300], rowNum: 100, pager: '#pager', sortorder: 'desc', sortname: 'PID', caption: 'Samples Table', ], {name:'SAM', index:'SAM', sortable: 'true', sorttype: 'text', width:150, align:'right'}, {name:'TIME', index:'TIME', sortable: 'true', sorttype: 'int', width:150, align:'right'}, {name:'DATE', index:'DATE', sortable: 'true', sorttype: 'date', width:150, align:'right'}, {name:'COD', index:'COD', sortable: 'true', sorttype: 'int', width:150}, {name:'PID', index:'PID', sortable: 'true', sorttype: 'text', search: true, width:150}, colModel :[ colNames:['PID','COD', 'DATE','TIME','SAM'], sortname: 'PID', mtype: 'GET', datatype: 'xml', url:'/dev/cgi-bin/xml2.cgi?table=MTUB', jQuery("#list").jqGrid({jQuery(document).ready(function(){
<script type="text/javascript">
</style> body {font-size: 62.5%; } <style type="text/css">
<script src="/derm-www/jqGrid/src/grid.tbltogrid.js" type="text/javascript"></script><script src="/derm-www/jqGrid/js/jquery.jqGrid.min.js" type="text/javascript"></script><script src="/derm-www/jqGrid/js/i18n/grid.locale-en.js" type="text/javascript"></script><script src="/derm-www/jqGrid/js/jquery-1.7.2.min.js" type="text/javascript"></script>
</style> } font-size: 75%; padding: 0; margin: 20; html, body { <style>
<link rel="stylesheet" type="text/css" media="screen" href="/derm-www/jqGrid/src/css/ui.jqgrid.css" /><link rel="stylesheet" type="text/css" media="screen" href="/derm-www/jquery-ui/css/smoothness/jquery-ui-1.8.21.custom.css" />
<meta http-equiv="content-type" content="text/html; charset=utf-8″ /><title>Dermatology Diabetes HomePage</title><meta name="keywords" content="" /><meta name="description" content="" /><head><html xmlns="http://www.w3.org/1999/xhtml"><!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
Here's my server side Perl:
print "</rows>";
} print "</row>"; foreach my $r (@row){ print "<cell>$r</cell>"; } print "<row>";while(my @row = $qh->fetchrow_array()){
EOF<records>$count</records><total>$total_pages</total><page>$page</page><rows><?xml version='1.0' encoding='utf-8'?>print <<EOF;
print $query->header("Content-type: text/xml;charset=utf-8″);
$qh->execute() or die print $out $DBI::errstr;$qh = $con->prepare($sql) or die print $out $DBI::errstr;print $out $sql, "n";$sql = "SELECT PID, COD, DATE, TIME, SAM FROM TABLE ORDER BY $sidx $sord LIMIT $start , $limit";
my($start, $total_pages) = pages($count, $limit);
print $out "COUNT: $countn";
my $count = $results[0];my @results = $qh->fetchrow_array();$qh->execute() or die print $out $DBI::errstr;$qh = $con->prepare($sql) or die print $out $DBI::errstr;$sql = "SELECT COUNT(*) AS count FROM TABLE";
$con = sql_params();
my($con, $sql, $qh);
print $out "PAGE: $pagenLIMIT $limitnSIDX $sidxnSORD $sordn";my($page, $limit, $sidx, $sord) = get_defaults();
} } print $out $name."t=t".$query->param($name)."n"; else { } next; if( $name =~ /_/ ) { foreach my $name ( @names ) {
my @names = $query->param();
my $query = new CGI;
use POSIX;use JSON;use HTML::Template;use List::Uniq ':all';use DBD::mysql;use DBI;use CGI;use Data::Dumper;use CGI::Carp qw(fatalsToBrowser);
use strict;#!/usr/bin/perl
Most Users Ever Online: 715
Currently Online:
51 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.comModerators: tony: 7721, Rumen[Trirand]: 81
Administrators: admin: 66