Hi Ed...
I'm no expert but here's what I'm doing for the URL,
url: '../controller/function1'
Here's a more complete example...I know there a several places where
more web2py-esqe helpers or style would help but this is how I first
mocked up jqGrid.
myview.html
==========
{{extend 'layout.html'}}
{{include 'jqgrid_refs.html'}} <!--this has the references for the
jqGrid files-->
<!--This is the jqgrid definition.-->
<script type="text/javascript">
jQuery(document).ready(function(){
jQuery("#grid").jqGrid({ <!--this is the id used to position the
grid in the html below-->
imgpath: '/{{=request.application}}/static/themes/coffee/images',
<!-- sets the theme used for the grid-->
caption: 'My Grid', <!-- text to display in the header-->
url: '../controller/function1', <!-- this is an asyncronous call
to get the data for the grid-->
datatype: 'xml', <!--the grid expects xml formatted data (see
jqGrid docs for the default xml document structure)-->
mtype: 'GET',
height: '100%',
colNames: ['col1','col2', 'col3'],
colModel :[
{name:'col1', index:'col1', width:55, sorttype:'text},
{name:'col1', index:'col1', width:55, sorttype:'text},
{name:'col1', index:'col1', width:55, sorttype:'text}
],
sortname: 'col1', <!--default sort column-->
sortorder: 'asc', <!--default sort direction-->
pager: jQuery('#pager'), <!--this is the id used to position the
pager controls in the html view-->
rowNum:20, <!--default number of rows to display-->
rowList:[20,40,60,80,100], <!--dropdown choices to select the
number of rows to display-->
viewrecords: true, <!--displays the total number of rows in the
entire set in the pager bar-->
});
</script>
<!--page headings-->
<h2>This is your jqGrid...</h2>
<!--add the grid and pager-->
<table id="grid" class="scroll"></table>
<div id="pager" class="scroll" style="text-align:center;"></div>
jqgrid_refs.html
============
<link rel="stylesheet" type="text/css" media="screen" href="/
{{=request.application}}/static/themes/coffee/grid.css" />
<link rel="stylesheet" type="text/css" media="screen" href="/
{{=request.application}}/static/themes/jqModal.css" />
<script src="/{{=request.application}}/static/jquery.js" type="text/
javascript"></script>
<script src="/{{=request.application}}/static/jquery.jqGrid.js"
type="text/javascript"></script>
<script src="/{{=request.application}}/static/js/jqModal.js"
type="text/javascript"></script>
<script src="/{{=request.application}}/static/js/jqDnR.js" type="text/
javascript"></script>
Controller
========
def myview():
return dict()
def function1():
response.headers["Content-Type"]="text/xml"
#start the XML data set
mystr = "<?xml version='1.0' encoding='utf-8'?><rows><page>1</
page><total>1</total><records>10</records>"
#get the data from the database
records = db.executesql("SELECT TOP 10 col1, col2, col3 FROM
tbl1") #MS SQL Server
#build XML from dataset
for row in records:
mystr = mystr + "<row id ='" +str(row.col1) + "'>"
mystr = mystr + '<cell>' + str(row.col1) + '</cell>'
mystr = mystr + '<cell>' + str(row.col2) + '</cell>'
mystr = mystr + '<cell>' + str(row.col3) + '</cell>'
mystr = mystr + '</row>'
mystr = mystr +'</rows>'
return mystr
Hope that helps.
Mike
On Mar 24, 9:41 pm, ed <edbi...@rocketmail.com> wrote:
> Hi Mike,
> I am a web2py newbie and has to learn much from experts like you.
> I would like to know which of the following url format you are using
> to access your xml data in your server:
>
> 1. url: "{{=URL(r=request,c='default',f='getjsdata')}}",
> 2. url: '/EMIS/controllers/getjsdata.py',
>
> Is it 1 or 2? Is it possible if you can email a source code of an
> application
> using web2py and jqGrid, I understand you are using jqGrid. I am also
> very
> interested to use jqGrid in web2py but not much documentation. I think
> you
> can provide the much needed example on this for everyone interested
> in
> this technology. Thanks in advance.
> Ed
>
> On 24 Mar, 01:36, Mike <michael.mcgreg...@gmail.com> wrote:
>
>
>
> > Hey Ed,
>
> > We're using jqGrid with XML data. Something thoughts (if you haven't
> > tried them already):
>
> > 1.) Try your grid with the FireBug plugin for FireFox and look at the
> > response being returned to the grid. I've had web2py tickets thown at
> > that point and the only to see it is via Firebug. Or just check for
> > tickets from the admin app
>
> > 2.) Did you set the response headers? in my case I had to
> > use...response.headers["Content-Type"]="text/xml"
>
> > 3.) What does your controller look like? In my controller that serves
> > up the XML I just return a string with the XML data "return xml"
> > instead of "return dict(xml = xml)"
>
> > Hope that helps. I like jqGrid since it has excellent documentation
> > and hope more of us can make it work with web2py.
>
> > Mike
>
> > On Mar 23, 5:27 am, ed <edbi...@rocketmail.com> wrote:
>
> > > Hi,
> > > I've been trying to execute a jquery jqGrid url to return JSON data
> > > but failed. Only a blank table with exact headings is displayed. I
> > > tried changing the url several times but no data is displayed. The
> > > following is part of the code.
> > > ------------------------------------------------------------------------------------------------------
>
> > > <script src="{{=URL(r=request,c='static',f='jqGrid34/jquery.js')}}"
> > > type="text/javascript"></script>
> > > <!-- and at end the jqGrid Java Script file -->
> > > <script src="{{=URL(r=request,c='static',f='jqGrid34/
> > > jquery.jqGrid.js')}}" type="text/javascript"></script>
> > > <script type="text/javascript">
> > > jQuery(document).ready(function(){
> > > jQuery('#list2').jqGrid({
> > > //
> > > // this is the url I am using but failed to display data
>
> > > url: "{{=URL(r=request,c='default',f='getjsdata')}}",
>
> > > // I created a program in controllers to return json data and
> > > tried the url below to access the program but also failed to display
> > > data
> > > url: '/EMIS/controllers/getjsdata.py',
> > > //
> > > datatype: 'json',
> > > colNames:['Emp. No.','Last Name', 'First Name', 'Mid Name', 'Cost
> > > Center', 'SSS No.'],
> > > colModel:[
> > > {name:'empno',index:'empno', width:80},
> > > {name:'lname',index:'lname', width:160},
> > > ------------------------------------------------------------------------
> > > Maybe the url address format is wrong or whatever. Can someone help me
> > > on this.
> > > Thank you very much.
> > > Ed- Hide quoted text -
>
> - Show quoted text -
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"web2py Web Framework" group.
To post to this group, send email to web2py@googlegroups.com
To unsubscribe from this group, send email to
web2py+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/web2py?hl=en
-~----------~----~----~----~------~----~------~--~---
