To check if the parameters are get correct you can still set the default values by example
|
1 2 3 4 |
$cid = jqGridUtils::GetParam('CYOTestQuestionID', 'valid_value'); $tType = jqGridUtils::GetParam('TestType', 'valid_type'); $grid->setAfterCrudAction('edit', "update tr_cyotestquestion set TestTypeID = ? WHERE CYOTestQuestionID=?",array($tType,$cid)); |
Se the result
Guriddo Support Team
The setAfterCrud action occur only when the parent operation is executed without problems.
Does the first update occur correct?
Guriddo Support Team
Hello,
Sorry for the inconvenience – we have fixed the problem. You can re download from the same location in our site.
Kind Regards,
Will
Guriddo Support Team
Hello,
Can you please set debug to true and see the result
Kind Regards,
Will
Guriddo Support Team
I have not tested this, but could you please try the following two approaches
First one. Change
|
1 2 |
... $conn->query("SET NAMES utf8"); |
To
|
1 2 |
... $conn->query("SET NAMES utf8mb4"); |
The Second one (which I think is better set the char set to the connection, something like
|
1 2 |
... $dbh = new PDO('mysql:charset=utf8mb4...'); |
Please let us know if the problem is resolved
Kind Regards,
Will
Guriddo Support Team
Hello,
Try to run the query from the log in the SQL console and in place of the ? set 1 – see the result
Kind Regards,
Will
Guriddo Support Team
Hello,
You may want to look at this documentation
Another possible solution is to use the grid option autoencode set to true, but you should take care in this case since:
When set to true the option encodes (html encode) the incoming (from server) and posted data (from editing modules). By example < will be converted and posted to <
Guriddo Support Team
Hello,
As I say in my previous post – we need a full example including css, js and etc – i.e full demo. This maybe is a CSS problem.
Another unknown point is : which CSS framework is used.
If you change the theme (if possible) what is happen?
Kind Regards,
Will
Guriddo Support Team
Hello,
Thanks. This is fixed too. Will be available in the next days with the publishing of the new release.
Kind Regards,
Will
Guriddo Support Team
Hello,
It all depends how you get the data when you loop through it.
If you use getRowData or getCell methods the result should be the value of the select and not the text, since these methods automatically calls the needed function to get back the value.
If you use your own method to get the data the of course it will get what is displayed into the grid.
If you prefer to use your way of getting data we recommend you to use the build in jqGrid function $.unformat.select(value, options), where the value is the formated text from the select and the options are the colMoodel options for that field. Example:
|
1 2 3 4 5 6 7 8 9 10 11 |
var selected_text = 'text1' var model = $("#jqGrid").jqGrid('getGridParam','colModel'); model = model[j]; // j is the index of the field in colModel // Some code befor calling selected_text = '<div>'+selected_text+'</div>'; options = { colModel : model }; var selected_value = $.unformat.select(selected_text, options); |
Hope this helps
Kind Regards,
Will
Guriddo Support Team
Hello,
No idea why is this. Suppose something wrong into the definition of the icon or the third grid has id identical to some of the other two or this is a css problem.
Without example demonstrating the problem we can not help.
Kind Regards,
Will
Guriddo Support Team
Hello,
This can be done different way, depending on the needs.
If I understand correct the requirement one possible solution is to join the two tables users and organisations by the user allowing the searching on user name.
The select command can be something like
|
1 2 |
... $grid->SelectCommand = "SELECT a.organization_name, a.user_name,... FROM organization a, users b WHERE a.user_name=b.user_name"; |
Kind Regards,
Will
Guriddo Support Team
Hello,
I highly recommend you to visit our demo page
Additionally to this you can visit the docs
In these docs we have special page how to work with dates and this too
To summarize you should use setDbDate and setUserDate again with datearray setting.
A working demo of these can be found here
Kind Regards,
Will
Guriddo Support Team
Hello,
colTotals are working fine, you will need to set them. Please look at the updated demo
Kind Regards,
Will
Guriddo Support Team
Hello,
We have fixed the problem in GitHub
You can get the build and test it. Please let us know if you have problems with this.
Kind Regards,
Will
Guriddo Support Team
Copyright 2014 TriRand LtdAll Rights ReservedRSS
Back to Top