jQuery Grid Plugin - jqGridForum

02/06/2009
18:32

maggie

Member

Members

Forum Posts: 49

Member Since:
17/12/2008

Offline

1

Hi,

I have a column called "Comments ". I set it as "TEXTAREA" on the edit form. I can use "Enter" key to do a new line in the input box. And the new line "\\n" can be saved in the database. But when I open the edit form again, the line break disappear. How to show the line break in the text area input box again? I am thinking of doing something using onInitializeForm function:

onInitializeForm :

function (formid) {

//replace "\\n" with the html code ;

}

Is this doable? can you give me some example codes?

Thanks!

Maggie

04/06/2009
05:25

tony

Sofia, Bulgaria

Moderator

Members

Moderators

Forum Posts: 7721

Member Since:
30/10/2007

Offline

2

Hello,

onInitialize form fires only one time. Try with beforeShowForm for that textarea field

Regards

Tony

For professional UI suites for Java Script and PHP visit us at our commercial products site - guriddo.net - by the very same guys that created jqGrid.

05/06/2009
17:22

maggie

Member

Members

Forum Posts: 49

Member Since:
17/12/2008

Offline

3

Hello,

How to get the value of a field and do the change?

I tired this:

beforeShowForm : function(formid){

alert ("field value: " + $("#Comments",formid).value);

},

But it does not work.

Can you give me an example?

Thanks,

Maggie

06/06/2009
07:59

maggie

Member

Members

Forum Posts: 49

Member Since:
17/12/2008

Offline

4

Hello,

I figured out how to get the form field value. but I can't make the line break work. My codes are as below:

beforeShowForm : function(formid){

//get comments (text area field) value;

var comments= $("#comments",formid).val() ;

//replacement

var newComments = comments.replace(/\\n/g, " ");

//set field with new value
$("#comments",formid).val(newComments);

}

For example, I want the field show in sevral lines:

firstline

secondline

thirdline

but it shows as firstline secondline thirdline

How to convert the to new lines?

I know I can use "

<![CDATA[]]>

" for the grid cell value, but it does not work for the edit form field.

Thanks, Maggie

11/06/2009
09:13

maggie

Member

Members

Forum Posts: 49

Member Since:
17/12/2008

Offline

5

Hello,

Anyone knows how to preserve line break in the form text area?

Thanks! Maggie

12/06/2009
02:36

tony

Sofia, Bulgaria

Moderator

Members

Moderators

Forum Posts: 7721

Member Since:
30/10/2007

Offline

6

Hello,

It is really difficult to play with this, but maybe you will need to call ajax in beforeShowForm to obtain that field from db.

Regards

Tony

For professional UI suites for Java Script and PHP visit us at our commercial products site - guriddo.net - by the very same guys that created jqGrid.

23/06/2009
10:42

JaySab

Member

Members

Forum Posts: 10

Member Since:
22/06/2009

Offline

7

Maggie, I'd be interested to know if you got anywhere with this as I am just starting to look at the same problem. I'm using inline editing. So far I've made a change to grid.inlinedit.js and allowed enter to be used in textareas without the row saving. But now I'm getting the same line break problem. The data is saved correctly, ie - it preserves the line break, but I don't know how to output the lline break to the textarea when editing.

30/06/2009
05:36

JaySab

Member

Members

Forum Posts: 10

Member Since:
22/06/2009

Offline

8

Right, I am getting somewhere with this problem now but am stuck again, so I'm hoping some kind soul could offer some advice.

In my function which returns (JSON format) data from the server, I'm doing a replace on CHR(10) and returning instead. This has the desired effect of breaking up my text in cells in the grid. Problem 1 solved.

In my call to editRow in my onSelectRow event, I'm passing a function name to the oneditfunc parameter. In this function I'm replacing with \\n. This has the desired effect of putting line breaks into my editable text area when the row is clicked. Problem 2 solved 🙂

My remaining problem is thus: when I edit a cell and put carriage returns in the text and hit return, the row is saved. Looking in my data, I can see that it has saved with a chr(10). So far so good. However, the grid doesn't refresh after a save, and the grid replaces any carriage returns with spaces. ie - in the GUI, it has now lost me my nice line breaks. So my question is - what is the best way to have the grid preserve these line breaks once they have been edited?

Thanks in advance.

01/07/2009
04:26

JaySab

Member

Members

Forum Posts: 10

Member Since:
22/06/2009

Offline

9

ok ...

I've solved my final problem by editing grid.inlinedit.js. After line 94:

tmp[nm]= !$t.p.autoencode ? $("input, textarea",this).val() : htmlEncode($("input, textarea",this).val());

I've added:

tmp[nm]=tmp[nm].replace(/\\n/g,' ');

This replaces the javascript \\n line breaks with a and allow line breaks to show correctly in cells when they are not being edited.

26/04/2010
17:20

phazzy

Member

Members

Forum Posts: 4

Member Since:
16/03/2009

Offline

10

Thanks for the solution!

I was replacing "\n" with &#10 after getting data from the server, and it was working perfectly in Firefox even when editing with textarea. But because of the JQuery .html() function behavior it was not working in IE at all. Your solution solved it 🙂