Messages

1

ParamQuery Pro Evaluation Support / Re: Is there any support for using the AutoComplete with a <Select>?

« on: September 11, 2014, 06:36:01 pm »

I have set up a jsfiddle:
http://jsfiddle.net/v4zx8tjc/1/

If you select a record in the play column and use the up or down arrow keys, it does not behave as expected...

2

ParamQuery Pro Evaluation Support / Re: Is there any support for using the AutoComplete with a <Select>?

« on: September 10, 2014, 07:00:33 pm »

Is there any way to override the cursor up and cursor down keys and pass the keypress along to the editor?
This would help greatly with the focus moving from the autoComplete select list and grabbing the wrong item in the list...

3

ParamQuery Pro Evaluation Support / Is there any support for using the AutoComplete with a <Select>?

« on: September 07, 2014, 12:37:22 pm »

We need to be able to use autocomplete with Select Combo boxes, but all of your examples are with input text-boxes.

We have been able to get the autocomplete to display and partially work, but it has many issues including showing the index some times instead of the related text if the up or down arrows are pressed.

Is there anything special we should be doing to use autocomplete with <Select>?

4

ParamQuery Pro Evaluation Support / Re: ID not updated after insert, Delete fails due to no ID

« on: August 06, 2014, 04:00:28 pm »

Issue solved finally...
I had two issues:
For the New Record, I was setting the primaryId to 0 when it should have been set to Null.
When returning the JSON response, there was header data being sent also that was interfering with the decoding of the JSON Response.

5

ParamQuery Pro Evaluation Support / Re: ID not updated after insert, Delete fails due to no ID

« on: August 02, 2014, 11:16:45 pm »

I am using the batch editing, and I can add a record and the server sends the reply back.
I see the 2 following messages:
From the add action
[{"P":"","DistanceID":0,"HashID":5,"DownID":1,"DrillNumber":1,"DrillItemID":879,"DrillID":85,"FieldPositionID":1}]
From the update action
[{"P":"","DistanceID":0,"HashID":5,"DownID":1,"DrillNumber":1,"DrillItemID":0,"DrillID":85,"FieldPositionID":1}]

I only added a record and saved.  Why is the update action fired?
The DrillItemId of 879 is the newly inserted record.
Why did the DrillItemId revert back to 0 and send an update?
does the order of the data returned matter?

6

ParamQuery Pro Evaluation Support / Validations exception

« on: July 31, 2014, 07:43:09 pm »

While saving with a validation, I am getting an exception at line 2731 of pqgrid.dev.js
The following is the error and stack trace:
Uncaught TypeError: undefined is not a function bootstrap.min.js:11
(anonymous function) bootstrap.min.js:11
b.extend.each jquery.js:7123
b.fn.b.each jquery.js:6735
a.fn.tooltip bootstrap.min.js:11
fn._isValidCell pqgrid.dev.js:2393
(anonymous function) jquery-ui.custom.js:401
fn.isValid pqgrid.dev.js:2441
(anonymous function) jquery-ui.custom.js:401
(anonymous function) jquery-ui.custom.js:493
b.extend.each jquery.js:7123
b.fn.b.each jquery.js:6735
$.widget.bridge.$.fn.(anonymous function) jquery-ui.custom.js:483
obj.cellBeforeSave edit-practiceScriptTemplate.cfm?DrillId=13:546
$.Widget._trigger jquery-ui.custom.js:785
fn.saveEditCell pqgrid.dev.js:4522
(anonymous function) jquery-ui.custom.js:401
(anonymous function) jquery-ui.custom.js:493
b.extend.each jquery.js:7123
b.fn.b.each jquery.js:6735
$.widget.bridge.$.fn.(anonymous function) jquery-ui.custom.js:483
acceptChanges edit-practiceScriptTemplate.cfm?DrillId=13:233
obj.toolbar.items.listeners.click edit-practiceScriptTemplate.cfm?DrillId=13:462
b.event.dispatch jquery.js:9593
b.event.add.v.handle jquery.js:9273

The column/validation in question:
{
            title: "Hash", "dataIndx": "HashID", "dataType": "integer",
            editor: {
                type: 'select',
                options: hashes                               
            },
            align:'center',
            render: function (ui) {
                var options = ui.column.editor.options,
                    cellData = ui.cellData;
                for (var i = 0; i < options.length; i++) {
                    var option = options;
                    if (option[cellData]) {
                        return option[cellData];
                    }
                }
            },
            validations: [
                    { type: 'gt', value: 0, msg: "The Hash is Required.  Please Select a Hash from the list." }
                ]
         }

Did I do something incorrectly?
Thank you for your assistance...

7

ParamQuery Pro Evaluation Support / ID not updated after insert, Delete fails due to no ID

« on: July 31, 2014, 05:19:56 pm »

How do I make sure that the inserted records get updated with the new primary key?
I am using MSSQL with an autogenerated Primary Key.