problem display'n information on a textfield

[rrochap]

I store informacion on my database, in using mysql i bring some information to my form using json. on the data base for example is stored 'en' but on the form appears 'en&#039 when i show it on a textfield or a textarea,
how can i fix that?

[rrochap]

any idea????

[Darklight]

&#039 ; is the ' sign. your backend probably returns it like this, so you should look for the fix there. check with FireBug what is delivered via json

[Condor]

You should post the source (that you already PM'ed me).

Also, post the data that is actually received from the server (use Firebug's Net tab).

[rrochap]

hey men thnks 4 ur help..
now i check the json response and ur right, it comes with ' but.. when i show it in the grid it shows ( ' ) thats ok.... but when it shows on a text field, shows ' .. i think. the problem is the way that the information is decode by the grid or texfield is different.. i dont know...

[rrochap]

Json..

{"results":[{"id_":"'A'","nom":"'B'","tip":"'C'","des":"'D'","sql":"'E'"}]}

hey, in this part instead of ( ' ) the json response is with ( & 0 3 9 ; ) but when it paste it and show it.. just transform it..

Code...

var form = new Ext.FormPanel({
      region:'center',
			el:'main-form',
			width:'100%',
			bodyStyle:'padding:5px 5px 0',
			labelWidth:75,
			labelAlign:'right',
			reader: new Ext.data.JsonReader({
				root:'results',
				id: 'id_',
				fields: ['id_', 'nom', 'tip', 'des', 'sql']
			}, [
				{name:'query.id', mapping:'id_'},
				{name:'query.nombre', mapping:'nom'},
				{name:'query.tipo', mapping:'tip'},
				{name:'query.descripcion', mapping:'des'},
				{name:'query.sql', mapping:'sql'},
			]),
			layout:'form',
			defaults:{ width:250 },
      items: [{
				xtype:'hidden',
				name:'query.id'
			},frm_tipos,
			{
				xtype:'textfield',
				fieldLabel:"Nombre",
				name:'query.nombre',
				allowBlank:false,
				maxLength:20
			},{
				xtype:'textarea',
				fieldLabel:"Descripcion",
				name:'query.descripcion',
				allowBlank:false,
				maxLength:150
			},{
				xtype:'textarea',
				fieldLabel:"Query",
				allowBlank:false,
				height:200,
				width:400,
				name:'query.sql'
			}]

[Darklight]

you could try Ext.util.Format.htmlDecode()

[Condor]

So your server is already sending the & #039; ?

In that case the JsonReader needs to decode the values:

...
[
	{name:'query.id', mapping:'id_', convert: decode039},
	{name:'query.nombre', mapping:'nom', convert: decode039},
	{name:'query.tipo', mapping:'tip', convert: decode039},
	{name:'query.descripcion', mapping:'des', convert: decode039},
	{name:'query.sql', mapping:'sql', convert: decode039}
]
...

with

function decode039(v) {
	return !v ? v : String(v).replace(/& #039;/g, "'");
}

ps. Remove the space between & and #039.

[rrochap]

ok .. but for each field of my form???? i think its a little. difficult.. cause i have a lot of forms... but.. i still don't understand.. why works with grids and not with textfields, textareas and comboxes..
there's not a better way to do that?

[Darklight]

maybe the grid has htmldecode built in. the easiest way would still be to have your backend send it correctly