jQuery Grid Plugin - jqGrid - Topic: TableToGrid options available? http://www.trirand.com/blog/?page_id=393/help/tabletogrid-options-available Simple:Press Version 5.7.5.3 chiragvels on TableToGrid options available? http://www.trirand.com/blog/?page_id=393/help/tabletogrid-options-available/page-2#p19336 Help http://www.trirand.com/blog/?page_id=393/help/tabletogrid-options-available/page-2#p19336 Hello Tony,

I am using above example perfectly .But after page is loaded and when i am try to sort data then all data is not coming only first 20 data is loaded why?

Thanks,

]]> Thu, 26 Aug 2010 16:07:04 +0300 eljaywilson on TableToGrid options available? http://www.trirand.com/blog/?page_id=393/help/tabletogrid-options-available/page-2#p14382 Help http://www.trirand.com/blog/?page_id=393/help/tabletogrid-options-available/page-2#p14382 Works like a champ!!!

Thanks so much for all your patience and help 😀

LJ Wilson

]]> Thu, 28 Jan 2010 21:34:55 +0200 tony on TableToGrid options available? http://www.trirand.com/blog/?page_id=393/help/tabletogrid-options-available/page-2#p14367 Help http://www.trirand.com/blog/?page_id=393/help/tabletogrid-options-available/page-2#p14367 Hello,

Here is your example:

http://trirand.com/blog/jqgrid.....ilson.html

and here is the code

http://trirand.com/blog/jqgrid.....wilson.txt

Note how some things are loaded into the head section

Best Regards

Tony

]]> Thu, 28 Jan 2010 18:12:06 +0200 eljaywilson on TableToGrid options available? http://www.trirand.com/blog/?page_id=393/help/tabletogrid-options-available#p14324 Help http://www.trirand.com/blog/?page_id=393/help/tabletogrid-options-available#p14324 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

]]>
        	        	Wed, 27 Jan 2010 21:36:48 +0200
        
        
        	tony on TableToGrid options available?
        	http://www.trirand.com/blog/?page_id=393/help/tabletogrid-options-available#p14322
        	Help
        	http://www.trirand.com/blog/?page_id=393/help/tabletogrid-options-available#p14322
        	        	

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

]]>
        	        	Wed, 27 Jan 2010 20:22:42 +0200
        
        
        	eljaywilson on TableToGrid options available?
        	http://www.trirand.com/blog/?page_id=393/help/tabletogrid-options-available#p14320
        	Help
        	http://www.trirand.com/blog/?page_id=393/help/tabletogrid-options-available#p14320
        	        	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

]]>
        	        	Wed, 27 Jan 2010 19:45:13 +0200
        
        
        	tony on TableToGrid options available?
        	http://www.trirand.com/blog/?page_id=393/help/tabletogrid-options-available#p14318
        	Help
        	http://www.trirand.com/blog/?page_id=393/help/tabletogrid-options-available#p14318
        	        	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

]]>
        	        	Wed, 27 Jan 2010 19:38:27 +0200
        
        
        	eljaywilson on TableToGrid options available?
        	http://www.trirand.com/blog/?page_id=393/help/tabletogrid-options-available#p14244
        	Help
        	http://www.trirand.com/blog/?page_id=393/help/tabletogrid-options-available#p14244
        	        	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



 

]]>
        	        	Mon, 25 Jan 2010 15:48:23 +0200
        
        
        	tony on TableToGrid options available?
        	http://www.trirand.com/blog/?page_id=393/help/tabletogrid-options-available#p14151
        	Help
        	http://www.trirand.com/blog/?page_id=393/help/tabletogrid-options-available#p14151
        	        	Hello,


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


Thank you.


Best Regards

]]>
        	        	Fri, 22 Jan 2010 13:06:48 +0200
        
        
        	eljaywilson on TableToGrid options available?
        	http://www.trirand.com/blog/?page_id=393/help/tabletogrid-options-available#p14052
        	Help
        	http://www.trirand.com/blog/?page_id=393/help/tabletogrid-options-available#p14052
        	        	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

]]>
        	        	Tue, 19 Jan 2010 15:28:34 +0200
        
        
        	tony on TableToGrid options available?
        	http://www.trirand.com/blog/?page_id=393/help/tabletogrid-options-available#p14042
        	Help
        	http://www.trirand.com/blog/?page_id=393/help/tabletogrid-options-available#p14042
        	        	Hello,


The date format is a PHP like


try this






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




Regards


Tony

]]>
        	        	Tue, 19 Jan 2010 11:44:32 +0200
        
        
        	eljaywilson on TableToGrid options available?
        	http://www.trirand.com/blog/?page_id=393/help/tabletogrid-options-available#p14008
        	Help
        	http://www.trirand.com/blog/?page_id=393/help/tabletogrid-options-available#p14008
        	        	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?

]]>
        	        	Mon, 18 Jan 2010 22:28:51 +0200
        
        
        	eljaywilson on TableToGrid options available?
        	http://www.trirand.com/blog/?page_id=393/help/tabletogrid-options-available#p13660
        	Help
        	http://www.trirand.com/blog/?page_id=393/help/tabletogrid-options-available#p13660
        	        	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?

]]>
        	        	Thu, 07 Jan 2010 20:48:33 +0200
        
        
        	tony on TableToGrid options available?
        	http://www.trirand.com/blog/?page_id=393/help/tabletogrid-options-available#p13653
        	Help
        	http://www.trirand.com/blog/?page_id=393/help/tabletogrid-options-available#p13653
        	        	Hello,


Look at datefmt option in the docs


Regards


Tony

]]>
        	        	Thu, 07 Jan 2010 20:27:51 +0200
        
        
        	eljaywilson on TableToGrid options available?
        	http://www.trirand.com/blog/?page_id=393/help/tabletogrid-options-available#p13612
        	Help
        	http://www.trirand.com/blog/?page_id=393/help/tabletogrid-options-available#p13612
        	        	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.

]]>
        	        	Wed, 06 Jan 2010 17:10:02 +0200
        
        
        	tony on TableToGrid options available?
        	http://www.trirand.com/blog/?page_id=393/help/tabletogrid-options-available#p13605
        	Help
        	http://www.trirand.com/blog/?page_id=393/help/tabletogrid-options-available#p13605
        	        	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

]]>
        	        	Wed, 06 Jan 2010 12:38:40 +0200
        
        
        	eljaywilson on TableToGrid options available?
        	http://www.trirand.com/blog/?page_id=393/help/tabletogrid-options-available#p13603
        	Help
        	http://www.trirand.com/blog/?page_id=393/help/tabletogrid-options-available#p13603
        	        	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.



]]>
        	        	Wed, 06 Jan 2010 12:27:40 +0200
        
        
        	tony on TableToGrid options available?
        	http://www.trirand.com/blog/?page_id=393/help/tabletogrid-options-available#p13588
        	Help
        	http://www.trirand.com/blog/?page_id=393/help/tabletogrid-options-available#p13588
        	        	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

]]>
        	        	Wed, 06 Jan 2010 09:09:59 +0200
        
        
        	eljaywilson on TableToGrid options available?
        	http://www.trirand.com/blog/?page_id=393/help/tabletogrid-options-available#p13555
        	Help
        	http://www.trirand.com/blog/?page_id=393/help/tabletogrid-options-available#p13555
        	        	

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

]]>
        	        	Mon, 04 Jan 2010 19:37:40 +0200
        
        
        	tony on TableToGrid options available?
        	http://www.trirand.com/blog/?page_id=393/help/tabletogrid-options-available#p13532
        	Help
        	http://www.trirand.com/blog/?page_id=393/help/tabletogrid-options-available#p13532
        	        	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

]]>
        	        	Sun, 03 Jan 2010 19:08:17 +0200