Login

04-27-2008, 01:30 AM

[eluser]eRic.Net[/eluser]
flexigrid is great!!
I'm using flexigrid in asp.net,but it doesn't work.

Response Content:

Code:
{page :1,total:2,rows:[{id:'1',cell:[{'1','Map_A','M',''}]},{id:'2',cell:[{'2','Map_B','N',''}]}]}

Code:
$(document).ready(function()

   {

        $("#GridBox").flexigrid(

        {

           url: 'ListMap.aspx',

            dataType: 'json',

            colModel : [

                {display: 'MapID', name : 'MapId', width : 100, sortable : true, align: 'center'},

                {display: 'Name', name : 'Name', width : 180, sortable : true, align: 'left'},

                {display: 'Shortcut', name : 'Shortcut', width : 220, sortable : true, align: 'left'},

                {display: 'Description', name : 'Description', width : 220, sortable : true, align: 'left'}

                ],

            buttons : [

                {name: 'Add', bclass: 'add'},

                {name: 'Delete', bclass: 'delete'},

                {separator: true}

                ],

            searchitems : [

                {display: 'Shortcut', name : 'Shortcut'},

                {display: 'Name', name : 'name', isdefault: true}

                ],

            sortname: "MapID",

            sortorder: "asc",

            usepager: true,

            title: 'Countries',

            useRp: true,

            rp: 15,

            showTableToggleBtn: true,

            width: 700,

            height: 200

    }

        );

   })

ListMap.aspx:

Code:
string JSON = "";

    protected void Page_Load(object sender, EventArgs e)

    {

        WWFansWebs webs = new WWFansWebs();

        JSON = webs.ListWwMap();

        Response.ContentType = "text/x-json";

        Response.Write(JSON);

        Response.End();

    }

where's wrong?

04-27-2008, 02:53 AM

[eluser]eRic.Net[/eluser]
But xml works well.
It's great!!

04-27-2008, 03:25 AM

[eluser]eRic.Net[/eluser]
Got it.
Response Content should be like this:

Code:
{page :1, total:2, rows:[{id:'1',cell:['1','Map_A','M','']},

{id:'2',cell:['2','Map_A','N','']}]}

:-)

04-27-2008, 04:15 AM

[eluser]eRic.Net[/eluser]
put all images into one file will be better, i think.

04-27-2008, 10:39 AM

[eluser]Unknown[/eluser]
[quote author="Armorfist" date="1207857464"]Open the file "system/application/controller/flexigrid.php", go to line 44 and change:

Code:
$grid_js = build_grid_js('flex1','ajax/',$colModel,$buttons,'id','asc','auto','400',$this->config->item('fg_per_page'));

to

Code:
$grid_js = build_grid_js('flex1','/jf/index.php/ajax/index',$colModel,$buttons,'id','asc','auto','400',$this->config->item('fg_per_page'));

I think the first one should work, but lets see if that solves the problem.

The second function parameter is the URL which the data is retrieved. In this case the "ajax" controller. To see what the other arguments represent open the "system/application/helpers/flexigrid_helper" file and read the function comments.[/quote]

Hi I have the same problem with wish_bear and tried what you suggested and i still cant get it to load

I even placed "exit;" on ajax.php just to see if it goes there and nothing happens... i'm stuck with this for a while now... pls help =)

EDIT: ok i found the problem, it was not the build_grid_js('flex1','/jf/index.php/ajax/index'.... etc i missed a line of code <table id="flex1" style="display:none"></table> which prevented the grid from displaying =/

04-27-2008, 10:52 AM

[eluser]Dan Decker[/eluser]
paulo, this is awesome! I'm just getting my feet wet with jQuery, and this is by far the best looking table manipulator out there.

I am having some issues that don't seem to make much sense. When I look at your examples, and other examples based on flexigrid, things look fantastic! But when I view my own code in Safar 3.1.1, the bars for resizing columns don't show correctly (they are "off the mark"), and the menu and image for show/hide columns appears in the middle of the column's heading.

Here's the Code:

Code:
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"

        "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

&lt;html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en"&gt;

&lt;head&gt;

    &lt;meta http-equiv="content-type" content="text/html; charset=utf-8" /&gt;

    &lt;link rel="stylesheet" rev="stylesheet" href="css/flexigrid/flexigrid.css" type="text/css" media="all" /&gt;

&lt; script type="text/javascript" &gt;

$(function()

    {

            $('#my_table').flexigrid(

        {

            colModel: [

                          {display: 'ID Number', name: 'id_number', width: 80, sortable: false, showToggleBtn: false, align: 'center'},

                          {display: 'Sort 1', name: 'sort_1', width: 80, sortable: false, align: 'center'},

                          {display: 'First Name', name: 'f_name', width: 100, sortable: false, align: 'left'},

                          {display: 'Last Nmae', name: 'l_name', width: 100, sortable: false, align: 'left'},

                      ],

            searchitems:

                      [

                          {display: 'ID Number', name: 'id_number'},

                          {display: 'Sort 1', name: 'sort_1'},

                          {display: 'First Name', name: 'f_name'},

                          {display: 'Last Nmae', name: 'l_name'}

                      ],

            usepager: false,

            title: 'Test Table'

        }

        );

    }

);

< /script >

    &lt;title&gt;Table Stuff&lt;/title&gt;

&lt;/head&gt;

&lt;body&gt;

<table id="my_table">

    <thead>

    <tr>

        <th width="80">ID Number</th>

        <th width="80">Sort 1</th>

        <th width="100">First Name</th>

        <th width="100">Last Name</th>

    </tr>

    </thead>

    <tbody>

    <tr>

        <td>01</td>

        <td>A</td>

        <td>Adam</td>

        <td>Zest</td>

    </tr>

    <tr>

        <td>02</td>

        <td>AA</td>

        <td>Barbara</td>

        <td>York</td>

    </tr>

    <tr>

        <td>03</td>

        <td>B</td>

        <td>Chris</td>

        <td>Xerxes</td>

    </tr>

    <tr>

        <td>04</td>

        <td>BB</td>

        <td>Dave</td>

        <td>Williams</td>

    </tr>

    <tr>

        <td>05</td>

        <td>C</td>

        <td>Edward</td>

        <td>Victors</td>

    </tr>

    <tr>

        <td>06</td>

        <td>CC</td>

        <td>Frank</td>

        <td>Umbridge</td>

    </tr>

    <tr>

        <td>07</td>

        <td>D</td>

        <td>Gary</td>

        <td>Thomas</td>

    </tr>

    <tr>

        <td>08</td>

        <td>DD</td>

        <td>Hank</td>

        <td>Stevens</td>

    </tr>

    <tr>

        <td>09</td>

        <td>E</td>

        <td>Isabell</td>

        <td>Roberts</td>

    </tr>

    </tbody>

</table>

&lt;/body&gt;

&lt;/html&gt;

I've attached a screenshot of the issue.

TIA,

04-27-2008, 10:57 AM

[eluser]Dan Decker[/eluser]
OK, so egg on my face here, but if you set each < th > element's width attribute to match the width option in the flexigrid params, problem solved. :red:

EDIT: Apparently it was a fluke, I'm still having the issue. :-(

04-28-2008, 05:16 AM

[eluser]Kevin Kietel[/eluser]
[quote author="Roberto Miguez" date="1209204323"]Trying the example made by Kevin Kietel at http://sanderkorvemaker.nl/test/flexigrid/ I saw that the search based on letters doesn't work. This is a great functionality. Can anyone help me to solve this issue? I tried but I don't know what to do.[/quote]

@Roberto:

I've updated the example on http://sanderkorvemaker.nl/test/flexigrid/ (the zip file is also updated)
The search based on letters is functional now. You can use the letters on the top of the grid to find items that start with a certain letter. The search criteria are set by the select box in the quick search bar. So when the quick search bar is set to 'name', and you press the letter F, the MySQL query will be like:

Code:
SELECT id,iso,name,printable_name,iso3,numcode FROM country WHERE `name` LIKE 'F%'

When you want to see all numerical items, the MySQL query will be:

Code:
SELECT id,iso,name,printable_name,iso3,numcode FROM country WHERE `name` REGEXP '[[:digit:]]'

Hope this will help you and other users!

04-28-2008, 05:46 AM

[eluser]noon[/eluser]
What I am going for is a true flexi flexigrid. I want my widths/heights fluid to fill an entire browser window regardless of the size. Anyone think its possible? Did it already? Want to help?

04-28-2008, 07:23 AM

[eluser]noon[/eluser]
IE6 bug -- setting width to 'auto' results in the pagination display to disappear when you hover over any of the column names or buttons.