I have a field that returns a file-path from MSSQL Database.
The grid is dropping the slash characters and not displaying correctly.
I would also like to include this field as a link – but it's being URL encoded, even though I have turned-off (disabled) URLENCODE in jqgrid_dist.php.
I have looked-over the support forum for the past 20-minutes and can't find anything other than the URLencode.
You can try editing jqgrid_dist.php and comment: line 2830
foreach($row as $k=>$r)
$row[$k] = stripslashes($row[$k]);
This may work for your case.
how could i change above code to only skip the stripslashes if “column” “Folders” ?
So only for one column instead of comment always.
Thanks for the reply and the suggestion – I'm going to test that now.
I came-up with a work-around that sort-of works – as I noticed it was only stripping single slashes.
For MSSQL at least – you can use the replace() function. I used 3 slashes which seems to produce the correct results for me.
replace(DATA_FIELD, '', '\')
Thanks again for the continued support.
How useful was this discussion?
Click on a star to rate it!
Average rating / 5. Vote count:
We are sorry that this post was not useful for you!
Let us improve this post!
Thanks for your feedback!