Grid problem with IE8

[Hubert RENAULTMember]

HI,

when I use the option filterable: true it causes this error

Détails de l’erreur de la page Web

Agent utilisateur : Mozilla/4.0 (compatible; MSIE 8.0; Windows NT 5.1; Trident/4.0; .NET CLR 1.1.4322; .NET CLR 2.0.50727; .NET CLR 3.0.4506.2152; .NET CLR 3.5.30729; .NET4.0C; .NET4.0E)
Horodateur : Mon, 12 Nov 2012 16:21:11 UTC

Message : ‘this.columns[…].columntype’ a la valeur Null ou n’est pas un objet.
Ligne : 7
Caractère : 11679
Code : 0
URI : http://……………./jqwidgets/jqxgrid.js

with this code:

$(document).ready(function () {
var theme = getTheme();
// prepare the data
var source =
{
datatype: “json”,
datafields: [
{ name: ‘Marque’},
{ name: ‘Prix’},
{ name: ‘Kms’},
{ name: ‘Annee’},
{ name: ‘Photo’},
],
url: ‘importcardiff/data3.php’
};
var imagerenderer = function (row, datafield, value) {
return ‘‘;
}
var dataAdapter = new $.jqx.dataAdapter(source);

$(“#jqxgrid1″).jqxGrid(
{
width: 560,
rowsheight: 80,
sortable: true,
source: dataAdapter,
theme: theme,
columnsresize: true,
showfilterrow: true,
filterable: true,
columns: [
{ text: ”, datafield: ‘Photo’, width: 90, cellsrenderer: imagerenderer },
{ text: ‘Marque Modèle Finition’, filtertype: ‘list’, datafield: ‘Marque’,width: 200},
{ text: ‘Prix’, datafield: ‘Prix’, filtertype: ‘list’, width: 100},
{ text: ‘Kms’, datafield: ‘Kms’, width: 90 },
{ text: ‘Année’, datafield: ‘Annee’, width: 80 },

]
});
///////////////////////////////////////////////////////

var h=(80*)+30;
$(‘#jqxgrid1’).jqxGrid({ height: h });

});

What happen?

Thanks

[Peter StoevKeymaster]

Hi Hubert RENAULT,

As a solution, remove the { name: ‘Photo’},

Best Regards,
Peter Stoev

jQWidgets Team
http://www.jqwidgets.com

[Hubert RENAULTMember]

If i do that, the picture doesn’t appear

[Peter StoevKeymaster]

There’s a syntax issue here as well: { text: ‘Année’, datafield: ‘Annee’, width: 80 },. Last Items of Arrays should be without ‘,’.

Best Regards,
Peter Stoev

jQWidgets Team
http://www.jqwidgets.com

[Hubert RENAULTMember]

thank you, I corrected it but no improvement..

[Peter StoevKeymaster]

Please provide us a complete small sample which we will be able to run locally and we will fix it for you.

Best Regards,
Peter Stoev

jQWidgets Team
http://www.jqwidgets.com

[Hubert RENAULTMember]

Hi,

There is my home page + details.php + sql

http://wintra.ispa.asso.fr/home.zip

Thanks

[Peter StoevKeymaster]

Hi Hubert RENAULT,

In the provided code, you didn’t remove the ‘,’ in this line:

{ text: 'Année', datafield: 'Annee', cellsalign: 'center', filtertype: 'list', width: 80 },

Unfortunately, I wasn’t able to use the sql in the archive to generate a table with columns. There’s only INSERT statement for adding values, but without Create Table.

Best Regards,
Peter Stoev

jQWidgets Team
http://www.jqwidgets.com

[Hubert RENAULTMember]

excuse me,

CREATE TABLE `adherents` (
`ID` int(11) NOT NULL auto_increment,
`RAISON SOCIALE` text collate utf8_unicode_ci,
`DIRIGEANT` text collate utf8_unicode_ci,
`ADRESSE` text collate utf8_unicode_ci,
`CP` text collate utf8_unicode_ci,
`VILLE` text collate utf8_unicode_ci,
`TEL` text collate utf8_unicode_ci,
`TELECOPIE` text collate utf8_unicode_ci,
`ACTIVITE` text collate utf8_unicode_ci,
`EMAIL` text collate utf8_unicode_ci,
`SITE` text collate utf8_unicode_ci,
`EMAIL2` text collate utf8_unicode_ci,
`SITE2` text collate utf8_unicode_ci,
`EMAIL3` text collate utf8_unicode_ci,
`SITE3` text collate utf8_unicode_ci,
PRIMARY KEY (`ID`)
) ENGINE=InnoDB AUTO_INCREMENT=61150 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=61150 ;

[Hubert RENAULTMember]

excuse-me again it is the right

CREATE TABLE `ambulance` (
`id_ambulance` int(11) NOT NULL auto_increment,
`identifiant` mediumint(9) NOT NULL,
`vo` int(11) NOT NULL,
`type` varchar(10) NOT NULL,
`marque` varchar(30) NOT NULL,
`modele` varchar(40) NOT NULL,
`version` varchar(80) NOT NULL,
`carrosserie` varchar(20) NOT NULL,
`nb_porte` int(11) NOT NULL,
`energie` varchar(20) NOT NULL,
`boite` varchar(20) NOT NULL,
`puis_fisc` varchar(2) NOT NULL,
`puis_din` int(11) NOT NULL,
`millesime` varchar(4) NOT NULL,
`circulation` date NOT NULL,
`kms` int(11) NOT NULL,
`couleur` varchar(20) NOT NULL,
`1_main` int(11) NOT NULL,
`equipement` longtext NOT NULL,
`prix_pub` varchar(30) NOT NULL,
`prix_marc` varchar(40) NOT NULL,
`garantie` varchar(30) NOT NULL,
`duree` int(11) NOT NULL,
`sellerie` varchar(30) NOT NULL,
`coul_int` varchar(30) NOT NULL,
`photo` text NOT NULL,
PRIMARY KEY (`id_ambulance`)
) ENGINE=MyISAM AUTO_INCREMENT=10 DEFAULT CHARSET=latin1 AUTO_INCREMENT=10 ;

[Hubert RENAULTMember]

That’s ok, it works!

I remove the “,” at the end of the line
{ text: ‘Année’, datafield: ‘Annee’, cellsalign: ‘center’, filtertype: ‘list’, width: 80 },

Many thanks

[Author]

Posts