Works like
I took out the SPAN elements from the headers.
Tony,
Thanks!!!
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):
|
1 2 3 4 5 6 7 |
<div class="sfcode"><pre id="line176"><h2> <u>Open Non Stock Requisitions</u></h2><table border="'0'" cellpadding="'2'" width="'100%'" cellspacing="'3'"><br /> <tr><br /> <td align="left" class="'line'" height="'25'" valign="'center'"><span class="colheader">ereq</span></td><br /> <td align="left" class="'line'" height="'25'" valign="'center'"><span class="colheader">Creator</span></td><br /> <td align="left" class="'line'" height="'25'" valign="'center'"><span class="colheader">Requestor</span></td><br /> <td align="left" class="'line'" height="'25'" valign="'center'"><span class="colheader">Cost</span></td><br /> </tr></table> |
|
1 2 3 4 5 6 7 8 9 10 11 |
<td align="left" class="'line'" height="'25'" valign="'center'"><span class="colheader">Created</span></td><br /> <td align="left" class="'line'" height="'25'" valign="'center'"><span class="colheader">Status</span></td><br /> <td align="left" class="'line'" height="'25'" valign="'center'"><span class="colheader">Vendor</span></td><br /> <tr><form action="'ViewRequest.asp'" method="'POST'" name="'ViewRequest'"><br /> <td align="left" class="'line2'"><font size="'2'"></font></td><br /> <td align="left" class="'line2'"><font size="'2'" color="'#000000'">Justin Mobley</font></td><br /> <td align="left" class="'line2'"><font size="'2'" color="'#000000'">Justin Mobley</font></td><br /> <td align="left" class="'line2'"><font size="'2'" color="'#000000'">$4,074.00</font></td><br /> <td align="left" class="'line2'"><font size="'2'" color="'#000000'">1/22/2010 1:30:07 PM</font></td><br /> <td align="left" class="'line2'"><font size="'2'" color="'#000000'">Submitted</font></td><br /> </form></tr> |
|
1 2 3 4 5 6 7 8 9 10 11 |
<td align="left" class="'line2'"><font size="'2'" color="'#000000'">US Appliance</font></td><br /> <br /> <tr><form action="'ViewRequest.asp'" method="'POST'" name="'ViewRequest'"><br /> <td align="left" class="'line2b'"><font size="'2'"></font></td><br /> <td align="left" class="'line2b'"><font size="'2'" color="'#000000'">Larry Wilson</font></td><br /> <td align="left" class="'line2b'"><font size="'2'" color="'#000000'">LJ Wilson</font></td><br /> <td align="left" class="'line2b'"><font size="'2'" color="'#000000'">$8.00</font></td><br /> <td align="left" class="'line2b'"><font size="'2'" color="'#000000'">1/7/2010 1:04:18 PM</font></td><br /> <td align="left" class="'line2b'"><font size="'2'" color="'#000000'">Created</font></td><br /> <td align="left" class="'line2b'"><font size="'2'" color="'#000000'"></font></td><br /> </form></tr><br /> |
|
1 2 3 4 5 6 7 8 9 10 11 12 13 |
<tr><form action="'ViewRequest.asp'" method="'POST'" name="'ViewRequest'"><br /> <td align="left" class="'line2'"><font size="'2'"></font></td><br /> <td align="left" class="'line2'"><font size="'2'" color="'#000000'">Larry Wilson</font></td><br /> <td align="left" class="'line2'"><font size="'2'" color="'#000000'">LJ Wilson</font></td><br /> <td align="left" class="'line2'"><font size="'2'" color="'#000000'">$8.00</font></td><br /> <td align="left" class="'line2'"><font size="'2'" color="'#000000'">1/7/2010 1:02:35 PM</font></td><br /> <td align="left" class="'line2'"><font size="'2'" color="'#000000'">Created</font></td><br /> <td align="left" class="'line2'"><font size="'2'" color="'#000000'"></font></td><br /> </form></tr><br /> <tr><form action="'ViewRequest.asp'" method="'POST'" name="'ViewRequest'"><br /> <td align="left" class="'line2b'"><font size="'2'"></font></td><br /> <td align="left" class="'line2b'"><font size="'2'" color="'#000000'">Larry Wilson</font></td><br /> </form></tr> |
|
1 2 3 4 5 6 7 8 9 10 11 12 |
<td align="left" class="'line2b'"><font size="'2'" color="'#000000'">LJ Wilson</font></td><br /> <td align="left" class="'line2b'"><font size="'2'" color="'#000000'">$8.00</font></td><br /> <td align="left" class="'line2b'"><font size="'2'" color="'#000000'">1/7/2010 11:25:23 AM</font></td><br /> <td align="left" class="'line2b'"><font size="'2'" color="'#000000'">Created</font></td><br /> <td align="left" class="'line2b'"><font size="'2'" color="'#000000'"></font></td><br /> <br /> <tr><form action="'ViewRequest.asp'" method="'POST'" name="'ViewRequest'"><br /> <td align="left" class="'line2'"><font size="'2'"></font></td><br /> <td align="left" class="'line2'"><font size="'2'" color="'#000000'">Larry Wilson</font></td><br /> <td align="left" class="'line2'"><font size="'2'" color="'#000000'">LJ Wilson</font></td><br /> <td align="left" class="'line2'"><font size="'2'" color="'#000000'">$82.00</font></td><br /> </form></tr> |
|
1 2 3 4 5 6 7 8 9 10 11 12 |
<td align="left" class="'line2'"><font size="'2'" color="'#000000'">1/7/2010 11:22:39 AM</font></td><br /> <td align="left" class="'line2'"><font size="'2'" color="'#000000'">Created</font></td><br /> <td align="left" class="'line2'"><font size="'2'" color="'#000000'"></font></td><br /> <br /> <tr><form action="'ViewRequest.asp'" method="'POST'" name="'ViewRequest'"><br /> <td align="left" class="'line2b'"><font size="'2'"></font></td><br /> <td align="left" class="'line2b'"><font size="'2'" color="'#000000'">Larry Wilson</font></td><br /> <td align="left" class="'line2b'"><font size="'2'" color="'#000000'">LJ Wilson</font></td><br /> <td align="left" class="'line2b'"><font size="'2'" color="'#000000'">$8.00</font></td><br /> <td align="left" class="'line2b'"><font size="'2'" color="'#000000'">1/7/2010 11:20:53 AM</font></td><br /> <td align="left" class="'line2b'"><font size="'2'" color="'#000000'">Created</font></td><br /> </form></tr> |
|
1 2 3 4 5 6 7 8 9 10 11 12 13 |
<td align="left" class="'line2b'"><font size="'2'" color="'#000000'"></font></td><br /> <br /> <tr><form action="'ViewRequest.asp'" method="'POST'" name="'ViewRequest'"><br /> <td align="left" class="'line2'"><font size="'2'"></font></td><br /> <td align="left" class="'line2'"><font size="'2'" color="'#000000'">Larry Wilson</font></td><br /> <td align="left" class="'line2'"><font size="'2'" color="'#000000'">LJ Wilson</font></td><br /> <td align="left" class="'line2'"><font size="'2'" color="'#000000'">$0.01</font></td><br /> <td align="left" class="'line2'"><font size="'2'" color="'#000000'">12/10/2009 1:36:27 PM</font></td><br /> <td align="left" class="'line2'"><font size="'2'" color="'#000000'">Created</font></td><br /> <td align="left" class="'line2'"><font size="'2'" color="'#000000'"></font></td><br /> </form></tr><br /> <tr><form action="'ViewRequest.asp'" method="'POST'" name="'ViewRequest'"><br /> </form></tr> |
|
1 2 3 4 5 6 7 8 9 10 11 12 |
<td align="left" class="'line2b'"><font size="'2'"></font></td><br /> <td align="left" class="'line2b'"><font size="'2'" color="'#000000'">RENEE COFFMAN</font></td><br /> <td align="left" class="'line2b'"><font size="'2'" color="'#000000'">renee coffan</font></td><br /> <td align="left" class="'line2b'"><font size="'2'" color="'#000000'">$0.00</font></td><br /> <td align="left" class="'line2b'"><font size="'2'" color="'#000000'">12/9/2009 3:03:49 PM</font></td><br /> <td align="left" class="'line2b'"><font size="'2'" color="'#000000'">Created</font></td><br /> <td align="left" class="'line2b'"><font size="'2'" color="'#000000'"></font></td><br /> <br /> <tr><form action="'ViewRequest.asp'" method="'POST'" name="'ViewRequest'"><br /> <td align="left" class="'line2'"><font size="'2'"></font></td><br /> <td align="left" class="'line2'"><font size="'2'" color="'#000000'">Larry Wilson</font></td><br /> </form></tr> |
|
1 2 3 4 5 6 7 8 9 10 11 12 |
<td align="left" class="'line2'"><font size="'2'" color="'#000000'">LJ Wilson</font></td><br /> <td align="left" class="'line2'"><font size="'2'" color="'#000000'">$0.01</font></td><br /> <td align="left" class="'line2'"><font size="'2'" color="'#000000'">12/9/2009 11:55:25 AM</font></td><br /> <td align="left" class="'line2'"><font size="'2'" color="'#000000'">Created</font></td><br /> <td align="left" class="'line2'"><font size="'2'" color="'#000000'"></font></td><br /> <br /> <tr><form action="'ViewRequest.asp'" method="'POST'" name="'ViewRequest'"><br /> <td align="left" class="'line2b'"><font size="'2'"></font></td><br /> <td align="left" class="'line2b'"><font size="'2'" color="'#000000'">Larry Wilson</font></td><br /> <td align="left" class="'line2b'"><font size="'2'" color="'#000000'">LJ Wilson</font></td><br /> <td align="left" class="'line2b'"><font size="'2'" color="'#000000'">$0.01</font></td><br /> </form></tr> |
|
1 2 3 4 5 6 7 8 9 10 11 12 |
<td align="left" class="'line2b'"><font size="'2'" color="'#000000'">12/9/2009 9:46:10 AM</font></td><br /> <td align="left" class="'line2b'"><font size="'2'" color="'#000000'">Created</font></td><br /> <td align="left" class="'line2b'"><font size="'2'" color="'#000000'"></font></td><br /> <br /> <tr><form action="'ViewRequest.asp'" method="'POST'" name="'ViewRequest'"><br /> <td align="left" class="'line2'"><font size="'2'"></font></td><br /> <td align="left" class="'line2'"><font size="'2'" color="'#000000'">RENEE COFFMAN</font></td><br /> <td align="left" class="'line2'"><font size="'2'" color="'#000000'">renee coffan</font></td><br /> <td align="left" class="'line2'"><font size="'2'" color="'#000000'">$0.00</font></td><br /> <td align="left" class="'line2'"><font size="'2'" color="'#000000'">12/8/2009 2:33:56 PM</font></td><br /> <td align="left" class="'line2'"><font size="'2'" color="'#000000'">Created</font></td><br /> </form></tr> |
|
1 2 3 4 5 6 7 8 9 10 11 12 13 |
<td align="left" class="'line2'"><font size="'2'" color="'#000000'"></font></td><br /> <br /> <tr><form action="'ViewRequest.asp'" method="'POST'" name="'ViewRequest'"><br /> <td align="left" class="'line2b'"><font size="'2'"></font></td><br /> <td align="left" class="'line2b'"><font size="'2'" color="'#000000'">RENEE COFFMAN</font></td><br /> <td align="left" class="'line2b'"><font size="'2'" color="'#000000'">renee coffan</font></td><br /> <td align="left" class="'line2b'"><font size="'2'" color="'#000000'">$0.00</font></td><br /> <td align="left" class="'line2b'"><font size="'2'" color="'#000000'">12/8/2009 2:29:35 PM</font></td><br /> <td align="left" class="'line2b'"><font size="'2'" color="'#000000'">Created</font></td><br /> <td align="left" class="'line2b'"><font size="'2'" color="'#000000'"></font></td><br /> </form></tr><br /> <tr><form action="'ViewRequest.asp'" method="'POST'" name="'ViewRequest'"><br /> </form></tr> |
|
1 2 3 4 5 6 7 8 9 10 11 12 |
<td align="left" class="'line2'"><font size="'2'"></font></td><br /> <td align="left" class="'line2'"><font size="'2'" color="'#000000'">RENEE COFFMAN</font></td><br /> <td align="left" class="'line2'"><font size="'2'" color="'#000000'">Renee Coffman</font></td><br /> <td align="left" class="'line2'"><font size="'2'" color="'#000000'">$0.00</font></td><br /> <td align="left" class="'line2'"><font size="'2'" color="'#000000'">9/2/2009 11:30:45 AM</font></td><br /> <td align="left" class="'line2'"><font size="'2'" color="'#000000'">Created</font></td><br /> <td align="left" class="'line2'"><font size="'2'" color="'#000000'"></font></td><br /> <br /> <tr><form action="'ViewRequest.asp'" method="'POST'" name="'ViewRequest'"><br /> <td align="left" class="'line2b'"><font size="'2'"></font></td><br /> <td align="left" class="'line2b'"><font size="'2'" color="'#000000'">RENEE COFFMAN</font></td><br /> </form></tr> |
|
1 2 3 4 5 6 7 8 9 10 11 12 |
<td align="left" class="'line2b'"><font size="'2'" color="'#000000'">Renee Coffman</font></td><br /> <td align="left" class="'line2b'"><font size="'2'" color="'#000000'">$3,500.00</font></td><br /> <td align="left" class="'line2b'"><font size="'2'" color="'#000000'">8/5/2009 9:51:15 AM</font></td><br /> <td align="left" class="'line2b'"><font size="'2'" color="'#000000'">Created</font></td><br /> <td align="left" class="'line2b'"><font size="'2'" color="'#000000'"></font></td><br /> <br /> <tr><form action="'ViewRequest.asp'" method="'POST'" name="'ViewRequest'"><br /> <td align="left" class="'line2'"><font size="'2'"></font></td><br /> <td align="left" class="'line2'"><font size="'2'" color="'#000000'">RENEE COFFMAN</font></td><br /> <td align="left" class="'line2'"><font size="'2'" color="'#000000'">Renee Coffman</font></td><br /> <td align="left" class="'line2'"><font size="'2'" color="'#000000'">$0.00</font></td><br /> </form></tr> |
|
1 2 3 4 5 6 7 8 9 10 11 12 |
<td align="left" class="'line2'"><font size="'2'" color="'#000000'">7/28/2009 4:35:10 PM</font></td><br /> <td align="left" class="'line2'"><font size="'2'" color="'#000000'">Created</font></td><br /> <td align="left" class="'line2'"><font size="'2'" color="'#000000'"></font></td><br /> <br /> <tr><form action="'ViewRequest.asp'" method="'POST'" name="'ViewRequest'"><br /> <td align="left" class="'line2b'"><font size="'2'"></font></td><br /> <td align="left" class="'line2b'"><font size="'2'" color="'#000000'">David Higginson</font></td><br /> <td align="left" class="'line2b'"><font size="'2'" color="'#000000'">dfg dfg</font></td><br /> <td align="left" class="'line2b'"><font size="'2'" color="'#000000'">$0.00</font></td><br /> <td align="left" class="'line2b'"><font size="'2'" color="'#000000'">5/4/2009 12:50:57 PM</font></td><br /> <td align="left" class="'line2b'"><font size="'2'" color="'#000000'">Created</font></td><br /> </form></tr> |
|
1 2 |
<td align="left" class="'line2b'"><font size="'2'" color="'#000000'"></font></td><br /> <br /> |
Still getting the same error message (undefined).
I have tried setting the date to a normal date value like '1/9/2010' and I still get the “undefined” error message.
Thanks for the help.
Thanks!
Is the column name the same as the column header (
) element?Can you provide an example.
Tony,
Can you also control how columns are sorted?
Correction, in IE the form submission works fine, but when I include the form inside the cell (
Got that part figured out.
Correction – when I inspect the submit button (with the tabletogrid conversion), I do not see the form tag.
Also – a great tool for debugging request vars (and lots of other stuff) is the Firebug plugin for Firefox.
Copyright 2014 TriRand LtdAll Rights ReservedRSS
Back to Top