create table INDOO_CatalogRatings_0101 (ID bigint PRIMARY KEY IDENTITY(1, 1), ItemID bigint NULL, UserID bigint NULL, Rating bigint NULL, Comment nvarchar (MAX) NULL) gridView.recordcount 1 gridView.inlineEdit version 02.00.12 connectionType 0 connectionString tablename INDOO_CatalogRatings_0101 tableKeyColumn ID gridview.bulkimport gridview.bulkexport gridview.bulkdelete gridview.insertrecord gridview.editrecord gridview.deleterecord gridview.viewrecord hidegridview gridView.hideElement 0 gridView.pagerecord hidegridviewonedit on grideditshowabovegridview editbuttonsinlastcoulumns gridedit.captionposition gridedit.checkwebpageonexit gridEdit.mode 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 gvRating gridEdit.ID gridEdit.validRedirectURLSetParameter gridEdit.validRedirectURLDelParameter gridEdit.sendToMail gridView.OrderBy gridView.SqlWhere ItemID=[getNumericObject:viewpage.gridByID("geItem").idvalue] moduleHeader <script language="javascript"> [setObject:viewPage.gridView.txt_noRecordsFound=<br>No ratings yet. Be first to rate this item.<br>] </script> moduleFooter htmlHeadBlock startupScriptBlock »setModuleVisibilityByGridId:gvRating=[compute:iif([idValueByGridEditId:geItem]<1,0,1)]« onSubmitScriptBlock sqlOnInsertRecord sqlOnUpdateRecord sqlOnViewModule sqlOnViewRecord addcreatestatement on gridViewColumn.0.columnName ItemID gridViewColumn.0.Visible gridViewColumn.0.allowExport on gridViewColumn.0.allowEdit on gridViewColumn.0.allowFilter 0 gridViewColumn.0.allowSort on gridViewColumn.0.allowImport on gridEditColumn.0.columnName ItemID gridEditColumn.0.Visible on 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 0 gridViewColumn.1.allowSort on gridViewColumn.1.allowImport on gridEditColumn.1.columnName UserID gridEditColumn.1.Visible on 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 gridEditColumn.2.Readonly gridEditColumn.3.caption gridEditColumn.3.Readonly gridViewColumn.1.width gridViewColumn.1.defaultContent gridViewColumn.1.formatData gridViewColumn.1.importDefault gridViewColumn.1.filterAdditionalColumn gridViewColumn.1.defaultSortColumn gridViewColumn.1.isBoolean gridViewColumn.1.isLink gridViewColumn.1.isOther 0 gridViewColumn.1.isBinary gridViewColumn.1.isJoin on gridViewColumn.1.isHtmlAttributes gridViewColumn.1.navigateUrlTarget _blank gridViewColumn.1.joinTableName Users gridViewColumn.1.joinTableIdColumnName UserID gridViewColumn.1.joinTableColumnName Username 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 gridViewColumn.2.rowDataColumn.1 gridViewColumn.2.rowDataPrefix.1 gridViewColumn.2.rowDataSuffix.1 gridViewColumn.2.rowDataRegexSearch.1 gridViewColumn.2.rowDataRegexReplace.1 gridViewColumn.2.rowDataConditionColumn.1 gridViewColumn.2.rowDataCondition.1 gridviewcolumn.2.rowdatahtmlencode.1 gridviewcolumn.2.rowdataurlencode.1 gridViewColumn.2.rowDataColumn.2 gridViewColumn.2.rowDataPrefix.2 gridViewColumn.2.rowDataSuffix.2 gridViewColumn.2.rowDataRegexSearch.2 gridViewColumn.2.rowDataRegexReplace.2 gridViewColumn.2.rowDataConditionColumn.2 gridViewColumn.2.rowDataCondition.2 gridviewcolumn.2.rowdatahtmlencode.2 gridviewcolumn.2.rowdataurlencode.2 gridViewColumn.2.rowDataColumn.3 gridViewColumn.2.rowDataPrefix.3 gridViewColumn.2.rowDataSuffix.3 gridViewColumn.2.rowDataRegexSearch.3 gridViewColumn.2.rowDataRegexReplace.3 gridViewColumn.2.rowDataConditionColumn.3 gridViewColumn.2.rowDataCondition.3 gridviewcolumn.2.rowdatahtmlencode.3 gridviewcolumn.2.rowdataurlencode.3 gridViewColumn.2.rowDataColumn.4 gridViewColumn.2.rowDataPrefix.4 gridViewColumn.2.rowDataSuffix.4 gridViewColumn.2.rowDataRegexSearch.4 gridViewColumn.2.rowDataRegexReplace.4 gridViewColumn.2.rowDataConditionColumn.4 gridViewColumn.2.rowDataCondition.4 gridviewcolumn.2.rowdatahtmlencode.4 gridviewcolumn.2.rowdataurlencode.4 gridViewColumn.2.rowDataColumn.5 gridViewColumn.2.rowDataPrefix.5 gridViewColumn.2.rowDataSuffix.5 gridViewColumn.2.rowDataRegexSearch.5 gridViewColumn.2.rowDataRegexReplace.5 gridViewColumn.2.rowDataConditionColumn.5 gridViewColumn.2.rowDataCondition.5 gridviewcolumn.2.rowdatahtmlencode.5 gridviewcolumn.2.rowdataurlencode.5 gridViewColumn.2.rowDataColumn.6 gridViewColumn.2.rowDataPrefix.6 gridViewColumn.2.rowDataSuffix.6 gridViewColumn.2.rowDataRegexSearch.6 gridViewColumn.2.rowDataRegexReplace.6 gridViewColumn.2.rowDataConditionColumn.6 gridViewColumn.2.rowDataCondition.6 gridviewcolumn.2.rowdatahtmlencode.6 gridviewcolumn.2.rowdataurlencode.6 gridViewColumn.2.rowDataColumn.7 gridViewColumn.2.rowDataPrefix.7 gridViewColumn.2.rowDataSuffix.7 gridViewColumn.2.rowDataRegexSearch.7 gridViewColumn.2.rowDataRegexReplace.7 gridViewColumn.2.rowDataConditionColumn.7 gridViewColumn.2.rowDataCondition.7 gridviewcolumn.2.rowdatahtmlencode.7 gridviewcolumn.2.rowdataurlencode.7 gridViewColumn.2.rowDataColumn.8 gridViewColumn.2.rowDataPrefix.8 gridViewColumn.2.rowDataSuffix.8 gridViewColumn.2.rowDataRegexSearch.8 gridViewColumn.2.rowDataRegexReplace.8 gridViewColumn.2.rowDataConditionColumn.8 gridViewColumn.2.rowDataCondition.8 gridviewcolumn.2.rowdatahtmlencode.8 gridviewcolumn.2.rowdataurlencode.8 gridViewColumn.2.rowDataColumn.9 gridViewColumn.2.rowDataPrefix.9 gridViewColumn.2.rowDataSuffix.9 gridViewColumn.2.rowDataRegexSearch.9 gridViewColumn.2.rowDataRegexReplace.9 gridViewColumn.2.rowDataConditionColumn.9 gridViewColumn.2.rowDataCondition.9 gridviewcolumn.2.rowdatahtmlencode.9 gridviewcolumn.2.rowdataurlencode.9 gridViewColumn.2.rowDataColumn.10 gridViewColumn.2.rowDataPrefix.10 gridViewColumn.2.rowDataSuffix.10 gridViewColumn.2.rowDataRegexSearch.10 gridViewColumn.2.rowDataRegexReplace.10 gridViewColumn.2.rowDataConditionColumn.10 gridViewColumn.2.rowDataCondition.10 gridviewcolumn.2.rowdatahtmlencode.10 gridviewcolumn.2.rowdataurlencode.10 notskipsqlonimport on gridEditColumn.0.separator gridEditColumn.0.trCssClass gridEditColumn.0.helpText gridEditColumn.0.multipageConditions gridEditColumn.0.isHtmlAttributes gridEditColumn.0.fieldValue gridEditColumn.0.fieldFormat gridEditColumn.0.textBoxWidth gridEditColumn.0.allowUrlInput gridEditColumn.0.fieldValueAsInsert gridEditColumn.0.DropDownList gridEditColumn.0.CustomValidator gridEditColumn.0.regExClient on gridEditColumn.0.password gridEditColumn.0.multiline gridEditColumn.0.isBoolean showGridView on showGridEdit on gridview.sqlstatementquery sqlOnUpdateFinishRecord gridView.recordcount 1 gridView.inlineEdit version 02.00.13 connectionType 0 connectionString tablename INDOO_CatalogRatings_0101 tableKeyColumn ID gridview.bulkimport gridview.bulkexport gridview.bulkdelete gridview.insertrecord gridview.editrecord gridview.deleterecord gridview.viewrecord hidegridview gridView.hideElement 0 gridView.pagerecord hidegridviewonedit on grideditshowabovegridview editbuttonsinlastcoulumns gridedit.captionposition gridedit.checkwebpageonexit gridEdit.mode 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 gvRating gridEdit.ID gridEdit.validRedirectURLSetParameter gridEdit.validRedirectURLDelParameter gridEdit.sendToMail gridView.OrderBy gridView.SqlWhere ItemID=[getNumericObject:viewpage.gridByID("geItem").idvalue] moduleHeader <script language="javascript"> [setObject:viewPage.gridView.txt_noRecordsFound=<br>No ratings yet. Be first to rate this item.<br>] </script> moduleFooter htmlHeadBlock startupScriptBlock »setModuleVisibilityByGridId:gvRating=[compute:iif([idValueByGridEditId:geItem]<1,0,1)]« onSubmitScriptBlock sqlOnInsertRecord sqlOnUpdateRecord sqlOnViewModule sqlOnViewRecord addcreatestatement on gridViewColumn.0.columnName ItemID gridViewColumn.0.Visible gridViewColumn.0.allowExport on gridViewColumn.0.allowEdit on gridViewColumn.0.allowFilter 0 gridViewColumn.0.allowSort on gridViewColumn.0.allowImport on gridEditColumn.0.columnName ItemID gridEditColumn.0.Visible on 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 0 gridViewColumn.1.allowSort on gridViewColumn.1.allowImport on gridEditColumn.1.columnName UserID gridEditColumn.1.Visible on 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 gridEditColumn.2.Readonly gridEditColumn.3.caption gridEditColumn.3.Readonly gridViewColumn.1.width gridViewColumn.1.defaultContent gridViewColumn.1.formatData gridViewColumn.1.importDefault gridViewColumn.1.filterAdditionalColumn gridViewColumn.1.defaultSortColumn gridViewColumn.1.isBoolean gridViewColumn.1.isLink gridViewColumn.1.isOther 0 gridViewColumn.1.isBinary gridViewColumn.1.isJoin on gridViewColumn.1.isHtmlAttributes gridViewColumn.1.navigateUrlTarget _blank gridViewColumn.1.joinTableName Users gridViewColumn.1.joinTableIdColumnName UserID gridViewColumn.1.joinTableColumnName Username 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 gridViewColumn.2.rowDataColumn.1 gridViewColumn.2.rowDataPrefix.1 gridViewColumn.2.rowDataSuffix.1 gridViewColumn.2.rowDataRegexSearch.1 gridViewColumn.2.rowDataRegexReplace.1 gridViewColumn.2.rowDataConditionColumn.1 gridViewColumn.2.rowDataCondition.1 gridviewcolumn.2.rowdatahtmlencode.1 gridviewcolumn.2.rowdataurlencode.1 gridViewColumn.2.rowDataColumn.2 gridViewColumn.2.rowDataPrefix.2 gridViewColumn.2.rowDataSuffix.2 gridViewColumn.2.rowDataRegexSearch.2 gridViewColumn.2.rowDataRegexReplace.2 gridViewColumn.2.rowDataConditionColumn.2 gridViewColumn.2.rowDataCondition.2 gridviewcolumn.2.rowdatahtmlencode.2 gridviewcolumn.2.rowdataurlencode.2 gridViewColumn.2.rowDataColumn.3 gridViewColumn.2.rowDataPrefix.3 gridViewColumn.2.rowDataSuffix.3 gridViewColumn.2.rowDataRegexSearch.3 gridViewColumn.2.rowDataRegexReplace.3 gridViewColumn.2.rowDataConditionColumn.3 gridViewColumn.2.rowDataCondition.3 gridviewcolumn.2.rowdatahtmlencode.3 gridviewcolumn.2.rowdataurlencode.3 gridViewColumn.2.rowDataColumn.4 gridViewColumn.2.rowDataPrefix.4 gridViewColumn.2.rowDataSuffix.4 gridViewColumn.2.rowDataRegexSearch.4 gridViewColumn.2.rowDataRegexReplace.4 gridViewColumn.2.rowDataConditionColumn.4 gridViewColumn.2.rowDataCondition.4 gridviewcolumn.2.rowdatahtmlencode.4 gridviewcolumn.2.rowdataurlencode.4 gridViewColumn.2.rowDataColumn.5 gridViewColumn.2.rowDataPrefix.5 gridViewColumn.2.rowDataSuffix.5 gridViewColumn.2.rowDataRegexSearch.5 gridViewColumn.2.rowDataRegexReplace.5 gridViewColumn.2.rowDataConditionColumn.5 gridViewColumn.2.rowDataCondition.5 gridviewcolumn.2.rowdatahtmlencode.5 gridviewcolumn.2.rowdataurlencode.5 gridViewColumn.2.rowDataColumn.6 gridViewColumn.2.rowDataPrefix.6 gridViewColumn.2.rowDataSuffix.6 gridViewColumn.2.rowDataRegexSearch.6 gridViewColumn.2.rowDataRegexReplace.6 gridViewColumn.2.rowDataConditionColumn.6 gridViewColumn.2.rowDataCondition.6 gridviewcolumn.2.rowdatahtmlencode.6 gridviewcolumn.2.rowdataurlencode.6 gridViewColumn.2.rowDataColumn.7 gridViewColumn.2.rowDataPrefix.7 gridViewColumn.2.rowDataSuffix.7 gridViewColumn.2.rowDataRegexSearch.7 gridViewColumn.2.rowDataRegexReplace.7 gridViewColumn.2.rowDataConditionColumn.7 gridViewColumn.2.rowDataCondition.7 gridviewcolumn.2.rowdatahtmlencode.7 gridviewcolumn.2.rowdataurlencode.7 gridViewColumn.2.rowDataColumn.8 gridViewColumn.2.rowDataPrefix.8 gridViewColumn.2.rowDataSuffix.8 gridViewColumn.2.rowDataRegexSearch.8 gridViewColumn.2.rowDataRegexReplace.8 gridViewColumn.2.rowDataConditionColumn.8 gridViewColumn.2.rowDataCondition.8 gridviewcolumn.2.rowdatahtmlencode.8 gridviewcolumn.2.rowdataurlencode.8 gridViewColumn.2.rowDataColumn.9 gridViewColumn.2.rowDataPrefix.9 gridViewColumn.2.rowDataSuffix.9 gridViewColumn.2.rowDataRegexSearch.9 gridViewColumn.2.rowDataRegexReplace.9 gridViewColumn.2.rowDataConditionColumn.9 gridViewColumn.2.rowDataCondition.9 gridviewcolumn.2.rowdatahtmlencode.9 gridviewcolumn.2.rowdataurlencode.9 gridViewColumn.2.rowDataColumn.10 gridViewColumn.2.rowDataPrefix.10 gridViewColumn.2.rowDataSuffix.10 gridViewColumn.2.rowDataRegexSearch.10 gridViewColumn.2.rowDataRegexReplace.10 gridViewColumn.2.rowDataConditionColumn.10 gridViewColumn.2.rowDataCondition.10 gridviewcolumn.2.rowdatahtmlencode.10 gridviewcolumn.2.rowdataurlencode.10 notskipsqlonimport on gridEditColumn.0.separator gridEditColumn.0.trCssClass gridEditColumn.0.helpText gridEditColumn.0.multipageConditions gridEditColumn.0.isHtmlAttributes gridEditColumn.0.fieldValue gridEditColumn.0.fieldFormat gridEditColumn.0.textBoxWidth gridEditColumn.0.allowUrlInput gridEditColumn.0.fieldValueAsInsert gridEditColumn.0.DropDownList gridEditColumn.0.CustomValidator gridEditColumn.0.regExClient on gridEditColumn.0.password gridEditColumn.0.multiline gridEditColumn.0.isBoolean showGridView on showGridEdit on gridview.sqlstatementquery sqlOnUpdateFinishRecord