Forum

November 2nd, 2014
A A A
Avatar
sp_LogInOut Log In

Lost password?
sp_Search Search
Advanced Search
Advanced Search

— Forum Scope —




— Match —





— Forum Options —





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

sp_Search Search
Go to Bottom
The forums are currently locked and only available for read only access
This topic is locked No permission to create posts
Page: 12Jump to page
sp_Feed Topic RSS sp_TopicIcon
TableToGrid options available?
25/11/2009
07:39
Avatar
washi
Guest
Guests
Go to Top
1sp_EditHistory sp_Permalink sp_Print

Hi!

I've generated a HTML table with PHP. Now I've figured out I can use TableToGrid.

<script type="text/javascript">
$(document).ready(function(){

tableToGrid("#table");

});
</script>

Now a plain table is generated, but I would like to use the search function, the pagination, etc..

Is that still possible and if so, how can I do it?

Thanks!

27/11/2009
04:09
Avatar
tony
Sofia, Bulgaria
Moderator
Members

Moderators
Forum Posts: 7721
Member Since:
30/10/2007
sp_UserOfflineSmall Offline
sp_UserWebsite
Go to Top
2sp_EditHistory sp_Permalink sp_Print

Hello,

If you look into the docs you will see that to this function you can pass second parameter – this parameter can contain all the available options of the grid – i.e

<script type=”text/javascript”>
$(document).ready(function(){

tableToGrid(”#table”, {width:500, pager:”#mypager”, caption:”Mycaption”});

});
</script>

Hope this help

Regards

Tony

For professional UI suites for Java Script and PHP visit us at our commercial products site - guriddo.net - by the very same guys that created jqGrid.

31/12/2009
23:43
Avatar
eljaywilson
Member
Members
Forum Posts: 22
Member Since:
09/11/2009
sp_UserOfflineSmall Offline
Go to Top
3sp_Permalink sp_Print

Tony,

Can you also control how columns are sorted?  Right now the date and currency columns are not sorting correctly.  They are sorting as text would.

03/01/2010
19:08
Avatar
tony
Sofia, Bulgaria
Moderator
Members

Moderators
Forum Posts: 7721
Member Since:
30/10/2007
sp_UserOfflineSmall Offline
sp_UserWebsite
Go to Top
4sp_Permalink sp_Print

Hello,

After you create the grid with tableToGrid function use setColProp to define the sorttypes of the coulmns.

There is no automatic determination of the content of the columns.

Best Regards

Tony

For professional UI suites for Java Script and PHP visit us at our commercial products site - guriddo.net - by the very same guys that created jqGrid.

04/01/2010
19:37
Avatar
eljaywilson
Member
Members
Forum Posts: 22
Member Since:
09/11/2009
sp_UserOfflineSmall Offline
Go to Top
5sp_Permalink sp_Print

Can you provide an example.  Here is what I have and it is not working (although what I have is just trying to disable the sort for a column).  I would need an example of how to control the sort type as well 🙂

$(".grid_table").each(function()

        {

            var myid = this.id;

           //grid.jqGrid('setColProp','Title',{sortable: false})

            $("#" + myid).jqGrid('setColProp','Cost',{sortable: false});

        });

Thanks for the help.  This is an awesome project!

LJ

06/01/2010
09:09
Avatar
tony
Sofia, Bulgaria
Moderator
Members

Moderators
Forum Posts: 7721
Member Since:
30/10/2007
sp_UserOfflineSmall Offline
sp_UserWebsite
Go to Top
6sp_Permalink sp_Print

Hello,

After calling the tableToGrid do something like this:

$(”#” + myid).jqGrid('setColProp','mycoulmname',{sorttype:'int'});

// can be numeric, date and etc. see docs

Best Regards

Tony

For professional UI suites for Java Script and PHP visit us at our commercial products site - guriddo.net - by the very same guys that created jqGrid.

06/01/2010
12:27
Avatar
eljaywilson
Member
Members
Forum Posts: 22
Member Since:
09/11/2009
sp_UserOfflineSmall Offline
Go to Top
7sp_Permalink sp_Print

Is the column name the same as the column header (<THEAD>) element?  When I try to disable sorting using the same syntax, it doesn't work.

$(”#” + myid).jqGrid('setColProp','Cost',{sortable: false});

Now, I have that firing off right after the TableToGrid is fired to create the grid.

$(”.grid_table”).each(function()

        {

            var myid = this.id;

           TableToGrid(

);

            $(”#” + myid).jqGrid('setColProp','Cost',{sortable: false});

        });

Is that supposed to work?  Right now, when I try to set the column sortable 'OFF', it doesn't work.

06/01/2010
12:38
Avatar
tony
Sofia, Bulgaria
Moderator
Members

Moderators
Forum Posts: 7721
Member Since:
30/10/2007
sp_UserOfflineSmall Offline
sp_UserWebsite
Go to Top
8sp_Permalink sp_Print

Hello,

The name of the column is constructed as:

If the th element has id the name becomes the id, if this is not true the name is the html content of the th element.

You can see what names you have simple using getGridParam with colModel and print the names.

Best Regards

Tony

For professional UI suites for Java Script and PHP visit us at our commercial products site - guriddo.net - by the very same guys that created jqGrid.

06/01/2010
17:10
Avatar
eljaywilson
Member
Members
Forum Posts: 22
Member Since:
09/11/2009
sp_UserOfflineSmall Offline
Go to Top
9sp_Permalink sp_Print

Thanks!  Putting in an ID on the TH elements solved the setColProp method.  Now, the only issue is the date field I have.  The date & time are coming in formatted like so:

9/2/2009 11:30:45 AM

When I try to set the sorttype  to date, I get an "Undefined" message on the grid.

$("#" + myid).jqGrid('setColProp', 'Created', { sorttype: 'date' });

Is there something else I need to do so that jqGrid interprets the date field properly?  

Thanks so much for all the support, this is a wonderful tool.

07/01/2010
20:27
Avatar
tony
Sofia, Bulgaria
Moderator
Members

Moderators
Forum Posts: 7721
Member Since:
30/10/2007
sp_UserOfflineSmall Offline
sp_UserWebsite
Go to Top
10sp_Permalink sp_Print

Hello,

Look at datefmt option in the docs

Regards

Tony

For professional UI suites for Java Script and PHP visit us at our commercial products site - guriddo.net - by the very same guys that created jqGrid.

07/01/2010
20:48
Avatar
eljaywilson
Member
Members
Forum Posts: 22
Member Since:
09/11/2009
sp_UserOfflineSmall Offline
Go to Top
11sp_Permalink sp_Print

Thanks for the help.  I did try that (I actually tried that earlier, but didn't see a date/time format for the way my data is presented (Date & Time).

Here is my code:

$("#" + myid).jqGrid('setColProp', 'Created', { sorttype: 'date', datefmt: 'm/d/yyyy' });

Here is a partial screenshot of what I get when I try to sort that field:

Error MessageImage Enlarger

Any ideas?

18/01/2010
22:28
Avatar
eljaywilson
Member
Members
Forum Posts: 22
Member Since:
09/11/2009
sp_UserOfflineSmall Offline
Go to Top
12sp_Permalink sp_Print

I have tried setting the date to a normal date value like '1/9/2010' and I still get the "undefined" error message.  Any ideas?

19/01/2010
11:44
Avatar
tony
Sofia, Bulgaria
Moderator
Members

Moderators
Forum Posts: 7721
Member Since:
30/10/2007
sp_UserOfflineSmall Offline
sp_UserWebsite
Go to Top
13sp_Permalink sp_Print

Hello,

The date format is a PHP like

try this

$(”#” + myid).jqGrid('setColProp', 'Created', { sorttype: 'date', datefmt: 'm/d/Y' });

Regards

Tony

For professional UI suites for Java Script and PHP visit us at our commercial products site - guriddo.net - by the very same guys that created jqGrid.

19/01/2010
15:28
Avatar
eljaywilson
Member
Members
Forum Posts: 22
Member Since:
09/11/2009
sp_UserOfflineSmall Offline
Go to Top
14sp_Permalink sp_Print

Still getting the same error message (undefined).  If my date/time format is:

 1/7/2010 1:04:18 PM

shouldn't it still work or will I have to change the datefmt string to include the time.  Also what might help me to troubleshoot this further is a non-minified version of jquery.jqGrid.min.js  

Thanks for the help, I am just not understanding how to deal with a column that has date and time in it.  Also remember that I am using tabletogrid for this.

Thanks again,

LJ Wilson

22/01/2010
13:06
Avatar
tony
Sofia, Bulgaria
Moderator
Members

Moderators
Forum Posts: 7721
Member Since:
30/10/2007
sp_UserOfflineSmall Offline
sp_UserWebsite
Go to Top
15sp_Permalink sp_Print

Hello,

Could you please post or send me the code - the table data and the way you cal  the function?

Thank you.

Best Regards

For professional UI suites for Java Script and PHP visit us at our commercial products site - guriddo.net - by the very same guys that created jqGrid.

25/01/2010
15:48
Avatar
eljaywilson
Member
Members
Forum Posts: 22
Member Since:
09/11/2009
sp_UserOfflineSmall Offline
Go to Top
16sp_Permalink sp_Print

Here is how I call the function (each table has the "grid_table" classname)

$(document).ready(

function(){

$(

".grid_table").each(function()

{

var myid = this.id;

var mycaption = getGridCaption(myid);

tableToGrid(

"#" + myid, { height: "auto", caption: mycaption });

$(

"#" + myid).jqGrid('setColProp', 'Created', { sortable: false });

$(

"#" + myid).jqGrid('setColProp', 'Function Date', { sortable: false });

$(

"#" + myid).jqGrid('setColProp', 'Cost', { sorttype: 'currency' });

//$("#" + myid).jqGrid('setColProp', 'Created', { datefmt: 'm/d/Y', sorttype: "date" });

//$("#" + myid).jqGrid('setColProp', 'Created', { sorttype: 'date'});

});

});

Here is some of the table data (Raw):

<h2>&nbsp;<u>Open Non Stock Requisitions</u></h2><table border='0' cellpadding='2' width='100%' cellspacing='3'>
<TR>
<TD align=left class='line' height='25' valign='center'><span class=colheader>ereq</span></TD>
<TD align=left class='line' height='25' valign='center'><span class=colheader>Creator</span></TD>
<TD align=left class='line' height='25' valign='center'><span class=colheader>Requestor</span></TD>
<TD align=left class='line' height='25' valign='center'><span class=colheader>Cost</span></TD>



<TD align=left class='line' height='25' valign='center'><span class=colheader>Created</span></TD>
<TD align=left class='line' height='25' valign='center'><span class=colheader>Status</span></TD>
<TD align=left class='line' height='25' valign='center'><span class=colheader>Vendor</span></TD>
</TR><TR><form action='ViewRequest.asp' method='POST' name='ViewRequest'><input type='hidden' name='strRequestType' value='PO'>
<TD align=left class='line2'><font size='2'><input type='submit' name='ereq' value=1769718></font></TD>
<TD align=left class='line2'><font size='2' color='#000000'>Justin  Mobley</font></TD>
<TD align=left class='line2'><font size='2' color='#000000'>Justin Mobley</font></TD>
<TD align=left class='line2'><font size='2' color='#000000'>$4,074.00</font></TD>
<TD align=left class='line2'><font size='2' color='#000000'>1/22/2010 1:30:07 PM</font></TD>
<TD align=left class='line2'><font size='2' color='#000000'>Submitted</font></TD>



<TD align=left class='line2'><font size='2' color='#000000'>US Appliance</font></TD>
</form></TR>
<TR><form action='ViewRequest.asp' method='POST' name='ViewRequest'><input type='hidden' name='strRequestType' value='PO'>
<TD align=left class='line2b'><font size='2'><input type='submit' name='ereq' value=1759759></font></TD>
<TD align=left class='line2b'><font size='2' color='#000000'>Larry  Wilson</font></TD>
<TD align=left class='line2b'><font size='2' color='#000000'>LJ Wilson</font></TD>
<TD align=left class='line2b'><font size='2' color='#000000'>$8.00</font></TD>
<TD align=left class='line2b'><font size='2' color='#000000'>1/7/2010 1:04:18 PM</font></TD>
<TD align=left class='line2b'><font size='2' color='#000000'>Created</font></TD>
<TD align=left class='line2b'><font size='2' color='#000000'></font></TD>
</form></TR>



<TR><form action='ViewRequest.asp' method='POST' name='ViewRequest'><input type='hidden' name='strRequestType' value='PO'>
<TD align=left class='line2'><font size='2'><input type='submit' name='ereq' value=1759755></font></TD>
<TD align=left class='line2'><font size='2' color='#000000'>Larry  Wilson</font></TD>
<TD align=left class='line2'><font size='2' color='#000000'>LJ Wilson</font></TD>
<TD align=left class='line2'><font size='2' color='#000000'>$8.00</font></TD>
<TD align=left class='line2'><font size='2' color='#000000'>1/7/2010 1:02:35 PM</font></TD>
<TD align=left class='line2'><font size='2' color='#000000'>Created</font></TD>
<TD align=left class='line2'><font size='2' color='#000000'></font></TD>
</form></TR>
<TR><form action='ViewRequest.asp' method='POST' name='ViewRequest'><input type='hidden' name='strRequestType' value='PO'>
<TD align=left class='line2b'><font size='2'><input type='submit' name='ereq' value=1759624></font></TD>
<TD align=left class='line2b'><font size='2' color='#000000'>Larry  Wilson</font></TD>



<TD align=left class='line2b'><font size='2' color='#000000'>LJ Wilson</font></TD>
<TD align=left class='line2b'><font size='2' color='#000000'>$8.00</font></TD>
<TD align=left class='line2b'><font size='2' color='#000000'>1/7/2010 11:25:23 AM</font></TD>
<TD align=left class='line2b'><font size='2' color='#000000'>Created</font></TD>
<TD align=left class='line2b'><font size='2' color='#000000'></font></TD>
</form></TR>
<TR><form action='ViewRequest.asp' method='POST' name='ViewRequest'><input type='hidden' name='strRequestType' value='PO'>
<TD align=left class='line2'><font size='2'><input type='submit' name='ereq' value=1759620></font></TD>
<TD align=left class='line2'><font size='2' color='#000000'>Larry  Wilson</font></TD>
<TD align=left class='line2'><font size='2' color='#000000'>LJ Wilson</font></TD>
<TD align=left class='line2'><font size='2' color='#000000'>$82.00</font></TD>



<TD align=left class='line2'><font size='2' color='#000000'>1/7/2010 11:22:39 AM</font></TD>
<TD align=left class='line2'><font size='2' color='#000000'>Created</font></TD>
<TD align=left class='line2'><font size='2' color='#000000'></font></TD>
</form></TR>
<TR><form action='ViewRequest.asp' method='POST' name='ViewRequest'><input type='hidden' name='strRequestType' value='PO'>
<TD align=left class='line2b'><font size='2'><input type='submit' name='ereq' value=1759617></font></TD>
<TD align=left class='line2b'><font size='2' color='#000000'>Larry  Wilson</font></TD>
<TD align=left class='line2b'><font size='2' color='#000000'>LJ Wilson</font></TD>
<TD align=left class='line2b'><font size='2' color='#000000'>$8.00</font></TD>
<TD align=left class='line2b'><font size='2' color='#000000'>1/7/2010 11:20:53 AM</font></TD>
<TD align=left class='line2b'><font size='2' color='#000000'>Created</font></TD>



<TD align=left class='line2b'><font size='2' color='#000000'></font></TD>
</form></TR>
<TR><form action='ViewRequest.asp' method='POST' name='ViewRequest'><input type='hidden' name='strRequestType' value='PO'>
<TD align=left class='line2'><font size='2'><input type='submit' name='ereq' value=1743914></font></TD>
<TD align=left class='line2'><font size='2' color='#000000'>Larry  Wilson</font></TD>
<TD align=left class='line2'><font size='2' color='#000000'>LJ Wilson</font></TD>
<TD align=left class='line2'><font size='2' color='#000000'>$0.01</font></TD>
<TD align=left class='line2'><font size='2' color='#000000'>12/10/2009 1:36:27 PM</font></TD>
<TD align=left class='line2'><font size='2' color='#000000'>Created</font></TD>
<TD align=left class='line2'><font size='2' color='#000000'></font></TD>
</form></TR>
<TR><form action='ViewRequest.asp' method='POST' name='ViewRequest'><input type='hidden' name='strRequestType' value='PO'>



<TD align=left class='line2b'><font size='2'><input type='submit' name='ereq' value=1743263></font></TD>
<TD align=left class='line2b'><font size='2' color='#000000'>RENEE COFFMAN</font></TD>
<TD align=left class='line2b'><font size='2' color='#000000'>renee coffan</font></TD>
<TD align=left class='line2b'><font size='2' color='#000000'>$0.00</font></TD>
<TD align=left class='line2b'><font size='2' color='#000000'>12/9/2009 3:03:49 PM</font></TD>
<TD align=left class='line2b'><font size='2' color='#000000'>Created</font></TD>
<TD align=left class='line2b'><font size='2' color='#000000'></font></TD>
</form></TR>
<TR><form action='ViewRequest.asp' method='POST' name='ViewRequest'><input type='hidden' name='strRequestType' value='PO'>
<TD align=left class='line2'><font size='2'><input type='submit' name='ereq' value=1743034></font></TD>
<TD align=left class='line2'><font size='2' color='#000000'>Larry  Wilson</font></TD>



<TD align=left class='line2'><font size='2' color='#000000'>LJ Wilson</font></TD>
<TD align=left class='line2'><font size='2' color='#000000'>$0.01</font></TD>
<TD align=left class='line2'><font size='2' color='#000000'>12/9/2009 11:55:25 AM</font></TD>
<TD align=left class='line2'><font size='2' color='#000000'>Created</font></TD>
<TD align=left class='line2'><font size='2' color='#000000'></font></TD>
</form></TR>
<TR><form action='ViewRequest.asp' method='POST' name='ViewRequest'><input type='hidden' name='strRequestType' value='PO'>
<TD align=left class='line2b'><font size='2'><input type='submit' name='ereq' value=1742906></font></TD>
<TD align=left class='line2b'><font size='2' color='#000000'>Larry  Wilson</font></TD>
<TD align=left class='line2b'><font size='2' color='#000000'>LJ Wilson</font></TD>
<TD align=left class='line2b'><font size='2' color='#000000'>$0.01</font></TD>



<TD align=left class='line2b'><font size='2' color='#000000'>12/9/2009 9:46:10 AM</font></TD>
<TD align=left class='line2b'><font size='2' color='#000000'>Created</font></TD>
<TD align=left class='line2b'><font size='2' color='#000000'></font></TD>
</form></TR>
<TR><form action='ViewRequest.asp' method='POST' name='ViewRequest'><input type='hidden' name='strRequestType' value='PO'>
<TD align=left class='line2'><font size='2'><input type='submit' name='ereq' value=1742450></font></TD>
<TD align=left class='line2'><font size='2' color='#000000'>RENEE COFFMAN</font></TD>
<TD align=left class='line2'><font size='2' color='#000000'>renee coffan</font></TD>
<TD align=left class='line2'><font size='2' color='#000000'>$0.00</font></TD>
<TD align=left class='line2'><font size='2' color='#000000'>12/8/2009 2:33:56 PM</font></TD>
<TD align=left class='line2'><font size='2' color='#000000'>Created</font></TD>



<TD align=left class='line2'><font size='2' color='#000000'></font></TD>
</form></TR>
<TR><form action='ViewRequest.asp' method='POST' name='ViewRequest'><input type='hidden' name='strRequestType' value='PO'>
<TD align=left class='line2b'><font size='2'><input type='submit' name='ereq' value=1742444></font></TD>
<TD align=left class='line2b'><font size='2' color='#000000'>RENEE COFFMAN</font></TD>
<TD align=left class='line2b'><font size='2' color='#000000'>renee coffan</font></TD>
<TD align=left class='line2b'><font size='2' color='#000000'>$0.00</font></TD>
<TD align=left class='line2b'><font size='2' color='#000000'>12/8/2009 2:29:35 PM</font></TD>
<TD align=left class='line2b'><font size='2' color='#000000'>Created</font></TD>
<TD align=left class='line2b'><font size='2' color='#000000'></font></TD>
</form></TR>
<TR><form action='ViewRequest.asp' method='POST' name='ViewRequest'><input type='hidden' name='strRequestType' value='PO'>



<TD align=left class='line2'><font size='2'><input type='submit' name='ereq' value=1681097></font></TD>
<TD align=left class='line2'><font size='2' color='#000000'>RENEE COFFMAN</font></TD>
<TD align=left class='line2'><font size='2' color='#000000'>Renee Coffman</font></TD>
<TD align=left class='line2'><font size='2' color='#000000'>$0.00</font></TD>
<TD align=left class='line2'><font size='2' color='#000000'>9/2/2009 11:30:45 AM</font></TD>
<TD align=left class='line2'><font size='2' color='#000000'>Created</font></TD>
<TD align=left class='line2'><font size='2' color='#000000'></font></TD>
</form></TR>
<TR><form action='ViewRequest.asp' method='POST' name='ViewRequest'><input type='hidden' name='strRequestType' value='PO'>
<TD align=left class='line2b'><font size='2'><input type='submit' name='ereq' value=1662825></font></TD>
<TD align=left class='line2b'><font size='2' color='#000000'>RENEE COFFMAN</font></TD>



<TD align=left class='line2b'><font size='2' color='#000000'>Renee Coffman</font></TD>
<TD align=left class='line2b'><font size='2' color='#000000'>$3,500.00</font></TD>
<TD align=left class='line2b'><font size='2' color='#000000'>8/5/2009 9:51:15 AM</font></TD>
<TD align=left class='line2b'><font size='2' color='#000000'>Created</font></TD>
<TD align=left class='line2b'><font size='2' color='#000000'></font></TD>
</form></TR>
<TR><form action='ViewRequest.asp' method='POST' name='ViewRequest'><input type='hidden' name='strRequestType' value='PO'>
<TD align=left class='line2'><font size='2'><input type='submit' name='ereq' value=1658293></font></TD>
<TD align=left class='line2'><font size='2' color='#000000'>RENEE COFFMAN</font></TD>
<TD align=left class='line2'><font size='2' color='#000000'>Renee Coffman</font></TD>
<TD align=left class='line2'><font size='2' color='#000000'>$0.00</font></TD>



<TD align=left class='line2'><font size='2' color='#000000'>7/28/2009 4:35:10 PM</font></TD>
<TD align=left class='line2'><font size='2' color='#000000'>Created</font></TD>
<TD align=left class='line2'><font size='2' color='#000000'></font></TD>
</form></TR>
<TR><form action='ViewRequest.asp' method='POST' name='ViewRequest'><input type='hidden' name='strRequestType' value='PO'>
<TD align=left class='line2b'><font size='2'><input type='submit' name='ereq' value=1602129></font></TD>
<TD align=left class='line2b'><font size='2' color='#000000'>David Higginson</font></TD>
<TD align=left class='line2b'><font size='2' color='#000000'>dfg dfg</font></TD>
<TD align=left class='line2b'><font size='2' color='#000000'>$0.00</font></TD>
<TD align=left class='line2b'><font size='2' color='#000000'>5/4/2009 12:50:57 PM</font></TD>
<TD align=left class='line2b'><font size='2' color='#000000'>Created</font></TD>



<TD align=left class='line2b'><font size='2' color='#000000'></font></TD>
</form></TR>
</TABLE>






 At the end of the file that generates the table html I have this css code:




<style>


.ui-jqgrid tr.jqgrow td {white-space: normal}


</style>




 Thanks for all your help !




LJ



 
27/01/2010
19:38
Avatar
tony
Sofia, Bulgaria
Moderator
Members

Moderators
Forum Posts: 7721
Member Since:
30/10/2007
sp_UserOfflineSmall Offline
sp_UserWebsite
Go to Top
17sp_Permalink sp_Print

Hello,

Just tested your example.

Little errors in the data provided here - the table must have a TH element in order to work this properly.

I changed the first row from TD to TH  and the example works.

The problem that apper here is that your TH content have anoter html tag in your case SPAN element. This is the reason that the colModel is not build properly - i.e the names appear as SPAN elements.

Just now I have fixed this problem in the GitHub and your example work ok.

Best Regards

Tony

For professional UI suites for Java Script and PHP visit us at our commercial products site - guriddo.net - by the very same guys that created jqGrid.

27/01/2010
19:45
Avatar
eljaywilson
Member
Members
Forum Posts: 22
Member Since:
09/11/2009
sp_UserOfflineSmall Offline
Go to Top
18sp_Permalink sp_Print

Tony,

Thanks!!!  So to correct this, do I need to download a new version of the plugin or attempt to fix the TD elements or both?

Thanks so much for your help!!!

LJ Wilson

27/01/2010
20:22
Avatar
tony
Sofia, Bulgaria
Moderator
Members

Moderators
Forum Posts: 7721
Member Since:
30/10/2007
sp_UserOfflineSmall Offline
sp_UserWebsite
Go to Top
19sp_EditHistory sp_Permalink sp_Print

Hello,

Your table should begin like this:


<table border='0' cellpadding='2' width='100%' cellspacing='3' id="mytable" class="grid_table">
<TR>
<TH align=left class='line' height='25' valign='center'><span class=colheader>ereq</span></TD>
<TH align=left class='line' height='25' valign='center'><span class=colheader>Creator</span></TD>
<TH align=left class='line' height='25' valign='center'><span class=colheader>Requestor</span></TD>
<TH align=left class='line' height='25' valign='center'><span class=colheader>Cost</span></TD>

<TH align=left class='line' height='25' valign='center'><span class=colheader>Created</span></TD>
<TH align=left class='line' height='25' valign='center'><span class=colheader>Status</span></TD>
<TH align=left class='line' height='25' valign='center'><span class=colheader>Vendor</span></TD>
</TR>
...

To test download the code from GitHub and install the development variant.
http://www.trirand.com/jqgridw.....stallation

I hope to publish 3.6.3 release at end of week.

Best Regards
Tony

For professional UI suites for Java Script and PHP visit us at our commercial products site - guriddo.net - by the very same guys that created jqGrid.

27/01/2010
21:36
Avatar
eljaywilson
Member
Members
Forum Posts: 22
Member Since:
09/11/2009
sp_UserOfflineSmall Offline
Go to Top
20sp_Permalink sp_Print

I took out the SPAN elements from the headers.  Here raw HTML that I have now:

<table id='PO_ViewOpen' class='grid_table' border='0' cellpadding='2' width='100%' cellspacing='3'><thead>
<TR>
<TH id='ereq' align='left' valign='center'>ereq</TH><TH id='Creator' align='left' valign='center'>Creator</TH><TH id='Requestor' align='left' valign='center'>Requestor</TH><TH id='Cost' align='left' valign='center'>Cost</TH><TH id='Created' align='left' valign='center'>Created</TH><TH id='Status' align='left' valign='center'>Status</TH><TH id='Vendor' align='left' valign='center'>Vendor</TH></TR></thead><tbody><TR height='20px'><TD align='center' width='80px'><font size='2'><input type='button' id= 'PO|' style='width:75px;' name='btnereq' value='1769718' onclick='submitme(this);'></font></TD><TD align=left ><font size='2' color='#000000'>&nbsp;Justin  Mobley</font></TD><TD align=left ><font size='2' color='#000000'>&nbsp;Justin Mobley</font></TD><TD align=left ><font size='2' color='#000000'>&nbsp;$4,074.00</font></TD><TD align=left ><font size='2' color='#000000'>&nbsp;1/22/2010 1:30:07 PM</font></TD><TD align=left ><font size='2' color='#000000'>&nbsp;Assigned</font></TD><TD align=left ><font size='2' color='#000000'>&nbsp;US Appliance</font></TD></TR>



<tbody><TR height='20px'><TD align='center' width='80px'><font size='2'><input type='button' id= 'PO|' style='width:75px;' name='btnereq' value='1759759' onclick='submitme(this);'></font></TD><TD align=left ><font size='2' color='#000000'>&nbsp;Larry  Wilson</font></TD><TD align=left ><font size='2' color='#000000'>&nbsp;LJ Wilson</font></TD><TD align=left ><font size='2' color='#000000'>&nbsp;$8.00</font></TD><TD align=left ><font size='2' color='#000000'>&nbsp;1/7/2010 1:04:18 PM</font></TD><TD align=left ><font size='2' color='#000000'>&nbsp;Created</font></TD><TD align=left ><font size='2' color='#000000'>&nbsp;</font></TD></TR>
<tbody><TR height='20px'><TD align='center' width='80px'><font size='2'><input type='button' id= 'PO|' style='width:75px;' name='btnereq' value='1759755' onclick='submitme(this);'></font></TD><TD align=left ><font size='2' color='#000000'>&nbsp;Larry  Wilson</font></TD><TD align=left ><font size='2' color='#000000'>&nbsp;LJ Wilson</font></TD><TD align=left ><font size='2' color='#000000'>&nbsp;$8.00</font></TD><TD align=left ><font size='2' color='#000000'>&nbsp;1/7/2010 1:02:35 PM</font></TD><TD align=left ><font size='2' color='#000000'>&nbsp;Created</font></TD><TD align=left ><font size='2' color='#000000'>&nbsp;</font></TD></TR>
<tbody><TR height='20px'><TD align='center' width='80px'><font size='2'><input type='button' id= 'PO|' style='width:75px;' name='btnereq' value='1759624' onclick='submitme(this);'></font></TD><TD align=left ><font size='2' color='#000000'>&nbsp;Larry  Wilson</font></TD><TD align=left ><font size='2' color='#000000'>&nbsp;LJ Wilson</font></TD><TD align=left ><font size='2' color='#000000'>&nbsp;$8.00</font></TD><TD align=left ><font size='2' color='#000000'>&nbsp;1/7/2010 11:25:23 AM</font></TD><TD align=left ><font size='2' color='#000000'>&nbsp;Created</font></TD><TD align=left ><font size='2' color='#000000'>&nbsp;</font></TD></TR>



<tbody><TR height='20px'><TD align='center' width='80px'><font size='2'><input type='button' id= 'PO|' style='width:75px;' name='btnereq' value='1759620' onclick='submitme(this);'></font></TD><TD align=left ><font size='2' color='#000000'>&nbsp;Larry  Wilson</font></TD><TD align=left ><font size='2' color='#000000'>&nbsp;LJ Wilson</font></TD><TD align=left ><font size='2' color='#000000'>&nbsp;$82.00</font></TD><TD align=left ><font size='2' color='#000000'>&nbsp;1/7/2010 11:22:39 AM</font></TD><TD align=left ><font size='2' color='#000000'>&nbsp;Created</font></TD><TD align=left ><font size='2' color='#000000'>&nbsp;</font></TD></TR>
<tbody><TR height='20px'><TD align='center' width='80px'><font size='2'><input type='button' id= 'PO|' style='width:75px;' name='btnereq' value='1759617' onclick='submitme(this);'></font></TD><TD align=left ><font size='2' color='#000000'>&nbsp;Larry  Wilson</font></TD><TD align=left ><font size='2' color='#000000'>&nbsp;LJ Wilson</font></TD><TD align=left ><font size='2' color='#000000'>&nbsp;$8.00</font></TD><TD align=left ><font size='2' color='#000000'>&nbsp;1/7/2010 11:20:53 AM</font></TD><TD align=left ><font size='2' color='#000000'>&nbsp;Created</font></TD><TD align=left ><font size='2' color='#000000'>&nbsp;</font></TD></TR>
<tbody><TR height='20px'><TD align='center' width='80px'><font size='2'><input type='button' id= 'PO|' style='width:75px;' name='btnereq' value='1743914' onclick='submitme(this);'></font></TD><TD align=left ><font size='2' color='#000000'>&nbsp;Larry  Wilson</font></TD><TD align=left ><font size='2' color='#000000'>&nbsp;LJ Wilson</font></TD><TD align=left ><font size='2' color='#000000'>&nbsp;$0.01</font></TD><TD align=left ><font size='2' color='#000000'>&nbsp;12/10/2009 1:36:27 PM</font></TD><TD align=left ><font size='2' color='#000000'>&nbsp;Created</font></TD><TD align=left ><font size='2' color='#000000'>&nbsp;</font></TD></TR>



<tbody><TR height='20px'><TD align='center' width='80px'><font size='2'><input type='button' id= 'PO|' style='width:75px;' name='btnereq' value='1743263' onclick='submitme(this);'></font></TD><TD align=left ><font size='2' color='#000000'>&nbsp;RENEE COFFMAN</font></TD><TD align=left ><font size='2' color='#000000'>&nbsp;renee coffan</font></TD><TD align=left ><font size='2' color='#000000'>&nbsp;$0.00</font></TD><TD align=left ><font size='2' color='#000000'>&nbsp;12/9/2009 3:03:49 PM</font></TD><TD align=left ><font size='2' color='#000000'>&nbsp;Created</font></TD><TD align=left ><font size='2' color='#000000'>&nbsp;</font></TD></TR>
<tbody><TR height='20px'><TD align='center' width='80px'><font size='2'><input type='button' id= 'PO|' style='width:75px;' name='btnereq' value='1743034' onclick='submitme(this);'></font></TD><TD align=left ><font size='2' color='#000000'>&nbsp;Larry  Wilson</font></TD><TD align=left ><font size='2' color='#000000'>&nbsp;LJ Wilson</font></TD><TD align=left ><font size='2' color='#000000'>&nbsp;$0.01</font></TD><TD align=left ><font size='2' color='#000000'>&nbsp;12/9/2009 11:55:25 AM</font></TD><TD align=left ><font size='2' color='#000000'>&nbsp;Created</font></TD><TD align=left ><font size='2' color='#000000'>&nbsp;</font></TD></TR>
<tbody><TR height='20px'><TD align='center' width='80px'><font size='2'><input type='button' id= 'PO|' style='width:75px;' name='btnereq' value='1742906' onclick='submitme(this);'></font></TD><TD align=left ><font size='2' color='#000000'>&nbsp;Larry  Wilson</font></TD><TD align=left ><font size='2' color='#000000'>&nbsp;LJ Wilson</font></TD><TD align=left ><font size='2' color='#000000'>&nbsp;$0.01</font></TD><TD align=left ><font size='2' color='#000000'>&nbsp;12/9/2009 9:46:10 AM</font></TD><TD align=left ><font size='2' color='#000000'>&nbsp;Created</font></TD><TD align=left ><font size='2' color='#000000'>&nbsp;</font></TD></TR>



<tbody><TR height='20px'><TD align='center' width='80px'><font size='2'><input type='button' id= 'PO|' style='width:75px;' name='btnereq' value='1742450' onclick='submitme(this);'></font></TD><TD align=left ><font size='2' color='#000000'>&nbsp;RENEE COFFMAN</font></TD><TD align=left ><font size='2' color='#000000'>&nbsp;renee coffan</font></TD><TD align=left ><font size='2' color='#000000'>&nbsp;$0.00</font></TD><TD align=left ><font size='2' color='#000000'>&nbsp;12/8/2009 2:33:56 PM</font></TD><TD align=left ><font size='2' color='#000000'>&nbsp;Created</font></TD><TD align=left ><font size='2' color='#000000'>&nbsp;</font></TD></TR>
<tbody><TR height='20px'><TD align='center' width='80px'><font size='2'><input type='button' id= 'PO|' style='width:75px;' name='btnereq' value='1742444' onclick='submitme(this);'></font></TD><TD align=left ><font size='2' color='#000000'>&nbsp;RENEE COFFMAN</font></TD><TD align=left ><font size='2' color='#000000'>&nbsp;renee coffan</font></TD><TD align=left ><font size='2' color='#000000'>&nbsp;$0.00</font></TD><TD align=left ><font size='2' color='#000000'>&nbsp;12/8/2009 2:29:35 PM</font></TD><TD align=left ><font size='2' color='#000000'>&nbsp;Created</font></TD><TD align=left ><font size='2' color='#000000'>&nbsp;</font></TD></TR>
<tbody><TR height='20px'><TD align='center' width='80px'><font size='2'><input type='button' id= 'PO|' style='width:75px;' name='btnereq' value='1681097' onclick='submitme(this);'></font></TD><TD align=left ><font size='2' color='#000000'>&nbsp;RENEE COFFMAN</font></TD><TD align=left ><font size='2' color='#000000'>&nbsp;Renee Coffman</font></TD><TD align=left ><font size='2' color='#000000'>&nbsp;$0.00</font></TD><TD align=left ><font size='2' color='#000000'>&nbsp;9/2/2009 11:30:45 AM</font></TD><TD align=left ><font size='2' color='#000000'>&nbsp;Created</font></TD><TD align=left ><font size='2' color='#000000'>&nbsp;</font></TD></TR>



<tbody><TR height='20px'><TD align='center' width='80px'><font size='2'><input type='button' id= 'PO|' style='width:75px;' name='btnereq' value='1662825' onclick='submitme(this);'></font></TD><TD align=left ><font size='2' color='#000000'>&nbsp;RENEE COFFMAN</font></TD><TD align=left ><font size='2' color='#000000'>&nbsp;Renee Coffman</font></TD><TD align=left ><font size='2' color='#000000'>&nbsp;$3,500.00</font></TD><TD align=left ><font size='2' color='#000000'>&nbsp;8/5/2009 9:51:15 AM</font></TD><TD align=left ><font size='2' color='#000000'>&nbsp;Created</font></TD><TD align=left ><font size='2' color='#000000'>&nbsp;</font></TD></TR>
<tbody><TR height='20px'><TD align='center' width='80px'><font size='2'><input type='button' id= 'PO|' style='width:75px;' name='btnereq' value='1658293' onclick='submitme(this);'></font></TD><TD align=left ><font size='2' color='#000000'>&nbsp;RENEE COFFMAN</font></TD><TD align=left ><font size='2' color='#000000'>&nbsp;Renee Coffman</font></TD><TD align=left ><font size='2' color='#000000'>&nbsp;$0.00</font></TD><TD align=left ><font size='2' color='#000000'>&nbsp;7/28/2009 4:35:10 PM</font></TD><TD align=left ><font size='2' color='#000000'>&nbsp;Created</font></TD><TD align=left ><font size='2' color='#000000'>&nbsp;</font></TD></TR>
<tbody><TR height='20px'><TD align='center' width='80px'><font size='2'><input type='button' id= 'PO|' style='width:75px;' name='btnereq' value='1602129' onclick='submitme(this);'></font></TD><TD align=left ><font size='2' color='#000000'>&nbsp;David Higginson</font></TD><TD align=left ><font size='2' color='#000000'>&nbsp;dfg dfg</font></TD><TD align=left ><font size='2' color='#000000'>&nbsp;$0.00</font></TD><TD align=left ><font size='2' color='#000000'>&nbsp;5/4/2009 12:50:57 PM</font></TD><TD align=left ><font size='2' color='#000000'>&nbsp;Created</font></TD><TD align=left ><font size='2' color='#000000'>&nbsp;</font></TD></TR>



</tbody></TABLE>




So even without the SPAN elements and with using TH, I still get the undefined error message.
LJ
This topic is locked No permission to create posts
Page: 12Jump to page
sp_Feed All RSS
Go to top
Forum Timezone: Europe/Sofia

Most Users Ever Online: 715

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