gridView.recordcount 1 gridView.inlineEdit version 02.00.12 connectionType 0 connectionString tablename Ratings tableKeyColumn ID gridview.bulkimport gridview.bulkexport gridview.bulkdelete gridview.insertrecord on gridview.editrecord gridview.deleterecord gridview.viewrecord hidegridview gridView.hideElement 0 gridView.pagerecord hidegridviewonedit on grideditshowabovegridview editbuttonsinlastcoulumns gridedit.captionposition gridedit.checkwebpageonexit gridEdit.mode 2 gridEdit.valueID gridEdit.TextboxWidth gridEdit.redirectURL gridEdit.txt_Save gridEdit.txt_Insert gridEdit.txt_Back gridEdit.txt_Next gridEdit.txt_Finish gridEdit.txt_cancel gridEdit_customHTMLForm gridEdit.isBinary binaryData.fileSytemDBPath networkCredential.userName networkCredential.passWord sqldeveloperwindowcb importexportcb on gridView.importStopAfterErrorCount 10 isEmptyCaptionReplaced on gridedit.allowunecryptedquerystring gridedit.isgridvieweditredirected gridview.ispagenumbertextbox gridView.gridDdlForm 0 gridView.ID gridEdit.ID geRating gridEdit.validRedirectURLSetParameter gridEdit.validRedirectURLDelParameter gridEdit.sendToMail gridView.OrderBy gridView.SqlWhere moduleHeader <script language="javascript"> var mode = Number(' [getNumericObject:viewpage.gridByID("geItem").idvalue]'); var rating = Number('<command sql="SELECT ID FROM Ratings WHERE (UserID = [User:UserID]) AND (ItemID = [getNumericObject:viewpage.gridByID("geItem").idvalue])"></command>'); if ((rating > 0) && (mode > 0)) { document.write('You already did comment/rate this item but you can do it again.<br> '); } </script> moduleFooter htmlHeadBlock startupScriptBlock »setModuleVisibilityByGridId:geRating=[compute:iif([idValueByGridEditId:geItem]<1,0,1)]« onSubmitScriptBlock sqlOnInsertRecord delete from Ratings WHERE (Ratings.UserID = [user:UserID]) AND (Ratings.ItemID = [getNumericObject:viewpage.gridByID("geItem").idvalue]) AND (Ratings.ID <> [indoogrid:idValue]) sqlOnUpdateRecord sqlOnViewModule sqlOnViewRecord gridViewColumn.0.columnName ItemID gridViewColumn.0.Visible on gridViewColumn.0.allowExport on gridViewColumn.0.allowEdit on gridViewColumn.0.allowFilter 1 gridViewColumn.0.allowSort on gridViewColumn.0.allowImport on gridEditColumn.0.columnName ItemID gridEditColumn.0.Visible gridEditColumn.0.multiplePage 1 gridEditColumn.0.Autovalidator on gridViewColumn.1.columnName UserID gridViewColumn.1.Visible on gridViewColumn.1.allowExport on gridViewColumn.1.allowEdit on gridViewColumn.1.allowFilter 1 gridViewColumn.1.allowSort on gridViewColumn.1.allowImport on gridEditColumn.1.columnName UserID gridEditColumn.1.Visible gridEditColumn.1.multiplePage 1 gridEditColumn.1.Autovalidator on gridViewColumn.2.columnName Rating gridViewColumn.2.Visible on gridViewColumn.2.allowExport on gridViewColumn.2.allowEdit on gridViewColumn.2.allowFilter 1 gridViewColumn.2.allowSort on gridViewColumn.2.allowImport on gridEditColumn.2.columnName Rating gridEditColumn.2.Visible on gridEditColumn.2.multiplePage 1 gridEditColumn.2.Autovalidator on gridViewColumn.3.columnName Comment gridViewColumn.3.Visible on gridViewColumn.3.allowExport on gridViewColumn.3.allowEdit on gridViewColumn.3.allowFilter 1 gridViewColumn.3.allowSort on gridViewColumn.3.allowImport on gridEditColumn.3.columnName Comment gridEditColumn.3.Visible on gridEditColumn.3.multiplePage 1 gridEditColumn.3.Autovalidator on gridViewColumn.0.caption gridViewColumn.1.caption gridViewColumn.2.caption gridViewColumn.3.caption gridEditColumn.0.caption gridEditColumn.0.Readonly gridEditColumn.1.caption gridEditColumn.1.Readonly gridEditColumn.2.caption <br><b>Your opinion counts! </b><br> gridEditColumn.2.Readonly gridEditColumn.3.caption <br><br>Your comment (500 chars max)<br> gridEditColumn.3.Readonly gridEditColumn.2.separator gridEditColumn.2.trCssClass gridEditColumn.2.helpText gridEditColumn.2.multipageConditions gridEditColumn.2.isHtmlAttributes gridEditColumn.2.fieldValue gridEditColumn.2.fieldFormat gridEditColumn.2.textBoxWidth gridEditColumn.2.allowUrlInput gridEditColumn.2.fieldValueAsInsert gridEditColumn.2.DropDownList on gridEditColumn.2.ddlType 2 gridEditColumn.2.ddlMode 0 gridEditColumn.2.ddlList 5;Excellent 4;Very good 3;Average 2;Below average 1;Bad gridEditColumn.2.ddlDefaultValue 3 gridEditColumn.2.ddlNullText gridEditColumn.2.ddlRequired gridEditColumn.2.ddlSortById gridEditColumn.3.separator gridEditColumn.3.trCssClass gridEditColumn.3.helpText gridEditColumn.3.multipageConditions gridEditColumn.3.isHtmlAttributes gridEditColumn.3.fieldValue gridEditColumn.3.textBoxWidth 200 gridEditColumn.3.allowUrlInput gridEditColumn.3.fieldValueAsInsert gridEditColumn.3.DropDownList gridEditColumn.3.CustomValidator gridEditColumn.3.regExClient on gridEditColumn.3.password gridEditColumn.3.multiline 10 gridEditColumn.3.editor gridEditColumn.3.isBoolean notskipsqlonimport on gridEditColumn.0.separator gridEditColumn.0.trCssClass gridEditColumn.0.helpText gridEditColumn.0.multipageConditions gridEditColumn.0.isHtmlAttributes gridViewColumn.2.width gridViewColumn.2.defaultContent gridViewColumn.2.formatData gridViewColumn.2.importDefault gridViewColumn.2.filterAdditionalColumn gridViewColumn.2.defaultSortColumn gridViewColumn.2.isBoolean gridViewColumn.2.isLink gridViewColumn.2.isOther 0 gridViewColumn.2.isBinary gridViewColumn.2.isJoin gridViewColumn.2.isHtmlAttributes showGridView on showGridEdit on gridview.sqlstatementquery sqlOnUpdateFinishRecord gridEditColumn.0.fieldValue [idValueByGridEditId:geItem] gridEditColumn.0.fieldFormat gridEditColumn.0.textBoxWidth gridEditColumn.0.allowUrlInput gridEditColumn.0.fieldValueAsInsert gridEditColumn.1.separator gridEditColumn.1.trCssClass gridEditColumn.1.helpText gridEditColumn.1.multipageConditions gridEditColumn.1.isHtmlAttributes gridEditColumn.1.fieldValue [User:UserID] gridEditColumn.1.fieldFormat gridEditColumn.1.textBoxWidth gridEditColumn.1.allowUrlInput gridEditColumn.1.fieldValueAsInsert gridView.recordcount 1 gridView.inlineEdit version 02.00.13 connectionType 0 connectionString tablename Ratings tableKeyColumn ID gridview.bulkimport gridview.bulkexport gridview.bulkdelete gridview.insertrecord on gridview.editrecord gridview.deleterecord gridview.viewrecord hidegridview gridView.hideElement 0 gridView.pagerecord hidegridviewonedit on grideditshowabovegridview editbuttonsinlastcoulumns gridedit.captionposition gridedit.checkwebpageonexit gridEdit.mode 2 gridEdit.valueID gridEdit.TextboxWidth gridEdit.redirectURL gridEdit.txt_Save gridEdit.txt_Insert gridEdit.txt_Back gridEdit.txt_Next gridEdit.txt_Finish gridEdit.txt_cancel gridEdit_customHTMLForm gridEdit.isBinary binaryData.fileSytemDBPath |DataDirectory|indooGrid\ networkCredential.userName networkCredential.passWord sqldeveloperwindowcb importexportcb on gridView.importStopAfterErrorCount 10 isEmptyCaptionReplaced on gridedit.allowunecryptedquerystring gridedit.isgridvieweditredirected gridview.ispagenumbertextbox gridView.gridDdlForm 0 gridView.ID gridEdit.ID geRating gridEdit.validRedirectURLSetParameter gridEdit.validRedirectURLDelParameter gridEdit.sendToMail gridView.OrderBy gridView.SqlWhere moduleHeader <script language="javascript"> var mode = Number(' [getNumericObject:viewpage.gridByID("geItem").idvalue]'); var rating = Number('<command sql="SELECT ID FROM Ratings WHERE (UserID = [User:UserID]) AND (ItemID = [getNumericObject:viewpage.gridByID("geItem").idvalue])"></command>'); if ((rating > 0) && (mode > 0)) { document.write('You already did comment/rate this item but you can do it again.<br> '); } </script> moduleFooter htmlHeadBlock startupScriptBlock »setModuleVisibilityByGridId:geRating=[compute:iif([idValueByGridEditId:geItem]<1,0,1)]« onSubmitScriptBlock sqlOnInsertRecord delete from Ratings WHERE (Ratings.UserID = [user:UserID]) AND (Ratings.ItemID = [getNumericObject:viewpage.gridByID("geItem").idvalue]) AND (Ratings.ID <> [indoogrid:idValue]) sqlOnUpdateRecord sqlOnViewModule sqlOnViewRecord gridViewColumn.0.columnName ItemID gridViewColumn.0.Visible on gridViewColumn.0.allowExport on gridViewColumn.0.allowEdit on gridViewColumn.0.allowFilter 1 gridViewColumn.0.allowSort on gridViewColumn.0.allowImport on gridEditColumn.0.columnName ItemID gridEditColumn.0.Visible gridEditColumn.0.multiplePage 1 gridEditColumn.0.Autovalidator on gridViewColumn.1.columnName UserID gridViewColumn.1.Visible on gridViewColumn.1.allowExport on gridViewColumn.1.allowEdit on gridViewColumn.1.allowFilter 1 gridViewColumn.1.allowSort on gridViewColumn.1.allowImport on gridEditColumn.1.columnName UserID gridEditColumn.1.Visible gridEditColumn.1.multiplePage 1 gridEditColumn.1.Autovalidator on gridViewColumn.2.columnName Rating gridViewColumn.2.Visible on gridViewColumn.2.allowExport on gridViewColumn.2.allowEdit on gridViewColumn.2.allowFilter 1 gridViewColumn.2.allowSort on gridViewColumn.2.allowImport on gridEditColumn.2.columnName Rating gridEditColumn.2.Visible on gridEditColumn.2.multiplePage 1 gridEditColumn.2.Autovalidator on gridViewColumn.3.columnName Comment gridViewColumn.3.Visible on gridViewColumn.3.allowExport on gridViewColumn.3.allowEdit on gridViewColumn.3.allowFilter 1 gridViewColumn.3.allowSort on gridViewColumn.3.allowImport on gridEditColumn.3.columnName Comment gridEditColumn.3.Visible on gridEditColumn.3.multiplePage 1 gridEditColumn.3.Autovalidator on gridViewColumn.0.caption gridViewColumn.1.caption gridViewColumn.2.caption gridViewColumn.3.caption gridEditColumn.0.caption gridEditColumn.0.Readonly gridEditColumn.1.caption gridEditColumn.1.Readonly gridEditColumn.2.caption <br><b>Your opinion counts! </b><br> gridEditColumn.2.Readonly gridEditColumn.3.caption <br><br>Your comment (500 chars max)<br> gridEditColumn.3.Readonly gridEditColumn.2.separator gridEditColumn.2.trCssClass gridEditColumn.2.helpText gridEditColumn.2.multipageConditions gridEditColumn.2.isHtmlAttributes gridEditColumn.2.fieldValue gridEditColumn.2.fieldFormat gridEditColumn.2.textBoxWidth gridEditColumn.2.allowUrlInput gridEditColumn.2.fieldValueAsInsert gridEditColumn.2.DropDownList on gridEditColumn.2.ddlType 2 gridEditColumn.2.ddlMode 0 gridEditColumn.2.ddlList 5;Excellent 4;Very good 3;Average 2;Below average 1;Bad gridEditColumn.2.ddlDefaultValue 3 gridEditColumn.2.ddlNullText gridEditColumn.2.ddlRequired gridEditColumn.2.ddlSortById gridEditColumn.3.separator gridEditColumn.3.trCssClass gridEditColumn.3.helpText gridEditColumn.3.multipageConditions gridEditColumn.3.isHtmlAttributes gridEditColumn.3.fieldValue gridEditColumn.3.textBoxWidth 200 gridEditColumn.3.allowUrlInput gridEditColumn.3.fieldValueAsInsert gridEditColumn.3.DropDownList gridEditColumn.3.CustomValidator gridEditColumn.3.regExClient on gridEditColumn.3.password gridEditColumn.3.multiline 10 gridEditColumn.3.editor gridEditColumn.3.isBoolean notskipsqlonimport on gridEditColumn.0.separator gridEditColumn.0.trCssClass gridEditColumn.0.helpText gridEditColumn.0.multipageConditions gridEditColumn.0.isHtmlAttributes gridViewColumn.2.width gridViewColumn.2.defaultContent gridViewColumn.2.formatData gridViewColumn.2.importDefault gridViewColumn.2.filterAdditionalColumn gridViewColumn.2.defaultSortColumn gridViewColumn.2.isBoolean gridViewColumn.2.isLink gridViewColumn.2.isOther 0 gridViewColumn.2.isBinary gridViewColumn.2.isJoin gridViewColumn.2.isHtmlAttributes showGridView on showGridEdit on gridview.sqlstatementquery sqlOnUpdateFinishRecord gridEditColumn.0.fieldValue [idValueByGridEditId:geItem] gridEditColumn.0.fieldFormat gridEditColumn.0.textBoxWidth gridEditColumn.0.allowUrlInput gridEditColumn.0.fieldValueAsInsert gridEditColumn.1.separator gridEditColumn.1.trCssClass gridEditColumn.1.helpText gridEditColumn.1.multipageConditions gridEditColumn.1.isHtmlAttributes gridEditColumn.1.fieldValue [User:UserID] gridEditColumn.1.fieldFormat gridEditColumn.1.textBoxWidth gridEditColumn.1.allowUrlInput gridEditColumn.1.fieldValueAsInsert